• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

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.
0
eeyo
Asked:
eeyo
  • 4
  • 4
2 Solutions
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Use a variable. Reset it to 0 in a Page Header formula. Increment it in a detail section or group section formula, and display it in a page footer formula.
0
 
eeyoAuthor Commented:
Use a variable. Reset it to 0 in a Page Header formula. Increment it in a detail section or group section formula, and display it in a page footer formula.
Newbie question:  I have created formulas, but where do I put the formula in the page header?  Do I use Section Expert and click one of the X-2 buttons?
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
You simply place the formula in the Group Header.  Anywhere in that section.  You can suppress the formula, so it's not visible.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
eeyoAuthor Commented:
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
Global RowCount as Number
RowCount = 0
formula = RowCount

Open in new window


Formula for the details
Global RowCount as number
RowCount = Rowcount + 1
formula = RowCount

Open in new window


Formula for the Page Footer
Global RowCount as number
formula = RowCount

Open in new window

0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
The assignment operator is ':='
You are using '=' instead.
0
 
eeyoAuthor Commented:
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.
0
 
James0628Commented:
Try adding WhilePrintingRecords as the first line in each formula.  Since you're not referencing any db fields in the detail formula, CR defaults to evaluating it once, before the records are read (even if you put the formula in the detail section).  Adding WhilePrintingRecords to the detail formula (and putting the formula in the detail section) forces CR to (re)evaluate the formula when it "prints" each record.

 And if you add WhilePrintingRecords to the detail formula, you need to add it to the others too, so that all of the formulas are evaluated during the same pass through the report.  Otherwise, your count isn't reset in the page header, or you don't get the total in the page footer, because those formulas are evaluated before the "printing" pass.

 FWIW, what got me on to this was a note in the CR Help about using WhileReadingRecords (as opposed to WhilePrintingRecords) to force a formula to be evaluated as the records are read, but WhileReadingRecords didn't work for me (the count still wasn't incremented).  I don't know why.  So I tried WhilePrintingRecords instead and that seemed to work fine.  <shrug>

 James
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Yes, as James suggested, use WhilePrintingRecords.
0
 
eeyoAuthor Commented:
Using a mulit-section global variable and WhilePrintingRecords solved this problem.  Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now