I was creating a report today for servers with a specific Operating System where I needed to include two parameters (Operating System and Service Pack level.) The values of the second parameter need to be dynamic based on the value selected for the first parameter. This can be accomplished using cascading parameters. Create the first parameter… Continue reading Creating Cascading Parameters with SSRS
Category: SQL Server Reporting Services
SSRS – Using Subject Alternate Names With SSL
I was setting up SSRS for use with SCOM 2012 and trying to configure reporting Services to use SSL with the actual server name and a more user friendly alias. We have a naming standard for our servers that includes department, service, and production state. This results in some user-unfriendly names (such as sys-scomdb-p01) so we end… Continue reading SSRS – Using Subject Alternate Names With SSL
Providing Report Parameters in URL for SQL Reporting Services
You can provide report parameters in the URL for a report in SQL Reporting Services, but you have to use Report Server (ReportServer/Pages/ReportViewer.aspx), not Report Manager (Reports/Pages/Report.aspx.) Browse to the following URL: https://<server>/ReportServer Browse to the report you want to use, the path to the report will show up in the URL. Append the parameter(s) to… Continue reading Providing Report Parameters in URL for SQL Reporting Services
Cascading Parameters in SSRS
I was creating a report in SCCM for servers with a specific Operating System where I needed to include two parameters (Operating System and Service Pack level.) The values of the second parameter need to be dynamic based on the value selected for the first parameter. This can be accomplished using cascading parameters. Create the first parameter (OSVersion) for… Continue reading Cascading Parameters in SSRS