I don’t think this is possible using a report scheduled on the report server, as the mere act of running the report forces it to render (unless an error was raised, but you don’t want to force this unnecessarily).
Have you thought about making this a scheduled job in SQL Server? It gives you notification options on success/fail (SMS, email, etc).
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Scott WhitehouseSent: Thursday, May 12, 2011 5:02 AMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Supressing a report if it contains no data
Hello everyone,
I am running out of ideas with this one so was wondering if anyone could help me. I have a stored procedure that I need to run several times to pull off various details for several performances. However, there will not always be data or shows to display anything on a report and I dont really want to send blank emails out to staff.
Is there anyway that I can suppress a report from running if there is no data to return or make it so that it is conditional based on a parameter?
Any help on this would be much appreciated!
Many Thanks,
Scott
--View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/4534/14929.aspx#14929 or reply to this message--This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!