[AccessD] Page numbers in Subreport

[Jim Lawrence]

Brilliant.

Jim

----- Original Message -----
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Cc: "Jim Dettman" <jimdettman at verizon.net>
Sent: Monday, May 27, 2019 12:51:58 AM
Subject: Re: [AccessD] Page numbers in Subreport

Thanks everyone for your suggestions.  My final solution was simple in the
end.  I put a control in the main report page footer section which showed
the page of pages and set it to zero height.  Then in the subreports I
placed controls which referenced the main report control and read the value
of it.

Main report control: ="page " & [page] & " of " & [pages]
Sub report control: = reports!MainReport!PageControl

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman via AccessD
Sent: Wednesday, 15 May 2019 7:58 a.m.
To: 'Access Developers discussion and problem solving'
Cc: Jim Dettman
Subject: Re: [AccessD] Page numbers in Subreport

David,

  As is, the short answer is no.

  Page Header/Footers are not processed in a sub report.  That's why you're
getting the 0/0.  You'll have to take care of the page numbering yourself.

  A trick with subreports is to add a group with the expression =1 to add a
group header/footer.  Then set the group header's repeat section property to
true and place you headings in there.  Now you've got a spot where you can
increment the correct page count.  Store the page count in a text control on
the main report.  You can fetch it from there when you want to print the
page in the subreports.

  To get the number of pages, on the main report place a hidden text control
in the page footer with the controlsource of  =[Page] & " of " & [Pages].
This activates two pass mode.   On the first pass, the report engine will
run through all the pages to get the total.   You can tell your on the first
pass when .Pages = 0.   Note that on the first pass, OnPrint does not fire.

  On the second pass, .Pages will have the total page count, which you can
use in the subreport.

Jim.
----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Tuesday, May 14, 2019 2:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Page numbers in Subreport

Hi Listers,

 

I have a report that has three subreports (and nothing else).

 

The subreports take up whole pages and near the bottom of each report is a
field with "=[Page] & " of " & [Pages]" as the control source.  If I run the
subreports on their own they show the correct page numbers for their report.
Depending on one of the fields in the subreport data, each record may fill 1
or 2 pages (always whole pages)

 

When I run the combined report the page numbering shows "0 of 0" (which I
have found is a "feature" of subreports).  I am wanting them to show the
numbers as if the page number fields were on the combined report (eg page x
of {total number of pages from the combined report}.

 

Because the position of the page numbering is not at the very bottom of the
sub reports it cannot go in a page footer of the combined report.

 

Does anyone know how I can get the page numbering of the subreports to
appear correctly?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com