count of totals

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Having trouble getting count of a couple different total
fields in a report. There are 3 'groups' and
5 'subgroups' within each group. I need a total for each
group and count for each element in the 'subgroup'. For
instance:

Group1 Total Group 1 ______
aaa Total aaa_____
bbb Total bbb_____
ccc Total ccc_____
ddd Total ddd_____
eee Total eee_____
Group2 Total Group 2 _____
aaa total aaa____
bbb Total bbb___
ccc Total ccc____
ddd Total ddd____
eee Total eee____

If I put =count(*) in the group footer, gives running
total of each group, adding group 2's count to group 1.
If I put it the detail, I just get total of all detail on
each one, for instance if I have 100 records, each says
100. Advise?
 
Hi Mike.
How about create a report grouped by 1 Grouping, and 2
SubGrouping.
In group 1 set a report group header
and for the SubGrouping set a report group footer.
In the header put a textbox for the Group and another
unbound textbox and write in it "=Sum([WhateverYouWant
toTotal])" and an other textbox with "=Count()"
omit the " (quotes)
Similarly create necessary textboxes in the SubGroup
footer.
That should do it for you.
Hope this helps.
Fons
 
Back
Top