Asger Blond
ab-mi at post3.tele.dk
Wed Sep 26 17:24:04 CDT 2012
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