[AccessD] How to Suppress Main Report Line if the Related Sub-Report has no Data

Paul Hartland paul.hartland at googlemail.com
Mon Dec 16 22:18:04 CST 2013


Brad,

Am I clear on this that you don't want to show the main detail/report if
there is no sub detail/report data ?

Paul


On 17 December 2013 01:37, Brad Marks <BradM at blackforestltd.com> wrote:

> Rocky,
>
> Thanks for the help.
>
> Unfortunately, I seem to be having "senior moments" and I cannot even get
> a small test example to work.
>
> Perhaps you could post more details.
>
> For example, I am not sure how to obtain the record count of the
> sub-report.
>
> Thanks,
> Brad
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com on behalf of Rocky Smolin
> Sent: Thu 12/5/2013 10:26 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Need to Suppress Main Report Line if
> therelatedSub-Report has no Data
>
> I would use the format event of the detail section to get the record count
> of the sub report and, if it's zero then
>
> Me.MoveLayout = False
> Me.NextRecord = True
> Me.PrintSection = False
>
> HTH
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Thursday, December 05, 2013 5:17 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Need to Suppress Main Report Line if the
> relatedSub-Report has no Data
>
> All,
>
> I have a report that has one sub-report.  This sub-report is tied to a
> field
> in the detail lines of the main report.
>
> Recently, our users requested that if there is no data in the sub-report
> they would like to see the related line on the main report suppressed.
>
> I have never tried to do this before.  I have set up a little test Access
> application and tried a few ideas, but have not found a good solution.
>
> Is there a way to accomplish this with Access 2007?
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> This message was scanned by ESVA and is believed to be clean.
> Click here to report this message as spam.
> http://h0stname/cgi-bin/learn-msg.cgi?id=6A8F528AEB.B87B1
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the AccessD mailing list