lokking for a report to print out all seats on an Order

I have a promoter who just took 4oo reserved tickets to sell on his own. and now he is asking for a list of all those seats.  I placed them in one order. So I am wondering if there is way to pull up and print a list all the seats on a specific order.  I found I could get them in a round-about way by pulling a Performance Seating Book. But that requires dumping it into Excel and a lot of editing which means more human error chances.  Does anyone know a better way?

  • You could batch print the tickets to a file, but that will mark them as printed.  You’ll have to remember then to go back and reprint them when it’s time to print the physical tickets.  If that’s not too much trouble for you it should give you the data you want.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • thanks Kevin....actually, he already has the tickets in his possession and now he wants the list....so reprinting the tickets is not a option.

  • I have a report that I’m willing to share if you have someone who can install it or run the query behind it; it shows all seats for a particular customer, filtered by performance date range.

     

    Lucie

     

    ___________________________________

    Lucie Spieler

    IT Development and Training Manager

    Editor, Season Program

     

    Florida Grand Opera

    8390 NW 25th Street

    Miami, FL 33122

    305.854.1643 x 1521

    Box Office: 800.741.1010

    To Give a Gift: 305.403.3315

    www.FGO.org

     

    2010-2011 | 70TH SEASON | THE MYSTERIES OF LOVE

    Turandot | The Tales of Hoffmann | Don Giovanni | Cyrano

     

  • That would be beautiful and just what I need.  Here is my database guru's contact info:

    Jeff Stahel

    jstahel@tpac.org

    Database Administrator

    Tennessee Performing Arts Center

    615-782-4021

    I will let him know to expect the report.  Thank you very much...and please pardon my terrible typing / mis-spelling please!

  • We have a report that gives the seat details based on the order number entered, so that it can be broken down even further  by customer if needed.

    The output shows, the section, row, seats, total for each row, the price per seat and then the total values; I'd be happy to share if this would also be useful.


    Caryl

  • Caryl, That would be perfect!  Send it to me and my Database Administrator, Jeff Stahel.

    We got one report but I think yours is more in line with what I need.  Thanks for the help!

     

    Ginger Muse
    gmuse@tpac.org

    Ticketing Manager
    Tennessee Performing Arts Center

    615-782-4063

    Jeff Stahel

    jstahel@tpac.org

    Database Administrator

    615-782-4021

     


    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!