Report flowing on two pages....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have set up a report which I have taken the time to format so it is
visually pleasing and all on one page for each vendor we need the reports
for. However, there is a subform on the report and for one of our vendors
that data spills on to two pages. Because the data continues from the first
page, it looks ugly. Anyone have any ideas on what would be a good way to
handle this? I don't mind the information spilling on to two pages, but I
would like to be able to program a way to format this properly.
 
What looks ugly?
I assume there is something missing that you want to appear on this other
page?

You know that the Page Header/Footer sections print on each page?

You can also do this with Group Header/Footer sections - check the Repeat
Section property.

Steve
 
Let me try to explain this. I have all kinds of information on a 1 page
report. The lower right corner of this report is actually a subreport which
grows depending on how much data is on the subreport. One of the reports has
so much data on the subreport that it is flowing on to a 2nd page which by
design, isn't formatted. I'll try the header/footer setting for the subreport
and see if it makes it look bettter, but I was curious had any other ideas of
handling this.
 
The Header/Footer I was referring to are in the main report.
Only the Report Header will show in a sub-report as far as I rememeber...

Steve
 
To answer your question on what specifically looks ugly, the information from
the subreport in the bottom right corner of the main report continues on to
the next page where everything else is empty except the upper right corner
where the subreport is continuing.
 
Ok, let me explain how each section works...

Report Header - prints on first page of report
Page Header - prints at top of each page
Group Header - prints at top of each group but can be displayed on every
page (where relevant) by setting the Repeat Section property.
Detail section - prints detail and will print multiple times for each Group
Header (if any).
Group Footer - prints at the end of each group
Page Footer - prints at bottom of each page
Report Footer - prints on last page of report.

There are additional properties for Headers/Footers where you can specify
that they start on a new page or a new page is started after that section.
You can also use the properties in the Sorting & Grouping dialog to keep
groups of records together etc.

It's difficult to advise what to do because I cannot see your report but I
hope that helps a little...

Steve
 
Thanks Steve, appreciate all your help. I think I found a work around with
the info you sent.
 
Back
Top