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.
Hi Nick,
The URL would basically be the webreports URL, and assuming the report is customer_no specific, you can just put a render and customer_no command on the end of it so it looks like this:
http://<servername>/TessituraWeb/Reports/Report.aspx?reportId=<reportname>&Command=Render&customer_no=<<key>>
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?
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.
Unknown said: 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.
I've made a number of SSRS custom tabs here, and they are all set up in TR_CUSTOM_TAB with a URL in the d_object field, e.g. a Volunteer hours tab:
http://db2/ReportServer_db2/Pages/ReportViewer.aspx?/gt_tess_shared/ld_vol_hist_tab&customer_no=<<key>>&rc:Toolbar=false
There is no prompt to authenticate. It's been a while since I set this up, but as I recall we avoid that by setting up our shared data source (used in common by all custom SSRS reports) to connect using "Credentials stored securely in the report server", set to an AD user that is also set up in SQL Server with the necessary privs.
Okay, I see. It does seem as though that relies upon AD to authenticate to the SSRS server.
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?
From: Nick Reilingh <bounce-nicholasreilingh4883@tessituranetwork.com> Sent: 7/11/2016 4:23:26 PM
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!