Subscription Confirmation Reports

Thank you!

On May 23, 2013, at 16:59, "Daniel Gomez" > wrote:

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 Martin
Sent: Thursday, May 23, 2013 5:08 PM
To: Daniel Gomez
Subject: RE: [Tessitura Shared Reports Forum] Subscription Confirmation Reports

Por favor, I’d like a copy as well :)

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Daniel Gomez
Sent: Thursday, May 23, 2013 3:54 PM
To: Robert Martin
Subject: 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.

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!



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!

Thank you!

On May 23, 2013, at 16:59, "Daniel Gomez" > wrote:

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 Martin
Sent: Thursday, May 23, 2013 5:08 PM
To: Daniel Gomez
Subject: RE: [Tessitura Shared Reports Forum] Subscription Confirmation Reports

Por favor, I’d like a copy as well :)

From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Daniel Gomez
Sent: Thursday, May 23, 2013 3:54 PM
To: Robert Martin
Subject: 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.

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!



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!