how to reset page number within a report (one report containing many multi page invoices)

I am new to Infragistics reporting and am struggling to meet my requirement.

I have a system that has many employers.

Each employer has many clients

I need to generate many invoices for each client and bunch them up into the one report for a given employer.

I can almost get this work brilliantly using a report design that groups records by invoice number and running it for each employer.

The stumbling block that I have is with the page numbering on each multi page invoice. I have to show/hide fields depending upon whether the invoice is a one page invoice or a multi page invoice.

I can only see the global page number variables but I need to reset them after each invoice (ie each time the invoice group footer is rendered, the page number needs to reset to zero rather than increment by one).

eg My report will run for Employer XYZ and will contain the following invoices:

Client1 Invoice1 (two pages, numbered 1, 2)

Client1 Invoice2 (one page, no number shown)

Client2 Invoice3 (three pages numbered 1,2,3)

I can get a page break after each invoice to keep them separate, no problem, but the page numbers will go 1,2,3,4,5,6 and I can’t hide the page count for the one page invoice because I only have the global report page count, which is 6.

I would then e-mail the PDF to the employer who then prints out each invoice and posts to their client.

I have struggled hard to get this far and am about to give up and use Crystal Reports, which would be a shame.

I guess I need GroupPageNumber”  and “GroupPageCount” variables, but I can’t see how to get them.

Hi Graeme,

Page numbers are solved automatically by the reporting engine so unfortunately there is no way to modify them externally.  This would require an internal change to the product.

Since this is not currently supported this is a great candidate for a new product idea.  If you'd like to see this idea implemented in the future, please head on over to our new products idea website and add an entry for it under Reporting. http://ideas.infragistics.com/

Let me know if you have any questions on this.

Hi Graeme,

Let me know if you have any further questions on this matter.

Hi Rob

Thanks for your reply. 

I have added my idea as you suggested and am told that it is under consideration.

In the end I had to opt for a Crystal Report as Crystal already includes this functionality.

I used the free visual studio add in version of Crystal.