Page number in sub report

building reports crystal reports
1

Since subreports have np page header or page footer section…

Any ideas on how to get a “Page x of y” into a subreport so that it displays at the bottom of each page ?

Thanks

mountainman (BOB member since 2008-09-02)

2

Hi,

In order to get the page numbers in sub report please follow the following steps:

  1. Create a formula called “PageNumber” in subreport.
  2. Write the following code for the formula:
    Whilereadingrecords;
    “”
  3. Save the formula.
  4. Now create a group in the sub report based on the formula(“pagenumber”).
  5. Now go to view menu>>Field Explorer.
  6. Expand Special Field Node.
  7. Select Page N of M. Place this field in the Group Header of the group created in step 4.
  8. Now go to Report menu>>Group Expert.
  9. Select Pagenumber from Group By list box.
  10. Click Options button.
  11. Click Option Tab.
  12. Check “Repeat Group Header on Each Page”.
  13. Click OK.
  14. Click OK.
  15. Preview the sub report and main report.

Cheers!!!
Manish Tiwari

cr_manish :india: (BOB member since 2009-07-30)

3

Awesome !!!

Thanks so much !

mountainman (BOB member since 2008-09-02)