Hi Spencer.

Add three invisible fields to report, not needed in form.
Add programming:
if selection = Beef, field1=1, else 0
if selection = Chicken, field2=1, else 0
if selection = Fish, field3=1, else 0

Add group totals for fields 1,2,3

OK -

I forgot about the "static" text boxes - so I used one of those before each "sum" to indicate what it is.  So now I get

B = 33   C = 168   F = 40

It's not "purty" like I wanted but at least it provides the information.  

I really wanted the figures below each other directly below the Entree column such as:  

B = 33
C = 168
F = 40

but don't see any way to do that.  If anyone knows of a way, to have more control over what appears where, I would appreciate knowing about it.

Also, the new report (generator/writer/whatever it's called) was mentioned quite a while ago.  Is there any word on when it will be available?

Thanks y'all!

Bob - I especially want to thank you once again for pointing me in the right direction.  While not "perfect" (by my own personal standards) I do at least have a viable, presentable report. Thank you - Thank you!!!

Erika -

This raises several questions for me.

Similar to wanting the Beef, Chicken & Fish labels & sub-totals to come out one under each other in the footer, I also wanted to split the header Amount Paid into two lines.

1)  I tried adding another view header but it came out at the end of the report --- do I have to add a group (and I assume make it "invisible") to put the view header where I want it?

2) I tried putting Amount<br>Paid in the header but when the break occurred, the word "Amount" went to the beginning of the next line (instead of staying within the column) and then pushed everything forward after that.  I'm assuming that if I use the <br> in the footer, the same thing will happen.

3)  My columns are not staying lined up with the respective headings.  Any way to make it happen?  (Seems to me I did it in another report - but I looked at the report design and can't tell what made it come out right).

4) Any word on the new report generator/writer?

Thanks!

Erika -

Thanks to your help (in addition to Bob's), I am making great strides with my report - and my report capabilities in general.

You were, of course, right that I was using the View Header instead of the Group Header.  By changing to the Group Header, I was able to break (using <br>) my column headings the way I wanted them and the headings and columns are now aligned.  Bravo!

As for the Beef, Chicken & Fish labels & subtotals coming out under each other in the footer, I tried adding additional groups & footers but was unable to get the results I wanted.

That leaves me with one last (I hope) question.

You said earlier that:

Quote:


I added the unbound value box.  I assumed that I would "assemble all the labels and numbers" into that box using a programming statement but was unable to come up with one that would work.  Could you please be more specific about how to try this approach?

I am (as I'm sure other's are as well) eagerly looking forward to the release of Version 2.

Since you are doing the totaling of the entree choice in a summary calculation element and not in code, you need to assemble your unbound value box in the next group footer. If you get Inside Sesame, I know Tom explained this last issue. Page 15. Left hand column.

Ex. GF means Group Footer
GF2 Invisible Summary elements go here
GF1 Unbound value box here can use the values in the summary elements up above.

The reason for this is because a report section runs it's programming before it runs the summary calculations and breaks.

-Ray