summing unique values in 2 seperate footers

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

Guest

i have a report with 2 sorts and 2 footers.
i need to count unique values over the whole group.
i can use a text box control to =1 and sum over group option, however, i am
only interested in the very last entry that method produces.
I do not want to use report footer because that will be used for the report
totals.
I need a way to count unique values from a sort footer. Any ideas?
here is the way data comes over...

customer_id order_id revenue
ABC 123 $50
ABC 123 $45

ABC 234 $35
ABC 234 $45
ABC 234 $55

ABC 345 $100

So i would need to show ABC had 3 orders that totaled $330.
Thanks
 
There have been at least three similar questions in the last week.

Add a text box to your Order_ID header section:
Name: txtCountOrders
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to your report footer section
Control Source: =txtCountOrders

To total the Revenue, use a text box with a control source of:
Control Source: =Sum(Revenue)
 
its not quite the same...as stated, i do not want to use the report footer.
That will be used for totaling the entire report. I guess i should give more
detail.

ABC 123 $50
ABC 123 $45

ABC 234 $35
ABC 234 $45
ABC 234 $55

ABC 345 $100

WOW 567 $100

WOW 678 $45
WOW 678 $55

so i end up with one footer showing

ABC 3 $330
WOW 2 $200

and my report footer saved for

2 5 $530
 
========
so i end up with one footer showing

ABC 3 $330
WOW 2 $200
========
I assume this is in your report footer. Regardless, you can create a
subreport based on a totals query that groups by totals to get the values
you need. Add the subreport to a section in your main report.
 
Back
Top