SQL 2005 Reporting Services - Can't set default value for multivalue parameter RRS feed

  • Question

  • Help!  I am rather new to SQL 2005 Reporting Services and have tried everything to solve this problem.  I am setting up a multivalue parameter and want to enter a default value in the Report Parameters.  No matter what I put under Default Value -> Non-queried it still displays blank.  If I use the multivalue parameter then I get a list of values: value1, value2, value3, etc.  which triggers a select all for the inital report view.  I either want to display the first value as the default or force the user to "Select a Value".



    Monday, July 30, 2007 5:26 PM

All replies

  • I found the answer.  The Default value must match exactly a value in the query results list.  This includes upper/lower case. 

    Monday, August 20, 2007 6:18 PM