Post reply

Suppress Report Generation to Subscribers if no data

  • October 29, 2007 at 8:27 am

    #183294

    Is there a way to suppress a Report generation and transmission to the subscribers "IF" there is no data on the report?

    (I have a user base of subscribers that would prefer to NOT RECEIVE the report if the contents are empty)

    BT

  • October 30, 2007 at 2:44 am

    #746512

    I've done this with a data-driven subscription in SSRS Enterprise editions. If the data-driven query returns zero rows, no emails / file drops will go out.

    Are you using SSRS Enterprise edition?

  • October 30, 2007 at 2:51 am

    #746514

    the trick is to get the data-driven query, i.e. the one that supplies the email addresses for the subcription, NOT to return a row where there is no data. I do this by basing the report on a stored procedure which, before returning the report's result set, builds (or updates) a table of the email addresses where there is data to send them. This table is then the basis for the subscription's data-driven query.

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

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