Subreports screw up main report when no data

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi all,

Using Access 2002 SP-1 here.
I've a report with 6 subreports.
If all subreports have data, everything prints smooth.
If some subreports don't have any data, strange things happens:

1) some subreports won't print at all (I don't have any problem in this
case), OR
2) they print only their headers with no data (I don't like it, but I can
survive), OR
3) both of the above, and at the same time the page count of the main
report increases (double or a bit more), with some pages appearing
completely blank, and some pages repeated a second time (like printing
the main report twice).

=================================
Example of point 3 above:

I tried to produce a report that should have 4 pages:
1st page: some text and tables to be completed by hand
2nd page: SR1 (has data) + SR2 (no data, it's not printed) + SR3 (no
data, it's not printed)
3rd/4th pages: SR4 (no data but prints some headers, I can survive)
SR5 and SR6 have no data and are not printed, that's OK.

The above is what I EXPECT. But I get this:

1st page: idem as above
2nd page idem as above
3rd/4th pages: idem as above
5th page: EMPTY
6th page: repetition of 1st page
7th page: repetition of 2nd page
8th/9th pages: repetition of 3rd/4th pages
10th/11th pages: EMPTY

This affects the total page count, so I can't use "page x of y" in the
footer, but I NEED that, otherwise I would have been able to print the
report and discard the extra pages...
==================================

The only "strange" bit in my main report are some page breaks:

PAGE1
PB
SR1
SR2
SR3
PB
SR4
PB
SR5
PB
SR6

This was done this way because SR1-3 are small, and always fit in 1 page,
while SR4-6 are long ones, spanning more than 1 page, so it's better to
start them always in a new page.

I'm using no code, no modules, not anything fancy.

THANK YOU IN ADVANCE!
Cheers,
 
I suspect that you need to review the grow and shrink
setting on each of your reports and the bands of the
reports.
I think this will reduce, if not eliminate, the blank
pages.
Hope this helps.
Fons
 
I suspect that you need to review the grow and shrink
setting on each of your reports and the bands of the
reports.
I think this will reduce, if not eliminate, the blank
pages.
Hope this helps.
Fons
Click to expand...

Thanks a lot Fons.
This surely helped, now I've to sort out the use of conditional page
breaks, I posted that sepparate.
Cheers,
 
Back
Top