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.