Hi all,
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? I may also post in Tech form so apologies for two alerts..
Thanks!
Frannie