Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

Need to pass the Page N of M from a subreport so that it will flow into the Main Report Body.

I have a subreport inside of a main report and need to make sure the  pages flow correctly. The sub report starts in the Report header of the Main report. It usually only prints 1 or 2 pages but then goes into several pages processed in the main body of the report. How can I get the page numbers to flow correctly so that the total page count show up and prints correctly and the user does not see a break in the page numbering.
Also curiously does this hinder performace when running against larger databases.
Current Example
Subreport shows Page 1 of 1
Main Report shows Page 2 of 4
When scrolling through the pages.
What I need to see of course is Page 1 of 4 , Page 2 of 4, Page 3 of 4, Page 4 of 4 etc. Please help.
ASKER CERTIFIED SOLUTION
Avatar of crgary_tx
crgary_tx
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

I still am not sure about what the @RH formula means and while reading records.
I did exactly what you said and the first page of the report is showing
"Page 1 of 1" then page two shows "Page 1 of 7" the
actual should be on page one "Page 1 of 8"
 Do you know why I am getting the breakup?