Is there a way to set up a Schedule for a Report so that the Report is triggered/sent ONLY if the Report is populated with information? Therefore, if I schedule it to run once every day but the majority of days it's blank, I don't want it to actually send on the majority of those days, I want it to send ONLY on the days that it actually populates with information.
Is this possible?
I built a small suite of tools to help me do exactly this, which are shared on Bitbucket: https://bitbucket.org/TN_WebShare/report-server-tools (This is a "community resource", request access here: https://www.tessituranetwork.com/Support/Resources/Developer)
It's designed so that any end user can convert an existing schedule to a conditional one just by running a quick utility from the client. This requires that the admin configures a condition in System Tables (like "Report Not Empty") for each report type you wish to use, and you also have the option of creating more advanced conditions by writing stored procedures that resolve based on the request's parameters. (For example, I have a condition called "Yes Cash Income" that only resolves if the Income By Payment Method report has cash on it.)