Page numbering and Subreports

[JustineB]

I have a report with a subreport. The subreport holds all of the main details of the report.

As the subreport doesn't have page footers, I am using a Group footer instead.

I need to display page 'n of m' in the Group header. This works perfectly for customers with only 1 page, always says '1 of 1', but with multiple pages, the 1st page always says '1 of 1' regardless (all subsequent pages are correctly numbered - '2 of 3', '3 of 3' etc.).

I have checked the 'reset pagenumber after' in the Group Footer.
There are 4 details sections (all conditionally suppressed). In the 'Details' section (rather than details a, details b) I have 'New page after' checked with a formula to make sure that only 35 rows are returned before a page break:

remainder(recordnumber, 35) = 0 and (not on lastrecord)

Does anyone have any idea why the totalpagecount won't work?

I am using Crystal v. 8.5 and connecting via ODBC to a SQL Server Database.

Many thanks,
Justine

 

[lbass]

Is all the above formatting being applied within the subreport? It's a good practice to preface references to subreport sections with the word "subreport" to prevent confusion.

It would also help to know where you have the subreport placed in the main report, how it is linked (if it is) to the main report, and any formatting you have done to main report sections.

-LB