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
Hi Scott,
Adding to what Ryan mentioned , If you have it as a scheduled job executing a procedure you could have the stored procedure itself send/schedule the email with sql mail if the stored procedure returned data.
Jon
Hi both,
I havent tried doing that, if I can get the formatting right then this would be more than an acceptable solution so I will give it a try!
Thanks for the help!