Hello all,
Is there a way to set a report schedule so that:
1. You get the reports e-mailed on Mon-Fri, but not Saturday and Sunday? I realize this idea is not compatible with the range of RunDate and DayRunDate -1 parameters on a daily report, but if someone knows a magical way to make this work I would be grateful to hear about it!
and 2. Only receive an email with reports where there is actual data present? I'm guessing for this particular report, we will get one or two responses per week, but our manager wants to know daily, and I think an inbox cluttered with blank reports will get old pretty quickly.
Please and thank you!
Hi Katie - Unfortunately I think the answer to both is no. In order for reports to run only on weekdays, I've had to create 5 different schedules, one for each day of fhe week. Also, our users would be over the moon if it would only send when there is data present, especially for house reports that are scheduled to run daily but there are days where we don't have shows and the house managers end up getting their entire group of emailed reports - all blank.
I would also love to to be able to pick the days of the week they send and not have blank reports send. The one thing about them not sending if blank is that it wouldn't be as obvious when something errors out. We occasionally have reports not pull or send for no real reason.
Michele Keutsch said:our users would be over the moon if it would only send when there is data present
Years ago, I wrote custom code that tried to insert a request into the standard report stream only when data was present. It was flaky, and we abandoned it in favor of things like a SQL Agent job that looks for data a sends an HTML e-mail via SQL mail, but this has never been suitable for very complex data, or attachments, etc..
Looks like there is already an IDEA that we can support:
(7) schedule reports to be sent out on certain days of the week without setting up multiple schedules - Ideas - Ideas - Tessitura Network
Yeah, given the way Tessitura is extremely flexible in many ways it seems odd to me that the scheduler cannot do things a little more flexibly. I also tried a more custom/flexible structure of sending out reports myself that ended up going nowhere.
In the end, it is a lot less of an issue since we moved to SharePoint for our document storage. I used Power Automate to set up a folder in SharePoint which is basically the "Current Days' Reports" that takes any report that is sent to a "scheduled reports" distribution list (that goes only to me) and automatically deletes the previous version of that report and replaces it with the newest version. (And my e-mail inbox has a rule that automatically files those away). So in the end I have an online folder that does not change to which I can send anyone who wants the daily reports that does not clog their inboxes and no one has to worry about maintaining.
Not a solution as you asked for above, but it ended up solving the same situation you are having for me.
Nick Reilinghbuilt and shared a utility to do this, which I keep meaning to download and try out.
Hi John, thanks for the idea. In the end I will probably do something like this for now.
That's not a bad idea - I may try something like this, thanks!