count groups, not records in a group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with several grouping fields.
I want to know how to count the number of subgroups in a group (rather than
the number of records in a subgroup).

Thank you!
 
Greenfield said:
I have a report with several grouping fields.
I want to know how to count the number of subgroups in a group (rather than
the number of records in a subgroup).
Click to expand...


Add a text box to the inner group's footer section. Set its
expression to =1 and RunningSum property to Over Group.

The next higher group level's footer can then display the
count of inner groups by just referring to the running sum
text box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Higher Level Subgroup 1
Total Values 5
Sort on 2nd group, not first 5
Calculate percentages for groups and subgroups 1
Grouping 1
Charts generated from within a subgroup 4
Sum, Average, and Count from imported .txt file 2
count of totals 1

Back
Top