Report Header record count

[MadCatmk2]

Hi all

Crystal 8
SQL Server

This hopefully will be a simple one for someone to answer. I have a report which lists calls from a helpdesk system. Is it possible for a count of all the records to be shown in the report header. I have tried doing this with a running total but i never get the value showing in the header. If anyone can shed some light on if this is possible or not and how to go about doing it if so.

Thanks in advance.

 

[MrTBC]

I think you can just use:

Insert / Field Object / Special Objects / Record Number

 

[dgillz]

write a formula to count the records:

if not isnull({AnyRequiredField}) then 1 else 0

Perform a simple grand total of this formula. You can suppress the formula and the grand total if so desired.

The create a second formula to be placed in the page header:

WhilePrintingRecords;
Numbervar DispTotCount:=Sum ({@YourFormulaField})

viola! Grand total count in the page header.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

You should be able to insert a grand total (count) on a recurring field (one that cannot be null) and then drag this into the report header.

-LB

 

[MadCatmk2]

thanks for all your help guys. Got it working.

cheers