- Home En
KB0184 - How to set up Resource Central to show reports from SQL Server Reporting Services
Setup on Resource Central
Reports in SQL Reporting Service are supported in RC 3.8 Hotfix 4 (and higher versions) with the following changes:
- Go to RC backend, create the “ReportServer.URL” parameter. Fill in the value with a link to the SSRS server.
Note: There must be no “/” character at the end of the URL in ‘Value’ field.
- When the parameter is created, a new option “Add URL” is added to the context menu of Reports tree.
- You can create a new link to actual SQL Reporting Services report.
Setup to avoid navigation in SSRS report
Note: This is a global setup/change made on the Reporting services Server, i.e. if you are using Reporting Services Reports for other purposes then this changes will also be reflected.
When a SSRS report is included in Resource Central, it provides access to some other links (as in the following figure):
To avoid this navigation, follow these steps:
E.g. In Reporting Services 2008 (R2), the default path to this folder is C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager
SSRS report sample in RC
When you click in the report link, the report from SQL Reporting Services is rendered in RC system:
SQL Server Reporting Services (SSRS) is a third party tool provided by Microsoft. Therefore, support of how to install and operate SSRS to produce reports for Resource Central is out of the scope for our Maintenance agreements (SLA’s) – both Standard and Gold level.
Applies to: RC 3.8 Hotfix 4 and higher versions
Reference: TFS #60556
Knowledge base ID: 0184
Last updated: Feb 23, 2016