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 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
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 ShortSent: Wednesday, April 30, 2014 3:22 PMTo: Coon, DougSubject: Re: [Tessitura Customer Service Forum] Special Request
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
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!
That would be great!