I am using the data-driven subscription feature of SQL Server Enterprise. My subscription is setup and working nicely; however, I'd like to suppress reports that have no data in the primary data table in the report.
When setting up the subscribers in the subscription, I pull the data from Data Set 1. The report data actually pulls from Data Set 2 (located on a different server). Is there a way to cross reference the number of results returned from the primary report data set (Data Set 2) when setting up the subscriber list? The Subscriber list is also located in the SSRS report server database...I tried using the Execution Log to view the RowCount, but this doesn't work when the subscription is sent out as an Excel attachment.
Any thoughts out there? Thank you in advance.