Like most of you I have been converting classic Configuration Manager reports to SQL reporting services. For most reports it works right out of the box. But for some reports you need to do a little tweaking in the SQL statement or in the report properties. An example of this is the Client Status report. When you run the report as a classic ConfigMgr. report, you don’t have to select a value in the prompt. If you run the same report with SQL reporting Services you are forced to select a value in order to run the report:

If you don’t select a value you won’t be able to run the report

To allow Null values

In the reporting Services website open the report Properties. Click on the Parameters link, select Null and click Apply.

Next time you run the report you are not required to select a value.