Default Parameters not Displaying

• doug 37293

  Old Hand

  Points: 362

  More actions

  July 14, 2011 at 3:54 pm

  #253769

  Using SSRS 2008

  Has anyone else seen this problem?

  I have created a parameter @pOrg (Organization) and populated the Values with:

  Label: Value:

  ABC 1

  DEF 2

  GHI 3

  MNO 5

  and set the Default Values to:

  1

  2

  3

  5

  In other words All Selected at startup.

  This worked fine.

  I later came back and added:

  Label: Value:

  JKL 4

  and added 4 to the Default Values

  Here's what happens. In the Preview Mode, all is fine. All Labels are selected by default. However, when Deployed out to the server, all options are available, but JKL remains unchecked as a default.

  I have checked the underlying code and all looks good. Has anyone else seen this problem?

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  July 15, 2011 at 12:47 am

  #1353218

  Please do not crosspost. It wastes peoples time and shatters replies.

  Original thread can be found here:

  http://qa.sqlservercentral.com/Forums/Topic1142130-1633-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP