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