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

Desired Configuration Management – NLA for Remote Desktop

With the MS12-020 RDP explit that was just announced, I wanted to be able to determine which of our servers have Network Level Authentication enabled for Remote Desktop, which will help reduce the risk until they are patched.  I created a Configuration Item to determine if NLA is enabled based on the UserAuthentication value being set… Continue reading Desired Configuration Management – NLA for Remote Desktop

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