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.
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
Nick Reilinghbuilt and shared a utility to do this, which I keep meaning to download and try out.