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.
Notice that the classification report parameter is not populated.
- Click the Properties tab.
- Click the Parameters link.
- Select the Has Default check box next to classification.
- Next, select the down arrow.
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.
- 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.