Eliminating empty output files in SSRS subscription

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Eliminating empty output files in SSRS...

Eliminating empty output files in SSRS subscription

Rate Topic

Display Mode

Topic Options

Author

Message

dccorp

Posted Tuesday, November 27, 2012 2:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 2:39 AM
Points: 1, Visits: 0

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

richykong

Posted Wednesday, November 28, 2012 12:08 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:55 PM
Points: 127, Visits: 442

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 »

Permissions