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!
I wrote a kind of package for handling this which is published on our Bitbucket site at https://bitbucket.org/TN_WebShare/report-server-tools/.
(If you don't have access to the TN_WebShare team, you can request access at https://tessituranetwork.com/devs).
There are two main components to the report-server-tools package. The first is a toolkit for manipulating the report server in a variety of ways, and the second (built on top of the first) is a Conditional Report Scheduler feature. We use this to do what you're talking about "at scale", where conditions (for example, "Report Not Empty") can be set up for any report, and then a user who has created a standard schedule can "conditionalize" it using a utility that takes it out of the standard report rotation and allows it to be managed by a daily agent job.
This was built on v12.5, but I am underway on a v14 update now, so if there are any changes needed, they will be published to the Bitbucket repo.
I am aware that there are some changes in v15 that will require some components of this project to be modified, which I am looking forward to doing once V15 is released (the Tessitura Processing Service runs reports much faster, which I'm very happy about). This feature is not going to be included out of the box in v15.
Thank you, Nick. I'll definitely take a look at what you've put together. Appreciate your insight on this!