Our marketing department would like to send out confirmations to all of our subscribers. The regular confirmation letter contains most of the information we are looking for except for one big piece. They would like to include the names of each performance with dates, times and seating information for each. (We sell fixed, flex and super-packages).
We are looking for a shared report or an easy way to gather this information to excel so we can merge into a word document. We would like to send this out at the beginning of June.
Thanks
Margaret
Hah. Gladly, Robert. My DBA is out this afternoon. Once he’s back in tomorrow, I’ll get the script and shoot it over your way.
Best,
DGomez
Daniel V. Gomez
Director of Information Technology
ROUNDABOUT THEATRE COMPANY
231 West 39th St. | Suite 1200 | New York, NY 10018
Phone: 212.719.9393 ext. 345 | Fax: 212.869.8817
danielg@roundabouttheatre.org | roundabouttheatre.org
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Robert MartinSent: Thursday, May 23, 2013 5:08 PMTo: Daniel GomezSubject: RE: [Tessitura Shared Reports Forum] Subscription Confirmation Reports
Por favor, I’d like a copy as well J
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Daniel GomezSent: Thursday, May 23, 2013 3:54 PMTo: Robert MartinSubject: RE: [Tessitura Shared Reports Forum] Subscription Confirmation Reports
Hi Margaret,
We’ve actually created a custom stored procedure that enhances the SP powering the out-of-the-box “Package Order Listing” Report ([RP_PKG_ORDER_REPORT]) in Tessitura. It is rather specifically tailored to our subscriptions and we focus primarily on seat locations -- we don’t pull performance dates and times, though that information should be available -- but it would at least give you a point from which to start.
Shoot me an email and I’ll happily share the script with you.
From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Margaret StocktonSent: Thursday, May 23, 2013 4:15 PMTo: Daniel GomezSubject: [Tessitura Shared Reports Forum] Subscription Confirmation Reports
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!