Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Eliminating empty output files in SSRS subscription Expand / Collapse
Posted Tuesday, November 27, 2012 2:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 27, 2015 2:53 AM
Points: 1, Visits: 2
I have a report with a subscription in SSRS. This subscription post by mail a pdf file.
When i have an empty recordset, the pdf file is still post with only the page header.
I would like than the pdf file is not created and the mail not posted ...
Thank in advance.
Post #1389039
Posted Wednesday, November 28, 2012 12:08 PM


Group: General Forum Members
Last Login: Friday, December 4, 2015 8:40 AM
Points: 132, Visits: 621
Similar topic was discussed in the following.
SSRS report delivery issue

The solution I use is by running a query to check for data, if there is data, run dbo.AddEvent on the report server to trigger a subscription event. There is a process for SSRS that monitors an event table for detecting when to run a subscription. AddEvent sp inserts a record into the event table which causes SSRS to run the subscription event.

Paul's solution is similar except his is to trigger to the the subscription job itself.
Post #1390043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse