Hi all,
I know you can share custom reports with the Tessitura Network, but I'm wondering how to share a custom report with another organization?
Thanks!
The other org will need the underlying SQL sproc, a XML export file containing the report parameters, and (for an SSRS report) an RDL file or (for an InfoMaker report) a PBL file.
The network shares a doc here:
https://www.tessituranetwork.com/en/Files/Docs/Customizations/Custom-Report-Setup
...which I believe provides more detail. Happy to answer more questions, also.
This is helpful, thanks! I'm going to see if I can work with the DBA from the other org since I'm not well versed in SQL. I currently have access to SSDT and SSMS, would I need to ask Tessitura for access to anything else?
Michelle Blau (Past Member) said:I currently have access to SSDT and SSMS
Excellent. I believe SSDT is a product subset of MS Visual Studio, which you'll need to work with an SSRS RDL file, and SSMS will be helpful to install SQL stored procedures among other things. Those plus Tessitura itself and you should have what you need to install SSRS reports. If you are on RAMP you will definitely need to work with Tess support as well.
We are RAMP. Depending on your SQL access, you might not actually need RAMP access. Depending upon what level they gave you, you might not have create permissions.
Basically, the process will be to take the SQL code for the procedure, create it, grant permissions. Then import the RDL file into SSDT, add it to your project and deploy it. Next, import the XML file for the report parameters into a new Report set-up. Lastly, grant access to user groups in Tessitura Security like normal.
Hopefully that helps!
John
RAMP assistance, not RAMP access. Stupid typing fingers.