Is there a report that breaks down comps by the comp code (artist, staff, customer service, etc.)? Can't find one in the canned reports, as a list or in TStats.
Hi Ellen,
You can see a breakdown in Season Overview in the Season Manager module. There is a comp detail tab. I think there might also be some shared reports on TASK.
Hope that helps.
-Ryan
I have a custom SSRS report I could share if you are interested. It can be viewed by season summary or all the way down to one performance, and then can export to excel to get constituent details for each of those comps. Let me know if you're interested...
Beth
BETH GILLILANDUMS Tessitura System Administratorbethgill@umich.edu734-615-9579www.ums.org // www.umslobby.org
Perfect! Many thanks.
Ellen Holt
Concerts & Lectures
The Metropolitan Museum of Art
1000 Fifth Ave
New York, NY 10028
212.650.2706
212.650.2253, fax
Ellen.Holt@metmuseum.org
http://www.metmuseum.org/tickets
http://www.metmuseum.org
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Ryan Rowell Sent: Wednesday, July 31, 2013 1:09 PM To: Holt, Ellen Subject: Re: [Tessitura Ticketing Forum] Comp Report
From: Ellen Holt <bounce-ellenholt2442@tessituranetwork.com> Sent: 7/31/2013 11:37:32 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Also, Price Type Reason is an option in T-Stats in the tickets cube (under Ticket Order Details).
-p.
Patrick Schley Academy Services Manager
FIRST STAGE
Transforming Lives Through Theater
325 West Walnut Street | Milwaukee, WI 53212 (414) 267-2970 direct | (414) 267-2976 fax
Actually, season overview/comp detail works just fine – thanks!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beth Gilliland Sent: Wednesday, July 31, 2013 1:33 PM To: Holt, Ellen Subject: Re: [Tessitura Ticketing Forum] Comp Report
BETH GILLILAND UMS Tessitura System Administrator bethgill@umich.edu 734-615-9579 www.ums.org // www.umslobby.org
That too. Missed that one. Thanx!
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Patrick Schley Sent: Wednesday, July 31, 2013 1:58 PM To: Holt, Ellen Subject: RE: [Tessitura Ticketing Forum] Comp Report
Hi Beth,
Would you be able to share this report on TASK or email me the files? Been searching for a report like this for ages!
Thanks,
JH.
Jerry-
Sure! It was an early SSRS report we created, and not beautiful, but it works for us. Your Tessitura administrator(s) should be able to help install it. The SQL code is in the SSRS dataset itself, not a stored procedure, so there's only one "file" to install. We are on v11, if that makes a difference.
When you run the report in Tessitura, it only shows summary info - but if you export to csv, you'll see a line with names for each of the buyers. You'll certainly have to customize for your organization's use.
You can download the SSRS rdl zip from my profile files here.
Hope that helps!
-------------------
BETH GILLILAND
Tessitura System Administrator
bethgill@umich.edu
734-615-9579
www.ums.org // www.umslobby.org
One year later...yes, can you send me the report you use?