Special Request

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

Parents
  • 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 AM
    To: Courtney Beeren
    Subject: RE: [Tessitura Customer Service Forum] Special Request

     

    Hey Short,

     

    Thank you so much for your response. Hopefully something will come about.

     

    Best,

     

    Doug

     

    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

     

    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 

    From: Doug Coon <bounce-dougcoon7462@tessituranetwork.com>
    Sent: 4/30/2014 1:47:19 PM

    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




    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!




    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!

  • Former Member
    Former Member $organization in reply to Courtney Beeren

    Hi Courtney, was looking for the same thing regarding SR. Can you share that report with me as well?

    Thanks,

    Mike

Reply Children
No Data