Hello - we are trying to find the best way to email a daily sales report that shows cumulative sales to date, and the last 24 hours of sales by production and have multiple productions (ie our season). The ticket sales by period report doesn't work since there are so many individual performances.
Any ideas? Thank you!!
Unknown said: Hello - we are trying to find the best way to email a daily sales report that shows cumulative sales to date, and the last 24 hours of sales by production and have multiple productions (ie our season). The ticket sales by period report doesn't work since there are so many individual performances.
We have a custom report (created by none other than Ron Wilson, back in 2008 during our migration/conversion) that reports exactly as you describe, with one page per production as the output. As it is, it requires two custom system tables which you don't have, but shouldn't be too painful to add. Please get in touch offline if it sounds interesting to you.
Hi Chris,
I know this thread is a few years old but I was wondering if this is still something you are able to share or if it has been uploaded to the Shared Reports?
I would love to take a look at it if possible!
Thanks
Sure; I'll reach out offline.