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.
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.
Hi John, thanks for the idea. In the end I will probably do something like this for now.