SSRS Overview
How to login and use to the SSRS service
RDP to Server
Then login to
http://<server_name>/Reports/Pages/Folder.aspx
with Internet Explorer (exclusively)
General options for SSRS:
From here you can:
Run Report Builder
Modify Folder permissions
Upload new objects
Manage the properties of existing objects
Edit an object in Report Builder
User Management:
How to grant roles to Users:
On the SSRS Service Page click on Ordnereinstellungen
Click on "Bearbeiten" next to the user which should get a new role / remove a role:
Edit the role:
Adding a new user and roles:
Click on "Neue Rollenzuweisung"
Select Username, role and confirm:
Report Differences:
Use the below screencap as reference for differences in the queries between the SSRS instances
How to select and run the Reports:
Types of Report:
Standard Report
Global Report
Manual ID Report
Standard Report: This type of report has the naming convention: _standard
Standard Reports are used when it is asked for Specific Leasingnahmer, Vertragsnummer and Vertragskomponenten. For report execution requests, click on the appropriate report and fill in the 3 mandatory filters + click on View Report
The report results can be Saved in an Excel file for further handling 2. Global Report: This type of report has the naming convention: _global
Global Reports are used when it is asked for ALL Global Information to be included in a Report. The Report does not have filters and runs automatically. The report results can be Saved in an Excel file for further handling
Manual ID Report: This type of report has the naming convention: _manual_id
The Manual ID Report has a manual insertion for Specific Entity in order to get ALL Data for a Specific Entity. This means that anything that is selected in the 3 Fields is irrelevant as this will run the same Query
To run the Report for a different ID the @partnerids parameter has to be modified.
To do this in SSRS:
Click on Edit in Report Builder
Expand the Datasets field
Right click on Query
Modify the following Parameter to the required Entity:
Save the Report and run it normally
Overwrite report
Click the Upload File button
Click Choose File button
Choose the new report, tick the Overwrite item if exists button and press OK
Last updated