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. It contains hyperlinks to the folder, report, subscription and execution log as well as various parameters to maintain quality. |
Report Subscriptions
This report is used for querying the deployed subscriptions and their schedules. It contains hyperlinks to the folder, report, subscription and execution log as well as various parameters. |
Report Execution Log
This report is used for querying the report server exection log. It contains various parameters to filter the results. |
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. |
Power BI Template
A Power BI template with a matrix formatted as a calendar, bookmarks for day, week, month, quarter and year to change the date timeline selection and the X axis date hierarchy level on charts. It includes date filtering based on timeframes and ageing. |
- Activity Monitor
- Data Sources
- Database Dictionary
- Execution Log
- Heat Map Calendar (using execution log)
- Integrations
- Job Search
- Permissions
- Scheduled Jobs
- Report List
- Subscriptions