Performance Custom Tab for Concessions Sales

Hi Dan.

I've not used a custom tab for Performances, but I've done quite a few for Constituents using SSRS (I'm staying well away from Infomaker!). I've just done a small test of showing the Perf Code of the selected Performance on a Custom tab (which worked) so let me know if I can be of any help...

Steve

Hi Steve, 

Thanks for offering to help. I am not familiar with SSRS either, but it may work.  I believe I just need a simple datawindow created to house the concessions sales total.  It would only require 1 editable field labeled "concessions sales".  Does this make sense? 

If it's not too much trouble, I am also struggling with the proper SQL code to use for a flex header element that will display an icon if the constituent's emarket restriction is set to "verify email".  It seems like it shouldn't be too difficult, but again I am a novice with SQL.

Thank you!!

Dan

Dan,

A few questions:

• Who would be entering the concession sales information and would they have access to Ticketing Setup, or just Season Manager?
• Should data-entry be limited to a select group of Users?
• Should viewing the data on-screen be restricted to a group of Users or be generally visible?

Regarding the Flex Header code:

SELECT '.' FROM T_CUSTOMER AS tcust WITH (NOLOCK) WHERE tcust.customer_no = @customer_no AND tcust.emarket_ind = 3

Use the above as the SQL Code for a Flex Header Element in TR_FLEX_HEADER_ELEMENT, and add that element to the relevant Flex Header  record in TR_FLEX_HEADER, changing the value of "emarket_ind" to the value of "Verify Email" in your system (check TR_EMRKT_IND for the list of values). See the Tessitura Help system for more info on Flex Headers (under Constituent Navigator).

Icons will be displayed if the SQL attached to their position returns data. See the Help System "Flex Header Recipe Book" for more info.

Dan,

A few questions:

• Who would be entering the concession sales information and would they have access to Ticketing Setup, or just Season Manager?
• Should data-entry be limited to a select group of Users?
• Should viewing the data on-screen be restricted to a group of Users or be generally visible?

Regarding the Flex Header code:

SELECT '.' FROM T_CUSTOMER AS tcust WITH (NOLOCK) WHERE tcust.customer_no = @customer_no AND tcust.emarket_ind = 3

Use the above as the SQL Code for a Flex Header Element in TR_FLEX_HEADER_ELEMENT, and add that element to the relevant Flex Header  record in TR_FLEX_HEADER, changing the value of "emarket_ind" to the value of "Verify Email" in your system (check TR_EMRKT_IND for the list of values). See the Tessitura Help system for more info on Flex Headers (under Constituent Navigator).

Icons will be displayed if the SQL attached to their position returns data. See the Help System "Flex Header Recipe Book" for more info.

Hi Steve, 

I was able to figure out the flex header element! Thank you!

As for the custom tab; our Box Office Manager would be entering the concessions sales info and she has access to both Ticketing Setup and Season Manager. Data entry and viewing rights can be available for all users, which should help make it easer.  

Thanks again so much for offering to help with this!

Dan

No probs.

Regarding the Concessions info, adding it as an Inventory Content item would alleviate the need for a custom table and custom report to enter the data. It would also then be readily available for reporting looking at TX_INV_CONTENT. Probably not the use of TR_INV_CONTENT that was intended by the programmers, but this would be the simplest non-custom solution of storing data at a Performance level.

Happy to help further if you want to use a Custom Screen?

Hi Steve, this sounds much better! I was able to setup this inventory content and entered an amount under a performance as a test, but I am not sure how to run reports to show this.  You mentioned the reports can be used looking at TX_INV_CONTENT, would I run a query to that table in SSMS, or is there an easy way to pull this from an already existing report? I looked around and couldn't seem to find it anywhere. Would I maybe need to set this up to track in Analytics instead of reporting? 

Thank you, 

Dan

I can advise (and assist!) with SSRS reports and it won't be difficult to write one that can display the values you enter (btw are you self-hosted or RAMP?) but I've not had much to do with Analytics. Can anyone else in this forum assist here?

I can't look at the moment, but if I get a chance tomorrow in the office I'll take a look...

THANK YOU!! You are a rock star! What can I do to help the process along?

I did just submit a task ticket asking about the analytics side of things, but if anyone out here in forumland can help it would be great!

Steve, I just found documentation on how to add an SSRS report to Analytics and it looks pretty straight-forward.  I should be able to do so myself once the SSRS report is saved. :) Hooray!!

Sorry, I forgot to answer your question and we are RAMP hosted.

You need to think about how you want to limit the data displayed (what parameters are required - Season, Prod Season, date range etc), and how you want it to look (mock something up in Word). Happy to continue this via email if that's preferable?