Reporting Services Examples Save
:closed_book: Various example reports I use for SQL Server Reporting Services (SSRS) as well as documents for unit testing, requirements and a style guide template.
Project README
Microsoft Report Server (SSRS & PBIRS)
The following examples are used to query the database & report server. I have included some useful scripts and documents as well.
InstallsPower BI Report Server
SQL Server 2022 Reporting Services
SQL Server 2019 Reporting Services
Visual Studio
Reporting Services Projects 2022
SQL Server Management Studio
Azure Data Studio
Azure DevOps Services
Notepad++
Report Listing
This report is used for querying the deployed reports, their subscriptions and their execution logs. |
Report Subscriptions
This report is used for querying the deployed subscriptions and their schedules. |
Report Execution Log
This report is used for querying the report server exection log table. |
Heat Map Calendar
The report uses a nested tablix inside of a matrix to show a calendar view. The heat map is implemented using a function with a report variable for the base color to produce a gradients of the color. Each day on the calendar can be hyperlinked to a detailed Reporting Services report. |
File List
Reports
- Activity Monitor
- Data Sources
- Database Dictionary
- Execution Log
- Heat Map Calendar (using execution log)
- Integrations
- Job Search
- Permissions
- Scheduled Jobs
- Report List
- Subscriptions
Documentation
Scripts
RSS Scripts
VB Scripts
SQL Scripts
- Report_Datasets
- Report_Linked
- Report_Snapshots
- Report_Subreports
- Source_Control_Current
- Update Subscription Owner
M Scripts
DAX Scripts
Open Source Agenda is not affiliated with "Reporting Services Examples" Project. README Source: SQL-Server-projects/Reporting-Services-examples
Stars
121
Open Issues
0
Last Commit
4 weeks ago
License
Open Source Agenda Badge
