Hi all,
(I also put this in Ticketing forum - apologies for redundancy.... :)
Our company processes all of our Sub orders and a portion of our single ticket orders. The rest are taken via the venues where we present work. We create order forms for the orders we process and send them to the venues so that they can input them in their system. The venues print the tickets, send them back to us, and we mail those tickets to our subscribers and donors.
So that we can normally process exchanges and returns, we still have to print the tickets we process at our offices - but these are not the tickets that the customers eventually receive.
Until now, I have been creating the order forms that we hand off to the venues using a massive SELECT statement in SSMS and then a simple Word Mail Merge. I'm hoping to get this order form to run out of the Tess for our ticket services staff to run - but before I build the SP and report, I am wondering if there is a way to make this order form "print" a ticket -- instead of having to run this order form report, AND print the redundant tickets. (waste of paper, scary amounts of human error possible, etc...)
In a dream world, it would be like the Development Print Acknowledgement Report or Premium Report - where there was a review mode and then a print mode, where the sli_status was changed, et al.
Has anyone done anything like this? Or have any query I could review or lift? Or just thoughts on why this would NEVER work?
Thanks!
Frannie
Would a NULL PRINTER for tickets help in your case, Fran? Certainly doing everything at once with your SP/report would still be faster, but at least "printing" the tickets to a non-existent printer would save on stock...details in this post:
http://www.tessituranetwork.com/Community/forums/t/7699.aspx
Beth
Sean and Beth,
Thanks both for your responses!
I'm definitely going to use WP_PRINT_ORDER in the SP I'm building - that's a great help.
And Beth, until we've got this going, we're definitely going to look into the NULL Printer. Save the trees!
Thank you again -