[AccessD] Need to Suppress Main Report Line if the related Sub-Report has no Data

Charlotte,

The related data is just one field in a row of data that is shown on the Main report's detail lines.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Charlotte Foust
Sent: Thu 12/5/2013 8:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Need to Suppress Main Report Line if the related Sub-Report has no Data
 
Is the related data the only thing that prints on that line?  Or is it
merely a field/column in a row of other values?

Charlotte


On Thu, Dec 5, 2013 at 5:17 PM, Brad Marks <BradM at blackforestltd.com> wrote:

> 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
>
>
-- 
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=F3F9E28AEB.60BFC