eeyo
asked on
How do I add a Row Count in the Page Footer Section that counts the number of rows on the current page?
How do I add a Row Count in the Page Footer Section that counts the number of rows on the current page? I can create a total report count in the Report Footer, but what I need is to have it summarized per page. I am using Crystal XI (and also 2008) stand alone.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You simply place the formula in the Group Header. Anywhere in that section. You can suppress the formula, so it's not visible.
ASKER
I am one step closer but the math doesn't seem to work. I get 0 for the header, 1 for each of the rows in the detail section (instead of incrementing), and I get a page footer total of 1 (instead of actual number of rows on the page). Any thoughts?
Formula for the Page Header
Formula for the details
Formula for the Page Footer
Formula for the Page Header
Global RowCount as Number
RowCount = 0
formula = RowCount
Formula for the details
Global RowCount as number
RowCount = Rowcount + 1
formula = RowCount
Formula for the Page Footer
Global RowCount as number
formula = RowCount
The assignment operator is ':='
You are using '=' instead.
You are using '=' instead.
ASKER
Sorry, I forget to specify that I am using Basic Syntax instead of Crystal Syntax. I guess I could try with Crystal Syntax, but I think it is something else. All three formulas verify OK when I using the formula verification button.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, as James suggested, use WhilePrintingRecords.
ASKER
Using a mulit-section global variable and WhilePrintingRecords solved this problem. Thanks!
ASKER