[AccessD] Report breaks in subreports

David - what about doing some 'on format' code of your detail section in the 
main report to:

- Do a dcount of the expected no. of records for each sub-report
- If the result is zero, set the pagebreak to visible = false, otherwise 
leave the page break in place.

hth
Kath
----- Original Message ----- 
From: "David Emerson" <newsgrps at dalyn.co.nz>
To: <accessd at databaseadvisors.com>
Sent: Thursday, May 15, 2008 1:47 PM
Subject: [AccessD] Report breaks in subreports


>I have a master report that is a container for a whole lot of
> subreports (they are continuous subreports with a report header and
> footer - this means that they are not a consistant height).  Each
> subreport needs to start on a new page.  At the moment I have each
> subreport in the main report followed by a page break.  This works
> fine except when the subreport has no data in it.  In this case there
> is a blank page.  There doesn't seem to be any properties to prevent
> the page break from happening in this case.
>
> I tried putting the page break at the end of each subreport (report
> footer section).  The idea was for the page break to only occur if
> the report had data.  However no page break occurs.
>
> Any ideas how to get around this?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>