Hello,
Here at Arizona Science Center we have IMAX perfomances that have 3 or more shows daily. At the end of the month we have to settle with IMAX and one of the current needs is # of performances. I was asked if there was a report that would tell him how many shows we had that month instead of him counting them line by line. My work around is to import it to excel and count the rows, but if there is a report I missed I'd love to report it back to the IMAX settlement people here.
Hi Sandra,
I asked a similar question on the forum a couple of weeks ago and was given a great solution by the University of Washington. It's a SQL script that you can use to build a report, that shows the number of performances in any season or date range.
You should be able to find it on the forum under the post titled "Report showing every performance within a date range?" Happy to email it to you if you can't find it though.
Alison