[AccessD] Report breaks in subreports

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
>