Hello,
I am doing seat upgrades for next season renewals. We have been tracking seating change requests through Spec Req. Can anyone tell me the best method to pull a list of renewed subscribers with a special request in their ticketing order?
Thanks in advance!
Doug
Hi Doug,
I don't believe there are any reports that look at Special Requests. The Package Seating Report is the best tool for identifying upgrade requests, but is contingent upon staff adding the Upgrade line item since the report looks for unseated line items in the specified package season.
My predecessor wrote a report that pulls Special Request data, but I don't have access to share it at this time. If you have someone inhouse who knows SQL perhaps they can assist you with a custom SSRS report?
I'll leave a note with our Database Manager to see if we can pull the code for this report and add it to Shared Reports in TASK when she returns.
Cheers!Short
Hey Short,
Thank you so much for your response. Hopefully something will come about.
Best,
From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Christopher Short Sent: Wednesday, April 30, 2014 3:22 PM To: Coon, Doug Subject: Re: [Tessitura Customer Service Forum] Special Request
Cheers! Short
From: Doug Coon <bounce-dougcoon7462@tessituranetwork.com> Sent: 4/30/2014 1:47:19 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Customer Service Forum. You may reply to this message to post to the Customer Service 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!
I acquired a report from someone else that pulls information from the Special Request and by list. Would you like me to shoot through an example?
Courtney @ Melbourne Recital Centre
From: Doug Coon [mailto:bounce-dougcoon7462@tessituranetwork.com] Sent: Thursday, 1 May 2014 6:22 AMTo: Courtney BeerenSubject: RE: [Tessitura Customer Service Forum] Special Request
From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Christopher ShortSent: Wednesday, April 30, 2014 3:22 PMTo: Coon, DougSubject: Re: [Tessitura Customer Service Forum] Special Request
From: Doug Coon <bounce-dougcoon7462@tessituranetwork.com>Sent: 4/30/2014 1:47:19 PM
That would be great!
Unknown said: I am doing seat upgrades for next season renewals. We have been tracking seating change requests through Spec Req. Can anyone tell me the best method to pull a list of renewed subscribers with a special request in their ticketing order?
I wrote a Special Request report years ago that I've recently finished re-creating in SSRS. It finds all requests on line items (pkgs included) relevant to selected perfs. It's used here by Box Office and FOH staff to report on all sorts of seating needs.
Not a perfect match to your needs, but if interested, I'd be happy to share.
Hi Chris,
Would it be possible to share that report? It sounds like something we'd find really useful!
Thanks,James
Sure, James; I'll get in touch offline.
Hi Courtney, was looking for the same thing regarding SR. Can you share that report with me as well?
Thanks,
Mike
Hi Mike,
Sure can! If you want to shoot me an email at courtney.beeren@melbournerecital.com.au and I’ll send you an example and if it’s what you’re looking for then I’ll send you the report.
Cheers,
Courtney
From: Mike Cheatwood [mailto:bounce-michaelcheatwooe4298@tessituranetwork.com] Sent: Wednesday, 3 June 2015 3:10 AMTo: Courtney BeerenSubject: RE: [Tessitura Customer Service Forum] Special Request
From: Courtney Beeren <bounce-courtneybeeren3479@tessituranetwork.com>Sent: 4/30/2014 6:44:26 PM
I'm a few years late to the party, but could I get a copy of that report as well?
I'll touch base offline.
Please, and thank you!
Hi Courtney - its been years since you posted this, but I am also looking for the same thing! If possible, could you please share?
Thanks!
Kayla