Displaying Number of Records

[sim133]

HI all,
Is there way to display the total number of records on each page footer using Crystal Report. I know it is possible to display it on the report footer, but the customer wants see the total number of records on each page footer. I am using Crystal XI.
Thank You..

 

[Turkbear]

Hi,
The special field Page N of M does that..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

If you literally mean you want the report total number of records displayed on every page, create a formula:

count({table.field})

Make sure that that {table.field} is a recurring field (is never null). Place the formula in the page footer.

-LB

 

[dgillz]

LB's formula will not reset on each page however. If this is desired, then use the3 formula approach with variables.

In the page header:
WhilePrintingRecords;
Numbervar records:=0

In the details section:
WhilePrintingRecords;
Numbervar records:=records+1

In the page footer:
WhilePrintingRecords;
numbervar records;

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

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Turkbear]

Hi,
Sorry for my mis-reading of the posting ( It is Friday afternoon and I sometimes get sloppy..I thought the # of pages was needed, not the recoprd count..)

( Its also April 6 and a freakin' 20 degrees F out there.. with a 3 degree wind chill( Minnesota))





To Paraphrase:"The Help you get is proportional to the Help you give.."