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?
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