Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating group distinctcount total

Status
Not open for further replies.

veles

Technical User
Sep 1, 2006
57
CA
Hi,
I need help with a calculation. I have a group that I am filtering out with a group selection formula.
I am using a running total that resets at the group level and I get the right count in the group footer. I know I can't use the running total in the header.
Is there a workaround to display the distinctcount in the header. If I use a sum I get the number of all records ignoring the filter.

I hope it's not confusing and any help is appreciated.

Thanks
 
You would have to save the report as a subreport which you then insert in the group header, suppressing all sections except the footer which contains the rt. Link the sub to the main report on the group field.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top