SSRS Reporting Service URL commands

When you would like to access Report Server from your application or just link reports, you can use URL of Report Server for such a task. URL access to Reporting Services supports few useful commands you can handle visualisation your reports.

There are following sets of commands you can change look your Reporting Services.

Find more info here: https://bit.ly/2SYlgr0 .

Find few examples bellow.

Hide Toolbar with parameters.
http://dwh/Reportserver?/Blog/ReportSales7 - Interactive sorting&rc:Parameters=Collapsed
Collapsed toolbar
Picture 1 – Collapsed toolbar
Go to second page.
http://dwh/Reportserver?/Blog/ReportSales0 - Detail data&rc:Section=2
Report second page
Picture 2 – Report second page
List reports in directory.
http://dwh/Reportserver?/Blog/&rs:Command=GetChildren
List directory
Picture 3 – List directory
Get PDF format of report.
http://dwh/Reportserver?/Blog/ReportSales0 - Detail data&rs:Format=PDF
Export report
Picture 4 – Export report

Extended events get description

Useful query to get basic overview of extended events, actions and targets and their description.

SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name],  o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid = o.package_guid
WHERE o.object_type = 'event'
SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name], o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid= o.package_guid
WHERE o.object_type ='action'
SELECT p.name AS [Package-Name], o.object_type, o.name AS [Object-Name], o.description AS [Object-Descr], p.guid AS [Package-Guid]
FROM sys.dm_xe_packages AS p
JOIN sys.dm_xe_objects  AS o ON p.guid = o.package_guid
WHERE o.object_type = 'target'

Extended events query plan

I need to cover few scenarios related to SQL statements or procedures and their Execution plans and IO statistics:

  • To monitor stored procedures performance running on server
  • To get execution plan from procedures not easily accessible from management studio
    • Procedures called from Service Broker applications
    • Complicated access to execution plan (Huge nested level of SQL statement – cursors)
  • Compare batches in testing labs

I decided to use Extended Events as lightweight solution for such a scenario.