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.

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 Margaret Stockton
Sent: Thursday, May 23, 2013 4:15 PM
To: Daniel Gomez
Subject: [Tessitura Shared Reports Forum] Subscription Confirmation Reports

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

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!

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!

Por favor, I’d like a copy as well J

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.

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 Margaret Stockton
Sent: Thursday, May 23, 2013 4:15 PM
To: Daniel Gomez
Subject: [Tessitura Shared Reports Forum] Subscription Confirmation Reports

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

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!

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!

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!

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.

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 Margaret Stockton
Sent: Thursday, May 23, 2013 4:15 PM
To: Daniel Gomez
Subject: [Tessitura Shared Reports Forum] Subscription Confirmation Reports

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

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!

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!

Can I get a copy of this as well?

I've been wanting to do this since I got here. I don't know where the script goes once I get it though.

Thanks.

Adria

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!