View Single Post
  #2  
Old May 11th, 2010, 01:39 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Do reports suck? How to set conditional page breaks between subrep

Ralf wrote:
I have a report with 9 subreports. Each of those subreports should be on a
new page.
If I place a page break control between those than I have empty pages, since
some subreports may be empty (depending on existing recordsets).
Ok, what I could do now is to set 'Keep Together' to yes, but that requires
that I set the size of each of those 9 supreports to their original/actual
size. But the report size is limited and I approach this limit after resizing
the first 4 subreports already.

I really don't know what to do. Reporting tutorials in books and Internet
are very shallow and the MS help is far from being helpful. It would be great
if someone is experienced enough to give me some hope or at least to confirm
that there is no way to solve this issue. Perhaps there is a complete
different approach to follow?



The subreport controls need to have their CanShrink property
to Yes so they won't take up any space when they have no
date to report.

To deal with the blank page caused by a corresponding empty
subreport, for each subreport, add a line of code to the
section's Format event procedure similar to:
Me.pgBreak1.Visible = Me.subreportcontrol.Report.HasData

--
Marsh
MVP [MS Access]