Post reply

Eliminating empty output files in SSRS subscription

  • November 27, 2012 at 2:57 am

    #271161

    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.

  • November 28, 2012 at 12:08 pm

    #1563378

    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