Conditional Subscription / Conditional Execution of Report
Hello everyone, Is there a way in order to execute asubscribed reportbased on a certain criteria? For example, let's say send a report to users when data exist on the report else if no data is returnedby the query executed by the report then it will not send the report to users. My current situation here is that users tend to say that this should not happen, since no pertinent information is contained in the report, why would they receive email with blank data in it. Any help or suggestions will be much appreciated. Thanks, Larry
March 7th, 2008 9:30am

If I were a user, I would want to know that there had not been any problems.What if there is a lot of data to report, but something else in the delivery chain fails?The users will believe there is no data, which is obviously not the case.Maybe you could use SSIS?
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2008 10:44am

If you have found a way to do this in Reporting Services, could you please post the method used? I have a similar need, used specifically for maintenance and error identification reports that I run in Reporting Services. I'd rather not have to run the reports manually or open blank spreadsheets when there isn't a problem.Thanks
June 12th, 2008 4:20pm

There is a 'norows' property on a table in RS. When the table is empty, it gets displayed.I wonder if it is possible to populate this with a message which can be detected by your email software to delete it...?You'll still get an email every day, but you'll never be bothered with empty ones
Free Windows Admin Tool Kit Click here and download it now
June 12th, 2008 5:29pm

Use the data driven subscription instead of time driven subscription. In the query returning your list of recipients, set a condition based on your report. Depending on whether your condition return recipients or not, the report will or will not be sent. You can still schedule your data driven subscription. Take a look at this blog: http://blogs.msdn.com/b/bimusings/archive/2005/07/29/445080.aspx
December 23rd, 2010 12:53pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics