• Replies 10 replies
  • Subscribers 960 subscribers
  • Views 239 views
  • Users 0 members are here
Related

Report Scheduling for Days Where No Data Is Displayed

Rachel Stone
$organization

Hi, all- 

We have some reports that are being distributed daily, even on days where there is no information on the report.  We would like to adjust the schedule so that the report is only emailed when data is actually populated. 

Has anyone figured out a way to set this up?

Hoping someone has an answer or clever method... 

Thank you!

Parents
  • $organization
    Rachel Stone said:
    We would like to adjust the schedule so that the report is only emailed when data is actually populated. 

    A popular request, and though the current Report Server can't do this out of the box, I'd be surprised if the looming v15 Report Server re-write didn't include this feature.

    Meanwhile, we've gotten around this by writing SQL to either

    1. Look for the data we seek and queue a one-time Report Server request if that data is found, or
    2. Same as the above, but send the data via an HTML e-mail "report" if there is data, skipping the Report Server entirely.

    1 is fiddlier, but 2 only works well with small data sets, i.e. short, alert-style reports.

Reply
  • $organization
    Rachel Stone said:
    We would like to adjust the schedule so that the report is only emailed when data is actually populated. 

    A popular request, and though the current Report Server can't do this out of the box, I'd be surprised if the looming v15 Report Server re-write didn't include this feature.

    Meanwhile, we've gotten around this by writing SQL to either

    1. Look for the data we seek and queue a one-time Report Server request if that data is found, or
    2. Same as the above, but send the data via an HTML e-mail "report" if there is data, skipping the Report Server entirely.

    1 is fiddlier, but 2 only works well with small data sets, i.e. short, alert-style reports.

Children
No Data