[AccessD] Access 2007 Sub-Report With No Data - Not Visible inPrint 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