• Replies 12 replies
  • Subscribers 418 subscribers
  • Views 220 views
  • Users 0 members are here
Related

Special Request

Doug Coon
$organization

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
  • $organization

    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 

Reply
  • $organization

    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 

Children
No Data