COUNTING PAGES FOR EACH GROUP IN A REPORT. 1

[ZaZa]

Hi everyone,

I'm having some trouble with the pagecount of my report.Please help if you can.

My report has the following sections:
ReportHeader
PageHeader
GroupHeader0
GroupHeader1
Details
PageFooter

I used a report wizzard and the report prints a reading list for several employees and catagorizes the reading list by type of book etc. Hence, I have the field [Personnel] in the GroupHeader0 section and the field [ReadingCatagories] in the GroupHeader1 section. For the GroupHeader0 section, I made it force a new page so that the records for each employee starts on a new page.

It works fine but on the PageFooter section, it counts and prints page numbers for ALL the pages of the Report. SO if there are 120 pages in the entire report it says something like "page 4 of 120"

I want to be able to :
a) Start the numbering of the pages from 0 for each new group in GroupHeader0 ( ie each new Employee). I want to have the something that says "page 5 of 10", where 10 refers to only the TOTAL NO. OF PAGES IN THE PRESENT GROUP ( ie the total no of pages for the fist employee only).
b) after all the records for the group has been printed( ie after the reading list for the first employee has been printed), I want to set the page count to 0 and start counting the pages again for the next reading list for The second employee.

I'm not good at making reports so I will really appreciate any help you can send my way.

Thanks in advance,
ZaZa

 

[CosmoKramer]

see thread181-90868

 

[ZaZa]

Hi CosmoKramer,

I have seen that code before in my search for an answer but unfortunately, I haven't been able to get beyond the line:
"Open any report in design view and open it's Code-behind-reports module."

Where does the writer want me to go exactly??On which event on which section should I put this??

Sorry if I appear a bit thick.

ZaZa