Multivalue parameter report error: The @col1 parameter is missing a value. The main @multivalue variable contain multiple variables hidden.

• RZebra

  SSC Veteran

  Points: 277

  More actions

  November 26, 2011 at 2:01 am

  #263536

  Hi I would appreciate if someone could help me out on this one, this really is starting to get more frustrating that I can take.

  So, I have a multivalue report with one main parameter @MultiVal that parces a list of values. The report include other parameters that is hidden beneath the main parameter @µulitVal, I have @col1, @col2 etc. Now when I trying to execute this thing in reporting services I keep getting this uggly error, saying that @col1 parameter is missing??? That is first hidden parameter @col. Anyone that could give me some advice here, what Im I doing wrong?

  Dataset 1 has the mainsproc in it which is just a selection of columns.

  Dataset 2 generates a list of values in a dropdown which coming from the same table and the hidden variables values in the insert sproc.

  select distinct col1+''+col2+''+col3+''+col+''+col5

  from table

  Dataset 3 is the insert sproc. @MultiVal contain all the other parameters which is hidden values.

  declare @MultiVal nvarchar(max)

  EXEC insert_sproc @MultiVal

  ,@col1,@col2,@col3,@col4,@col5

  Thanks so much for the help, it is much appreciated. /Rz

• nheller

  SSC Enthusiast

  Points: 126

  More actions

  December 21, 2011 at 2:55 pm

  #1424479

  you could also pass the multivalue parameter to a stored procedure as a varchar(max) then use a table valued function to split the multivalue.