• Replies 18 replies
  • Subscribers 417 subscribers
  • Views 724 views
  • Users 0 members are here
Related

Comp Reason Report

Teresa Dean
$organization

I could have sworn there is a standard report that reports on number of comp seats and the comp reason....am I just imagining it or is there a report that will give me this information.  I have a company manager who is asking for it and I'm not having any luck finding it.

Thanks for the help everyone!!!

  • $organization
    I'm not sure about a standard report, but there is the Comp tab in Season Overview for a dashboard view.
    TStats is a very good and easy way to get comp reason info.
    Sharon

    Sent from my Verizon Wireless BlackBerry

    From: "Teresa Dean" <bounce-teresadean9276@tessituranetwork.com>
    Date: 14 Sep 2010 17:51:48 -0500
    To: <sgrayton@cincinnatisymphony.org>
    ReplyTo: "Tessitura Ticketing Forum" <forums-ticketing@tessituranetwork.com>
    Subject: [Tessitura Ticketing Forum] Comp Reason Report

    I could have sworn there is a standard report that reports on number of comp seats and the comp reason....am I just imagining it or is there a report that will give me this information.  I have a company manager who is asking for it and I'm not having any luck finding it.

    Thanks for the help everyone!!!




    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!
  • Former Member
    Former Member $organization

    Teresa,

     

    I have a Price Type Reason report that I have written.  I just uploaded it to my file area here on the website.  One of these days I’ll get around to submitting it as a shared report, but until I do, grab it off my profile page.

     

    Let me know if you have any problems with it.

     

    Good luck.

     -steve

    Information Technology Manager

    The Granada

    (805) 899-3000 x 111 (phone)

    (805) 899-3081 (fax)

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Teresa Dean
    Sent: Tuesday, September 14, 2010 3:52 PM
    To: Steve Carlock
    Subject: [Tessitura Ticketing Forum] Comp Reason Report

     

    I could have sworn there is a standard report that reports on number of comp seats and the comp reason....am I just imagining it or is there a report that will give me this information.  I have a company manager who is asking for it and I'm not having any luck finding it.

    Thanks for the help everyone!!!




    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!

  • $organization

    Fantastic Steve, thanks so much. I'll dive in and check it out in the morning.

    Teresa

    From: Tessitura Ticketing Forum
    To: Teresa Dean
    Sent: Tue Sep 14 18:16:52 2010
    Subject: RE: [Tessitura Ticketing Forum] Comp Reason Report

    Teresa,

     

    I have a Price Type Reason report that I have written.  I just uploaded it to my file area here on the website.  One of these days I’ll get around to submitting it as a shared report, but until I do, grab it off my profile page.

     

    Let me know if you have any problems with it.

     

    Good luck.

     -steve

    Information Technology Manager

    The Granada

    (805) 899-3000 x 111 (phone)

    (805) 899-3081 (fax)

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Teresa Dean
    Sent: Tuesday, September 14, 2010 3:52 PM
    To: Steve Carlock
    Subject: [Tessitura Ticketing Forum] Comp Reason Report

     

    I could have sworn there is a standard report that reports on number of comp seats and the comp reason....am I just imagining it or is there a report that will give me this information.  I have a company manager who is asking for it and I'm not having any luck finding it.

    Thanks for the help everyone!!!




    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!




    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!
  • $organization in reply to Teresa Dean

    In case anyone has a problem with the zip that Steve uploaded to his profile, I have also uploaded it to our site file storage; it can be found at this link.

    Todd

  • $organization in reply to Teresa Dean

    Steve,

    I downloaded and installed the report and it's working beautifully.  It's exactly what I needed and was so easy to get into my system.  Thank you so much for the report!!!!!

    Teresa

  • $organization in reply to Teresa Dean

    Thanks very much for the report Steve.

    Have just installed it here at the Abbey in Dublin.

     

    cheers, Dara

  • $organization in reply to Dara Hogan

    Is anyone still using this report? I'd like to install it on our system, but this custom report is several years old now, and I wonder if anyone who uses it has had to make edits to it as Tessitura has upgraded. 

  • $organization in reply to Summer Hirtzel (Past Member)

    Is this report still in use? I would also like to install it if someone doesn't mind sharing. 

    Thanks,

    Kyle

  • $organization in reply to Kyle Jarvis (Past Member)

    I can't speak to the previously shared report, but it is possible report on comp reasons in T-Stats using the Ticket Order Details dimension. The attribute name is Price Type Reason. Kyle, I know you just started your T-Stats implementation, but once it's installed, that approach might be a good option.

  • $organization

    I'm looking for help to see if I can add Price Type Reason to the Attendance by Performance report. Anyone have any thoughts? I can't seem to find a recent thread on price type reasons. 

    Thanks,

    Susie

    Broadway Sacramento 

  • $organization in reply to Susie Evon

    Price Type Reasons are in the TR_COMP_CODE table. You can join it from the T_SUB_LINEITEM table.

    LEFT JOIN TR_COMP_CODE AS CC WITH (NOLOCK) ON CC.id = SLI.comp_code

  • $organization

    Hello Community!

      - several years back, you'd mentioned (below) that you'd uploaded this report (the one uploaded by Steve) to the to the Tess site file storage as well, and provided a link.  The link now returns a 404 error.  I'm wondering if there is a any chance you might still have this report tucked away somewhere that you would be willing to re-share.  I realize that there have been many, many changes to Tess since the report was originally posted, and I certainly can start from scratch if necessary; but I would much rather avoid completely reinventing the wheel if there is something to use as a starting point that I could modify/adapt to the current version.  (I am specifically interested in a report, as opposed to a dashboard, so that the information can be easily downloaded as Excel/CSV and then uploaded into our external financial system).

    Thank you!

    Mandy

  • $organization in reply to Mandy Jarvis

    Hi Mandy, I've taken a look around and unfortunately not found that file; I think it has disappeared and/or been deprecated over the years. Sorry! Maybe someone here will have a newer/updated version that they use. Good luck!

    Todd
    Tessitura Network

  • $organization in reply to Todd Lantry (he/him)

    Hi Todd,

    I will continue my search.  I very much appreciate you checking the files!

    Thank you!
    Mandy