I posted this in a different group here but someone suggested I post it in this discussion group too.
Does anyone out there have a good VERIFICATION report for checking your performances? I've used a variety of ticketing systems in the past and always had to struggle with checking that I got everything just right. I've built this in sql and reporting clients in the past for other systems, but I'm new to being a Tessitura client.
There's the Performance Listing report in the Ticketing Box Office folder. Here's the link to the documentation: https://docs.tessitura.com/Help_System_v151h/Tessitura.htm#Performance%20Setup/Proofing%20Performance%20Setup.htm.Anne RobichauxThe Historic New Orleans Collection
Yeah, that's got a piece of it... but I'm really looking for something that will show all the content with the different price zones, prices/fees, holds, capacities, ticket-text, mode-of-sale info, content, keywords, etc.
I'm hoping a squeaky wheel will get some oil.
Hi Mark! :) There's no canned report that will show all of the ticketing detail. At TLCC last year, Christy Carlson from Tessitura mentioned that it's a frequent request for custom reports. I think this would be a great one for the ideas board! But if anyone on here would like to share what's on their custom report, I'm all eyes...
I got this from someone in the forums years ago. See if it helps. I drop it into Excel and sort away.
---- To give you a list of performances in a certain season, the p. types attached ---- GL code, campaign and ticket design on a price zone level---- very detailed. Replace ### with season ID.
select c.perf_code, f.description as title, c.perf_dt, d.description as pt_desc, b.description as pmap_desc, h.description as zone_desc, g.price, k.description as tkt_design, b.gl_hold_no, e.description as campaignfrom VXB_PERF_PMAP ajoin t_design k on a.design_no=k.design_nojoin VB_PMAP b on a.pmap_no=b.pmap_nojoin t_perf c on a.perf_no=c.perf_nojoin tr_price_type d on a.price_type=d.idjoin FT_GET_PRICES (getdate()) g on d.id = g.perf_price_typejoin t_zone h on g.zone_no=h.zone_nojoin t_campaign e on c.campaign_no=e.campaign_nojoin t_inventory f on c.perf_no=f.inv_nowhere c.season = ###
I use this a lot as well.
Thanks Heather Fails. This is definitely going to be a help.
No worries. I know enough SQL to be dangerous so I couldn't have written this to save my life. It's always worked for me though.
I've got something I've written for our Box Office to check their set up. I'd be happy to send it over.I'm out of the office over the next few days, but if you pop your email here, when I'm back, I can package it up and send over.Caryl
Thanks Caryl, if you could email me at: mdlevine@mfah.org I would love it!
Enjoy your time off.
I would love it!! Please email me at mistiw@riversidetheatre.com