Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


SSRS Parameter default value is blank when deployed to server
On local machine in visual studio 2005, setting Default Value to 1 (for example) in the parameter properties box correctly defaults the value on the Preview tab.

However, when deployed to IIS, the report on the server defaults to null.


Instead of typing 1 as the default value, click the fx expression button, and enter =1

The equal sign will allow the report to work correctly on the server.

Created By: amos 6/2/2014 5:33:08 PM

 > Guest 9/30/2016 1:31:27 PM
I Have faced the same issue and changed the parameter type to Text and updated the default value using the expression -----> ="true"