Report totalling help needed

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

Guest

I have a report which prints sub-totals and grand-totals at the end of the
report. In the sub-totals I have to print a total which represents items that
are not listed in the report. I get this total by doing a join that puts the
total in every row in the sub totalled group.
My problem is how to do the grand totals. I can't just sum the control
source because these values repeat in every row and the grand total would be
way too high. What I need to somehow do is the total the subtotals as they
are printed and get that value in the grand total. Anyone done this and knows
how?
 
mscertified said:
I have a report which prints sub-totals and grand-totals at the end of the
report. In the sub-totals I have to print a total which represents items that
are not listed in the report. I get this total by doing a join that puts the
total in every row in the sub totalled group.
My problem is how to do the grand totals. I can't just sum the control
source because these values repeat in every row and the grand total would be
way too high. What I need to somehow do is the total the subtotals as they
are printed and get that value in the grand total.
Click to expand...


The otheritems text box in the group footer should be bound
to the value in the query. Set this text box's RunningSum
property to Over All.

Now the grand total in the report footer section can display
the total by just referring to the otheritems text box.
 
That does not work. As I said the value is in every row for the group, if I
put SUM(column), it totals all these values instead of just the value that
appears in the group footer. Here is an illustration
Group A Item 1 Count = 5
Group A Item 2 Count = 5
Footer: Num=2 Count =5
Group B Item 1 Count = 2
Footer: Num = 1 Count = 2

Grand Total: Num = 3 Count = 7 (This is what I want)
Using your method I get Count = 12 (5+5+2)

Count represents a count of records that are NOT printed, it is related to
the Group as a whole.
 
That's not what I said. Put the running sum text box on the
GROUP FOOTER section, not the detail section.
 
Back
Top