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.
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.