Post reply

Suppress reports that return no data

  • July 8, 2011 at 1:31 pm

    #253422

    Hello All,

    I'd like to create an email report that would run daily and report any activity in the last 24 hours. I don't want to send out the email if there is no data to report. Is this possible in standard edition? Does enterprise edition give me this ability?

  • July 11, 2011 at 3:46 am

    #1350972

    Chrissy,

    there are a couple of ways how you can do this. If you have Enterprise Edition you can use the data-driven subscription using a parameter based on the rowcount.

    With standard edition it's a bit more complex. This link discusses a couple of different approaches

    http://blogs.msdn.com/b/bimusings/archive/2005/07/29/445080.aspx

    [font="Verdana"]Markus Bohse[/font]

  • July 11, 2011 at 7:18 am

    #1351061

    I would suggest that you run the report anyway and use the NoRowsMessage property to let everyone know there was nothing to report. There is always the question when people don't get a report, is the report broken, or is there simply no data. If the report is empty for a long time and the report is not sent, people won't miss it when it fails and needed data will be missed.

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

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