I have a report structured in the following manner:

Report Header
Page Header
Group Header (Total Page Count for each group)
Details
Group Footer
Page Footer (Page N of M for each detail)
Report Footer

I'm trying to get two independent page counts working. The first is a "Total Page Count" for each group and appears in the group header. The second is a "Page N of M" for the details section and appears in the page footer. The problem is that the two counts can't be reset independently, so only one will work at a given time. Does anyone know how to solve this issue? Thanks in advance.

Edited by mjsmith - 20 Nov 2013 at 9:39am

Thanks for the response! I made a mistake in my original post. The Page N of M should have been in the Page Footer. I've corrected it now.

Could you please go into more detail about how to use a variable to solve the problem?

Each group in the report is a fax recipient and each detail record is a collection of several subreports that collectively form one or more documents to be faxed. Here's an example of a report with five records and two recipients broken down by page along with the desired page number print-out in parenthesis:

Fax Cover Sheet to Recipient X (7 Total Pages) Group Header 1
First Fax (Page 1 of 2) Detail 1
First Fax (Page 2 of 2) Detail 1
Second Fax (Page 1 of 3) Detail 2
Second Fax (Page 2 of 3) Detail 2
Second Fax (Page 3 of 3) Detail 2
Third Fax (Page 1 of 1) Detail 3
Fax Cover Sheet to Recipient Y (4 Total Pages) Group Header 2
Fourth Fax (Page 1 of 1) Detail 4
Fifth Fax (Page 1 of 2) Detail 5
Fifth Fax (Page 2 of 2) Detail 5

Of course the ideal solution would allow for any number of details records grouped into any number of recipients. As I mentioned before, the two page counts need to operate independently of each other, but resetting the page count will reset both. Thanks again for your response.

Edited by mjsmith - 20 Nov 2013 at 9:43am

Sastry,

Thanks a lot for your detailed reply!

Unfortunately, the solution you provided only works if there is one detail per page. In most cases, there will be three to four pages per record, so what I really need to count is pages and not records.

Please let me know if you have any other solutions. Thanks again!

Edited by mjsmith - 21 Nov 2013 at 6:56am

Thanks for the reply! I'm using Crystal Reports 2008 Version 12.0.0.549.

In section expert, I am able to reset the page number for the group, which gives me the correct Total Page Count for the cover sheet, or for the details, which gives me the correct Page N of M page counts for the individual sections, but only one will work at a time.

I'm not sure what you mean by changing the numbering in the group header and details section. Could you please elaborate?

Thank you!

Thanks for the reply, I understand now. Resetting the page number anywhere in the Section Expert (Report/Page/Group/Detail) resets it globally, so setting the page number to be reset in the Details and the Group resets it twice for both.

I'm not sure if there is a bug in CR or there's something that I'm missing, but Sastry's response seems like it should work if the @pcount formula is placed in the page footer instead of the details view, but despite being printed on every page, it is only incremented once per record.

Thanks again.

Edited by mjsmith - 21 Nov 2013 at 11:26am