Default Report Parameters

To set default report parameters in SQL Server Reporting Services (SSRS) which is used by SCCM Current Branch, 2012 and 2007, using the report Overall Missing Software Update Status by Classification as the example, first, browse to the report.
Default Report Parameter Prompts
Notice that the classification report parameter is not populated.

  • Click the Properties tab.

Properties Tab

  • Click the Parameters link.


  • Select the Has Default check box next to classification.
  • Next, select the down arrow.

Drop-down Box
Since the Overall Missing Software Update Status is a multi-select box, you need to add one row for each item that is to become the default. In our example the defaults are Critical Updates, Security Updates, and Service Packs.
Set Classifications

  • Once completed click Apply.
  • Click the View tab.

From this point forward when this report is executed, all the report parameters will be prepopulated. The report will only display the classifications that have been selected within the defaults. Also notice that the report parameters are still visible and can be manually changed.

These steps may vary slightly depending on the SSRS version used; SQL 2005, SQL 2008,  SQL 2012, SQL 2014, SQL 2016 or even the beta of SQL 2017.

Leave a Comment

Availability Strategies for a Resilient Private CloudRemotely Determine the SMS Provider Using WBEMTest
Share via
Copy link