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.