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
From: Sandra Berschauer <bounce-sandraberschauer2435@tessituranetwork.com>To: rbernard@smm.orgSent: Wed, Sep 12, 2012 21:08:27 GMT+00:00Subject: [Tessitura Ticketing Forum] # of Performances in a reportHello, 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. This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums.In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
This might be overly simplifying what you actually need, but if each of these are set up as separate performances in a particular season (and there aren't other shows in the season, which might be the sticking point) you could run the Performance Listing report under Ticketing Box Office for a season and date range and then just look at the total performances on the last page.
I imagine what you need is more complex than that, but just in case it isn't!
- HeatherSeattle Rep
Heather,
Oversimplification, pour moi? That’s a great idea: I don’t use the Performance Listing much and it definitely answers the issue, as that’s how we set up our performances. I will still need reliable, old T-Stats because I need a monthly report broken down by the Production, usually we only have one film on screen, but a few times a year we have multiple films. We also built a custom cube so that we could get analysis by time: e.g attendance at the 8pm shows for the month vs. LY. Thanks for the tip; it’s why you’re one of my Tessitura heroes!
Ray
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Heather KraftSent: Friday, September 14, 2012 5:02 PMTo: rbernard@smm.orgSubject: Re: [Tessitura Ticketing Forum] # of Performances in a report
From: Ray Bernard <bounce-raymondbernard7790@tessituranetwork.com>Sent: 9/12/2012 10:00:48 PM
We do as you do: export a TStats report to Excel and count rows. We'd be interested to hear about any non-custom alternatives.Connected by DROID on Verizon Wireless
-----Original message-----
From: Sandra Berschauer <bounce-sandraberschauer2435@tessituranetwork.com>To: rbernard@smm.orgSent: Wed, Sep 12, 2012 21:08:27 GMT+00:00Subject: [Tessitura Ticketing Forum] # of Performances in a report
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. This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums.In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Thanks to everyone for the input. I will have to rethink how I create the IMAX shows if I want to report with the performance listing, but since we have another show starting soon I might have my chance to rebuild the shows the way we need.
Sandra, e-mail me directly if you want to set up a time to look at how we set up our Omnitheater performances here at the Science Museum: rbernard@smm.org. We have had no problems with scheduling regular Tessitura reports to fulfill daily film distributor reporting requirements. I’m on PTO this week, but will make myself available if time is an issue.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sandra BerschauerSent: Monday, September 17, 2012 10:10 AMTo: rbernard@smm.orgSubject: RE: [Tessitura Ticketing Forum] # of Performances in a report
From: Ray Bernard <bounce-raymondbernard7790@tessituranetwork.com>Sent: 9/15/2012 1:17:06 PM
Clean Clean false false false EN-US X-NONE X-NONE