Eliminating empty output files in SSRS subscription

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply