Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 R2 - Don't send blank report subscriptions Expand / Collapse
Author
Message
Posted Wednesday, August 7, 2013 2:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 7:07 AM
Points: 7, Visits: 20
We have SSRS 2008 R2 Standard Edition, so unfortunately no data driven subscriptions are available. We have some reports that are sent out on a daily basis - used for exception management only. Although I have seen posts regarding "workarounds", I was wondering whether a cleaner solution is available to not have blank reports or reports with no data sent to members within the distribution list?

Regards
Post #1481708
Posted Monday, August 12, 2013 7:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, July 27, 2014 11:53 PM
Points: 39, Visits: 181
Which version of SQL are you using?
Maybe you can consider the NoRowsMessage property; report will still be mailed out but instead of it being blank a message will be shown. only from SQL 2008 R2
Post #1483283
Posted Monday, August 12, 2013 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 7:07 AM
Points: 7, Visits: 20
We are currently in SQL Server 2008 R2.
Post #1483307
Posted Monday, August 12, 2013 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 7:07 AM
Points: 7, Visits: 20
SceloM,

Many thanks for your reply. Much appreciated.

Regards
Post #1483310
Posted Monday, August 12, 2013 7:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, July 27, 2014 11:53 PM
Points: 39, Visits: 181
You welcome, I hope it worked for you.
Post #1483316
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse