Report Builder Multivalued Parameter Selection

• mdnordby

  Grasshopper

  Points: 13

  More actions

  June 24, 2011 at 11:50 am

  #238488

  I am trying to use the values in a Multi Value Parameter to control the number of charts to display. But I am running into a problem when I try to select a nonexistent value. The number of charts will vary depending on what group is select so the number of parameters will change with each selection.

  Example

  =Parameters!ParameterName.Label(1) returns the first value

  =Parameters!ParameterName.Label(2) returns the second value and so on but if I have only 2 parameters in the array and I try

  =Parameters!ParameterName.Label(3) I get “#Error” and cannot find a way to catch this error.

  Any Ideas?

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  June 28, 2011 at 1:33 pm

  #1345453

  Make your multi value parameter sensitive to the number of charts that can be displayed so you can only select an appropriate number.