Subreport page numbers

  • Thread starter Thread starter anjee
  • Start date Start date
A

anjee

Hello,

I have a report that includes a subreport in the Report Footer. The
subreport is simply a Page Break and a Textbox. The Textbox's
property is set to grow as this information can span multiple pages.

I need to be able to print the main report's Page Footer on the last
page of the main report ONLY, and then have the subreport print
thereafter.

I thought about retrieving the Pages number of the subreport and
subtract that value from the total number of pages but I cannot seem
to retrieve this value. The following always returns 0 when set as
the recordsource of a text box on the main report (note that txtPages
is set to [Pages]).
=[subreportchild].[Report]![txtPages]

Is there any way that I can accomplish this? Thanks for the help.
 
Subreports do not have any knowledge of pages. The paging and page
number is controlled by the main report.

You M I G H T be able to reset the page numbering by grabbing the page
number of the last detail printed from the main report and shoving that
into a variable and then using that to control page numbering and the
visibility of the page footer. I've never tried this idea, so it is up
to you to test it out.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Subreports do not have any knowledge of pages. The paging and page
number is controlled by the main report.

You M I G H T be able to reset the page numbering by grabbing the page
number of the last detail printed from the main report and shoving that
into a variable and then using that to control page numbering and the
visibility of the page footer. I've never tried this idea, so it is up
to you to test it out.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Hello,
Click to expand...
I have a report that includes a subreport in the Report Footer. The
subreport is simply a Page Break and a Textbox. The Textbox's
property is set to grow as this information can span multiple pages.
Click to expand...
I need to be able to print the main report's Page Footer on the last
page of the main report ONLY, and then have the subreport print
thereafter.
Click to expand...
I thought about retrieving the Pages number of the subreport and
subtract that value from the total number of pages but I cannot seem
to retrieve this value. The following always returns 0 when set as
the recordsource of a text box on the main report (note that txtPages
is set to [Pages]).
=[subreportchild].[Report]![txtPages]
Click to expand...
Is there any way that I can accomplish this? Thanks for the help.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Yes I did try to retrieve the page number from the format event of the
detail section, however [Pages] is set to the total report page number.
 
Not the pages property, the PAGE property. The problem I foresee here
is that the Page property will change as the section is repeatedly
printed so it would have to be trapped the first time the last record in
the detail section was formatted.

As I said this has a good chance of failing, but that is the first thing
I would attempt.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Subreports do not have any knowledge of pages. The paging and page
number is controlled by the main report.

You M I G H T be able to reset the page numbering by grabbing the page
number of the last detail printed from the main report and shoving that
into a variable and then using that to control page numbering and the
visibility of the page footer. I've never tried this idea, so it is up
to you to test it out.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Hello,
I have a report that includes a subreport in the Report Footer. The
subreport is simply a Page Break and a Textbox. The Textbox's
property is set to grow as this information can span multiple pages.
I need to be able to print the main report's Page Footer on the last
page of the main report ONLY, and then have the subreport print
thereafter.
I thought about retrieving the Pages number of the subreport and
subtract that value from the total number of pages but I cannot seem
to retrieve this value. The following always returns 0 when set as
the recordsource of a text box on the main report (note that txtPages
is set to [Pages]).
=[subreportchild].[Report]![txtPages]
Is there any way that I can accomplish this? Thanks for the help.- Hide quoted text -
Click to expand...
- Show quoted text -
Click to expand...

Yes I did try to retrieve the page number from the format event of the
detail section, however [Pages] is set to the total report page number.
Click to expand...
 
Back
Top