• Replies 7 replies
  • Subscribers 413 subscribers
  • Views 139 views
  • Users 0 members are here
Related

Ticket Numbers

Brandi Cline
$organization

Hello!  Is there a report that gives ticket numbers and constituents for a given performance/package?

 

Thanks!

  • $organization

    Hi Brandi,

    Do you mean # of tickets per constituent per performance?  If so, there is the Attendance by Performance report which you can run with Constituent Detail set to Yes.  That will give you their name, account number, # of tickets, and total counts by the selected performance(s).

  • $organization in reply to Jennifer Dulik

    I'm looking for the physical ticket number, not number of tickets.

  • $organization in reply to Brandi Cline

    Hi Brandi!

    If you or someone at your organization has the ability to create custom report we have a custom report that I built that I think returns what you want.  It returns all active ticket numbers (so if a ticket has been reprinted it just gives the one actual valid ticket number) by performance based on season and performance selection.  It also returns the customer number, customer name, and order number.

    It does not go by package, but I bet some could tweak it to allow that if someone knows SQL.  Feel free to e-mail me if you want me to send you the logic for it.

    John

  • $organization in reply to Janna Ellis

    In addition to the e-mails I just sent, I have also posted the logic, and two screenshots showing the report set-up and a sample running of the report to my profile.

    Feel free to let me know if you have any questions, concerns, etc...

    John

  • $organization

    Hi John,

     

    Would you mind sharing this with me as well (ksmith@floridastudiotheatre.org), or posting to your Network profile?  It could help alleviate a problem we’re having with reprinted tickets and scanning…

     

    Cheers,
    Kathleen

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of John Moskal II
    Sent: Thursday, October 27, 2016 9:52 AM
    To: Kathleen Smith
    Subject: Re: [Tessitura Ticketing Forum] Ticket Numbers

     

    Hi Brandi!

    If you or someone at your organization has the ability to create custom report we have a custom report that I built that I think returns what you want.  It returns all active ticket numbers (so if a ticket has been reprinted it just gives the one actual valid ticket number) by performance based on season and performance selection.  It also returns the customer number, customer name, and order number.

    It does not go by package, but I bet some could tweak it to allow that if someone knows SQL.  Feel free to e-mail me if you want me to send you the logic for it.

    John

    From: Brandi Cline <bounce-brandicline9461@tessituranetwork.com>
    Sent: 10/27/2016 8:23:46 AM

    I'm looking for the physical ticket number, not number of tickets.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • $organization

    Would you mind sending this to me at janna.ellis@yale as well?

     

    Thanks,

    Janna

     

     

    Janna Ellis

    Director, Yale Tessitura Consortium

    203-432-8822

     

  • $organization in reply to Janna Ellis

    FYI for anyone else who might be interested, this report has also now been loaded to the Shared Reports space; Solution # 362.

    Do not hesitate to reach out to me if you have questions.

    John