Default Report Parameters SSRS

To set default report parameters in SQL Server Reporting Services (SSRS) which is used by SCCM 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.

Parameters

  • 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.

Final Report

These steps may vary slightly depending on the SSRS version used; SQL 2005, SQL 2008 or SQL 2012.

email

Written by , Posted .