Blank Page at end of Report

rbuser

I am using RB 9.03 and Delphi 6 Pro. I have a report with a Section
SubReport in the summary band. This SubReport itself has a section SubReport
in it's summary band. Each SubReport only has a ppMemo in the detail band
which I populate when the main report starts, so neither has a pipeline
assigned.

My problem is that I continue to get a blank page at the end of the report,
so if my report has 14 pages, the last blank page will have a footer saying
"Page 14 of 14". When I disable the 2nd SubReport (visible=false) I still
get the blank page, which leads me to believe the 1st SubReport is causing
the problem. If I disable both SubReports, the main report prints fine w/ no
blank page.

Any ideas on how to fix this?

Thanks,
Eric Buescher

nicocizik

Hi Eric,

Section subreport are meant to be placed inside an empty detail band in
order to combine multiple reports together as one. When they are placed
outside the detail band (or if there are other objects inside the detail
band), you will most likely get an empty page at the beginning or end of
your report because by definition section subreports start a new page.

My suggestion would be to place all of your main report information in a
section subreport followed by the existing section subreport inside an empty
detail band of your main report.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I'm confused here, so if you could clarify I would appreciate it. I tried
what I thought you were suggesting and it didn't work.

I moved all my main report stuff into it's own Section SubReport and then
put this SubReport in the Detail band of the now empty Main Report Form. I
also moved the other two SubReports into this same Detail Band so that the
Main Form detail band has 3 Section SubReports in it. The rest of the Main
Report form is empty (no title, header, footer, etc.). If I try instead to
"chain" these reports together then I run into the problem you were stating
earlier, where I would have a Section SubReport in a detail band which is
not empty, or I could put the SubReport #2 into the Summary band of
SubReport #1, but then I'm back to the problem of blank pages.

Thanks for any help,
Eric

nicocizik

Hi Eric,

It all depends on what you would like your report to look like. The basic
idea is that you need to remove all section subreports from the summary
bands of other reports. I would recommend going back to having an empty
main report with only three section subreports in the detail band. All
report objects that were previously in the main report need to go into the
first section subreport. If there are any other components in the detail
band other than subreports, they also need to go into the first subreport.

Main Report
DetailBand
Section Subreport1 - contains previous main report
Section Subreport2 - subreport previously in the main report's summary
band.
Section Subreport3 - subreport previously in Subreport2's summay band.


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

That is actually what I did, but I wasn't sure from your 1st post if that is
what you were recommending. When I print this report I still get blank pages
after both the 2nd and 3rd section subreports. Here is what I've found as
I've tried to debug this. The 2nd subreport uses the same printer settings
as the 1st, but is in 2 columns portrait mode. The 3rd subreport uses
different printer settings as it is in landscape mode and has 2 columns as
well. NewPrintJob=false for all subreports. If I set the subreports (2&3) to
only 1 column, then there are no blank pages. When I set them back to using
columns, then the blank pages reappear. If I print subreports 2&3 by
themselves by making the others invisible, then I still get the blank pages.
Subreport #1 always prints fine and is only 1 column wide. Subreports 2&3
each have a title and footer band, and the detail band only contains a
ppMemo set to Stretch. I'm wondering if the RBuilder code to stretch the
memo is intially bumping up the page count for the subreport, not counting
the fact that the memo will be "wrapped" into the next column. I have tried
all combinations of OnePass and TwoPass on all the subreports. I have
checked that the ppMemo boxes do not have a bunch of blank lines overflowing
onto another column/page. I just did a test so that the memo boxes in
subreports 2&3 would only have about 1/2 of a column of data and would not
need to "wrap" onto the next column, and no blank pages printed. This would
lend evidence to the possible RBuilder problem of stretching memo boxes over
multiple columns.

Note: I initially chained the subreports together in the summary bands as
per the RBuilder Help File which states "... (Note: In order to link several
reports together, place each subsequent SubReport in the SummaryBand of the
preceding report.)." This was in the pbSection subreport help notes.

Sorry for the long-winded post. Thanks again for any help,
Eric Buescher

nicocizik

Hi Eric,

If possible, please send a small example demonstrating the problem that I
can run on my machine in .zip format to support@digital-metaphors.com and
I'll take a look at it for you.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com