[AccessD] Access 2007 Sub-Report With No Data - Not Visible in Print Preview or in Exported PDF file

Brad Marks BradM at blackforestltd.com
Wed Sep 26 21:18:06 CDT 2012


Asger,

Thanks for the help.

I forgot to mention something important...sorry.

The Sub-Report is pulling data from a different query than the Parent Report. (Completely different data)

Therefore, there is no Link Field.

I have experimented with a Union Query that pulls a single record from a Dummy Table.  This seems to work, but I thought that there might be a better solution.

Thanks again,
Brad
   
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Asger Blond
Sent: Wed 9/26/2012 5:24 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 Sub-Report With No Data - Not VisibleinPrint Preview or in Exported PDF file
 
Hi Brad,

It's possible if the record source for your sub-report includes the table and the link field you use for the main-report in an outer join (showing all records for the main-report's table).
To suppress the value in the control for the link field on the sub-report when there is no data, you can then set the control source to =IIF(<some other control on the sub-report> IS NULL,"",<link field>).

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Brad Marks
Sendt: 26. september 2012 20:34
Til: Access Developers discussion and problem solving
Emne: [AccessD] Access 2007 Sub-Report With No Data - Not Visible inPrint Preview or in Exported PDF file

All,

I have an Access 2007 report that has a single Sub-Report.

In some cases, there is no data for the Sub-Report.

When this happens, I can see the Sub-Report header in "Report View" when
I view the parent report.

However, when I view the parent report via "Print Preview" or via an
exported PDF file, there is no trace of the sub-report.

I would like to see the "shell" of the sub-report even if there is no
data in the detail section.

Is this possible?

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 has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list