Group Totals

[R Kumana]

I have a report that groups records according to a type.
there are four types, represented by a text value.

At the end of the grouping level, I want to list the total
number of records of each type.

Totals
Type 1: 6
Type 2: 12
Type 3: 24
Type 4: 9
Total: 51

I can get the final total using "Count" on all the
records, but I can't get the subtotals. How do I do this?

 

[Duane Hookom]

I assume you want this in either a report footer or footer after your Type
Footer.
Create a query that groups by Type and counts records. Use this query as the
record source of a subreport. Add the subreport to the footer of your main
report.

 

[R Kumana]

I created the query and Subreport, but when I view my main
report, the subreport shows a blank space.

?

 

[Duane Hookom]

Make sure there are no values in the Link Master/Child properties of the
subreport.