SSRS Report

Parent Previous Next

SSRS Report


Tutorial Video


SSRS System Requirements

  Each version of SQL Server Reporting Services (2005 or above) that the user wishes to document.

  SQL Server Data Tools or Business Intelligence Development Studio.

  Support provided for the following report locations

o   File System: SQL Server 2005 and above

o   Native Web Services: SQL Server 2008 R2 and above

o   SharePoint Web Service: SQL Server 2008 R2 and above


Best Practices

BI Compare

Documentation

Lineage

Data Dictionary


Important Note:

KPIs are currently not supported when connecting to an SSRS 2016 or above Report Server


Getting Started

User must have SQL 2008R2 Reporting Services or higher in order to document. Permissions on server must be: Browser in the report tree and system user on the web server itself.


1.   After creating a solution, click the "Add" button on the right side of the page


       


2.   Give the solution item a meaningful name


3.   Select the SSRS provider from the source type drop down


   


4.   The SSRS Provider contains several connection options:

1.   File: Select File to document SSRS Item(s) located on the file system. Clicking the ellipses will launch the file explorer, allowing users the opportunity to navigate to the location of any *.rdl, *.rds, *.rsd, or *.rptproj files.

2.   Folder: Like File, select Folder to document SSRS Item(s) located on the file system. Unlike file, the Folder option will recursively document all SSRS items located within the folder. Clicking the ellipses will launch the file explorer, allowing users the opportunity to select a folder that contains at least one SSRS item.

3.   Native Web Service: Select Native Web Service to document an SSRS Native Web Service. Use the Folder text box to only document specific folders within an Native Web Service.

4.   SharePoint Web Service:  Select SharePoint Web Service to document an SSRS SharePoint Web Service. Use the Folder text box to only document specific folders within an Native Web Service.


5.   You may also customize your documentation by adding filters


Important Note:

Excluding certain types may affect Lineage Analysis.



6.   Click "OK" to add the SSRS items to the Solution Items window  


Sample Output

DOC xPress documents SSRS Reports found on the File System across the following versions of SQL Server: 2008, 2008 R2, and 2012. Additionally, DOC xPress documents SSRS 2008 R2 and 2012 Reports in both Native and SharePoint Integrated Mode. With SSRS Report documentation you can view the properties, parameters, and data sources of a report.



Use the documentation to gain a better understanding of what tables your reports are using by viewing the data set of the report.