[AccessD] Report breaks in subreports

Thanks Kath.

David

At 15/05/2008, you wrote:
>David - it doesn't appear in the properties box, but you can set it in code.
>
>eg.
>me.ctlbreak.visible = false
>
>(just checked it - it worked).
>
>Kath
>
>
>----- Original Message -----
>From: "David Emerson" <newsgrps at dalyn.co.nz>
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>Sent: Thursday, May 15, 2008 2:24 PM
>Subject: Re: [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
> >
> > --
> > 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