place total number of records in report header

[Lhuffst]

I am using crystal 8.5 and have to place the total number of records for the report in the header. I had it as a running total in the report footer but user insists that they want to see it up front and on all pages.

1. I tried to copy the running total to the header but that didn't work.
2. I put a text box called recCnt in the header and used this formula:
WhilePrintingRecords;
numbervar recCnt;

recCnt := {#RTRecords}//the running total field

What happens is that on page 1 it prints 1. On the last page it prints the correct number of records. How can I get that value to print on all the pages?


Thanks Lhuffst

 

[IanWaterman]

RTs need to evaluate all data and can not be displayed in report header.

Instead of an RT You can also use a formula in detail

If Conditions in RT = true then 1 else 0

YOu can then do a normal sum on this formula and it will display in the report header.

Ian

 

[Lhuffst]

that worked great. Thanks