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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show Record Count in Header - Crystal XI

Status
Not open for further replies.

CarolCook

IS-IT--Management
Mar 7, 2003
158
US
Hi:
I have a report which produces data for an upload that lists check and invoice detail. The header for the report requires the number of checks. I need a two pass report and a formula which calculates the number of checks whilereadingrecords and can be used in the report header. Did this once and promptly forgot how it's done!
Thanks in advance,
Carol
 
Right click on the check# field and insert a summary (distinctcount). This will appear in the report footer, but in design mode you can drag it to the report header.

Alternatively, you can write a formula:

distinctcount({table.check#})

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top