Report groups and subgroups

[imstuck]

I am trying to create a report that counts the number of records for a particular category and type, but also gives me a total for the category itself and then at the end a grand total.

Example:

Cat 1 Type A 5
Cat 1 Type B 2
Cat 1 Type C 9

Category 1 total 16

Cat 2 Type X 3
Cat 2 Type Y 6
Cat 2 Type Z 4

Category 2 total 13

Grand Total 29

I'm having trouble with my groupings. I have the report sorted by category, then type and I have a field in the detail section called recordcount with a controlsource of =1. I placed a text field in the type footer with a controlsource of recordcount so the totals for the types work. But I can't get the totals for the categories to work.

Is there a way to handle that? Thanks!




[sig][/sig]

 

[Quehay]

If you put a textbox with source based on an aggregate function in the section footer, e.g. txt=Sum([catgtot]) it will give the figure for each group. If you do the same in the report header or footer it will give you the overall sum. (Go to the grouping dialogue to set Group footer to "yes" if it's not there already.) [sig][/sig]