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.

Solution:

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


 Comments:
 > 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"