Hello everyone,
I have never shared a report to The Network but here at The 5th, we have a fun SSRS report that can be used to print out seat maps. It's formatted to print the report on 11x17 paper so the whole seating chart and show price type sales information appears on the one report. It does print one page for each performance of a run but it is nice because it gives you a really great visual of how your house looks and where you might need help with seating.
How do I go about extracting that report information out of our database and then upload it to Shared Reports here?
Best,
Christopher Cuhel
Hi Christopher!
First of all, I would encourage you to share this report using Bitbucket, instead of (or in addition to) the shared reports and utilities TASK space. That way, other organizations can collaborate on enhancements or fixes if it gets broken by future Tessitura updates. Information on getting access to that is here: http://tessituracoders.bitbucket.org/
There are a couple of files you will need to share: 1) The SSRS report's RDL file. This would usually be found in the Visual Studio Solution that was used for report development. If that is no longer available, you can still download the RDL file from your SSRS server's web management interface, which often would appear in the format http://<SQLSERVERHOSTNAME>/Reports_<SQLSERVERINSTANCENAME>/
2) If your RDL depends upon a database stored procedure (this is common and usually recommended), you will need to provide a SQL script for installing these procedures. You can generate scripts from SSMS. There are a couple of best practices for making scripts idempotent and SCM-compatible, but don't bother worrying over that if you're just getting started.
3) Report Setup XML. To tell Tessitura about the SSRS report and parameter configuration, export an XML file for the report from Tessitura Report Setup (gsrsetup.exe).
Hope this helps!
Thank you for that Nick. That is very helpful. I'll have to now figure out how to do all that technical stuff since I've never every done it before. Yay....I love learning. :)
-Christopher
I wrote a post a while ago that was about getting started and best practices for a lot of this stuff; here it is:
http://www.tessituranetwork.com/Community/forums/p/14632/44988.aspx#44988