Does anyone have a report that shows a map of where individual groups are seated and which school/institution they belong to - that you might share with Yale Repertory Theatre? Thanks in advance.
Hey Ruth, One way to do this is get all the X and Y's from the seat map that make up the house and X and Y's for seats in the order. Have a column that indicates when a position or seat is seated in your data set. Then create a scatter plot using the X and Y's and when the indicator ="seated" then do a conditional color change on that point (example: grey to red). Put the group name and any other information in report header. I found the hard part is adding the section, row and seat number in the scatter plot that looks good to me, so I have not finished ours, but I will get back to it at some point after I complete some bigger projects. Hope this helps.
Travis
--Edit
After I responded to this post, I was able to spend a hour or so on seat map report this afternoon with a colleague. We found it is best to use a matrix. We were able to get this working for all three of our venues. There is a little more tweaking yet but it is almost there. Once I finish this up I will certainly share it you.
Hey Ruth, I was able to get this pretty much done. Take a look a the example pdf I uploaded.
http://www.tessituranetwork.com/Community/members/travisarmbuster9061/files/MySeats_5F00_by_5F00_pricetype.pdf.aspx
I created one version that the Groups Sales gives out with the contract. Which is the same as the attached, but only with one group. The second is for the sales managers or house managers to run for a visual of the house that shows each group up to 15 groups. There is no limit to the amount of groups, but that is where I stopped on the conditional color statements. The user can click the customer number and open the order associated with the performance. Once I know this is tried and true, I will send it your way. I just want to make sure there are no issues before I share.
Hi Travis,
I am very much interested in using something like this for our student concerts. We give our ushers a house map that we create in Excel and physically highlight to show where the groups sit (see photo below).
Could you share with me how you made this happen?
Sure, let me get the parts together. I will you directly early next week.
Hi Travis
We have a seat map that currently works well for us by assigning a letter to each of the groups and displaying this on the key. But I am currently looking at making ours easier to read at a glance for our front of house team/ushers.
I really like the colour that you have added to this :)
I'm just wondering if you wouldn't mind sharing a bit of information on the conditional color statements that you used?
Thanks
Ryan
You can have the whole thing! Task shared reports solutions 358 and 359. I you have any problems email me directly. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Thanks that's great! Have got that now.
Out of curiosity what is the largest number of groups orgs have attend one show. I am making a adjustment to this so there does not have to be a conditional color statement anymore. It pull from a table and pass the hex and color name to ssrs. I have about 50 colors in there now, but I wanted to know if people have more then 50 groups attending a single perf. I am hoping this makes it a super quick thing for people to just setup and use without having to adjust it at all.
Looking at the last couple of seasons, it looks like the biggest number that I can see for a single performance would be just over 40.
I'd say it would be unlikely to be 50+ groups for us for a single perf.