August 7, 2013 at 2:15 am
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
August 12, 2013 at 7:07 am
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
August 12, 2013 at 7:32 am
We are currently in SQL Server 2008 R2.
August 12, 2013 at 7:39 am
SceloM,
Many thanks for your reply. Much appreciated.
Regards
August 12, 2013 at 7:43 am
You welcome, I hope it worked for you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply