Has anyone had experience with scheduling a daily report that generates Box Office reports at the Production level, but only if there are Performances in that Production for the day?
The scenario is that we have various coordinators that require Box Office reports for their Productions at the end of any day that has their Performances.
I know of Shared reports that can present sales information at the Production level, but not reports that are smart enough to only run if there have been performances inside that Production.
As these reports will likely be emailed, I am trying to avoid having empty reports emailed on days when there were no Performances for the relevant Production.
Hi Nicholas
You can't do that using the report scheduler as is, but it would probably be possible (albeit slightly Brave) to write a proc that would remove the report from the queue if it was going to be blank (the report queue is just another table, [gooesoft_schedule_queue]). You'd have to run that as a scheduled job each day before the report was scheduled to be run, of course, because only the next run is in the queue, and you'd need to keep a close watch on the scheduling, to ensure that you changed the proc when people put new schedules in. You might be able to automate that by looking at the report schedule and its parameters, so that it would remove any queued report of that type, if its production parameter didn't have any perfs for the relevant day... or something like that..
There was a discussion about something like this a while ago in the forum - with a different solution, if I remember correctly... oh yes, here it is....
Ken