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?
> Is this possible?
Not via the current Report Server service without customization, no.
Some orgs have created workarounds, e.g. customizations to query the data and insert a standard request if any is found. In some cases I've found it simpler to query and, if data is found, send the desired data in a formatted HTML e-mail created and sent via a SQL Agent Job rather than going through the gyrations required by the Report Server.
With an Exchange server groaning under the weight of innumerable saved PDF attachments we are slowly moving away from e-mailed reports these days, and toward more auto-refreshing SSRS report "dashboards".