Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Eliminating empty output files in SSRS subscription Expand / Collapse
Author
Message
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: Wednesday, March 5, 2014 12:06 PM
Points: 1, Visits: 1
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:37 PM
Points: 132, Visits: 582
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