Print report sections on different pages

  • Thread starter Thread starter H J
  • Start date Start date
H

H J

I have am building a report that is pulled from a query with 3 tables of
information. The first table is mostly address information, the second is
equipment located at the address, and the 3rd is images associates with the
address. Tables are linked using a one to many relationship.

Currently I click a button and am prompted to enter a month (1-12) in order
for the system to print service sheets for each address that is due a
service in that month. However, at the moment only the address information
prints. I want to update this so that when I select a month, the address
information prints on one page, then any equipment at that address prints on
the second page, and if there are any images, that this prints on a 3rd
page. Is this possible by building a main report, then entering a page break
and a subreport of the equipment, and then another page break and a
subreport with any images printing?

Thanks.
 
H said:
I have am building a report that is pulled from a query with 3 tables of
information. The first table is mostly address information, the second is
equipment located at the address, and the 3rd is images associates with the
address. Tables are linked using a one to many relationship.

Currently I click a button and am prompted to enter a month (1-12) in order
for the system to print service sheets for each address that is due a
service in that month. However, at the moment only the address information
prints. I want to update this so that when I select a month, the address
information prints on one page, then any equipment at that address prints on
the second page, and if there are any images, that this prints on a 3rd
page. Is this possible by building a main report, then entering a page break
and a subreport of the equipment, and then another page break and a
subreport with any images printing?
Click to expand...


Yes, it is possible. Did you try using th Page Break
control and have a problem?

If the page breaks are supposed to be at the beginning or
end of a report section, then it would be simpler to use the
section's ForceNewPage property instead of a Page Break
control.
 
Marshall Barton said:
Yes, it is possible. Did you try using th Page Break
control and have a problem?

If the page breaks are supposed to be at the beginning or
end of a report section, then it would be simpler to use the
section's ForceNewPage property instead of a Page Break
control.
Click to expand...

I have not yet tried the Page Breaks control, so no problems with the
control, I was not sure if there was a better way of achieving the result.
The ForceNewPage property sounds like it would work better though, thanks.
 
Back
Top