Somehow I have it in my head that it is possible to display an SSRS report in a custom tab, but now that I'm digging into it, I'm finding myself very confused.
From what I can tell, I'm supposed to set up the row in TR_CUSTOM_TAB as a browser-based window, and access the SSRS report by URL, optionally with token parameters. But I've never actually accessed an SSRS report in this way--we implemented on 12.0 and so I've only accessed it through WebReports.
Am I supposed to build a URL that accesses the SSRS report through WebReports, within the current client user's session? If I use a URL that hits the report server directly, won't the user have to authenticate? (We are not in an AD environment, so this is not possible.)
Some guidance would be appreciated.
What is being used here is URL based report rendering directly on the SSRS Server. TessituraWeb/OnTheGo does not support this directly. For more information, you may go here:
https://msdn.microsoft.com/en-us/library/ms155391.aspx
Make sure you are referencing your applicable version of SQL Server in the docs.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Renville Williams Sent: Tuesday, July 12, 2016 11:37 AM To: Ryan Creps <rcreps@tessituranetwork.com> Subject: Re: [Tessitura Technical Forum] SSRS in custom tab?
For us we use the link to the SSRS report instead of the tessitura web... For Example
http://<servername>/ReportServer/Pages/ReportViewer.aspx?<reportname>&rs:Command=Render&<parameter>=<<key>>
<servername> is the name of your SSRS server
<reportname> is the html link for the report location and name.. eg: %2fProduction_Details%2fprod_info_details
<parameter> the parameter needed for the report to run. eg: perf_no=<<key>>
I hope this helps.
From: Nick Reilingh <bounce-nicholasreilingh4883@tessituranetwork.com> Sent: 7/11/2016 4:23:26 PM
I just gave this a try, and what displayed in the tab was the TessituraWeb login page. The user group dropdown didn't function. Somehow that didn't stop me from logging in, but then I got the standard homepage instead of the report I requested.
Am I missing something?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Okay, I see. It does seem as though that relies upon AD to authenticate to the SSRS server.