[AccessD] Report breaks in subreports

Thanks Kath,

I don't see the Visible property in the property box for the page 
break - is it a "hidden" property?

David

At 15/05/2008, you wrote:
>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
> >
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com