Hi all,

I have a report with an action to a different report (Go to report) function.

I was 2 parameters, the weak of the year (single value) and Product (multiple values).

For the product I use a lookup function

=Split(Join(Lookup(Fields!Product.Value, Fields!Product.Value, Fields!ParameterValue.Value, "ProductProduct"),","),",")

I also tried MultiLookup, LookupSet but it's not working. The report works, it goes to the other report but it says "Missing values for parameter Product". In other words, he doesn't take the selected set of values.

Any idea?

Hi Yvanlathem,

According to your description, you want to lookup a column as the available values of the parameter, right?

In this scenario, when you use the split() function, it will return an array. In Reporting Service, even the multi-value parameter is working as an array object, but when specifying available values for a parameter, we still need to use metadata (fields). For your requirement, I suggest you create a dataset which join the two dataset records together based on Product column. Then you can make the parameter get values from this dataset: 

Select parametervalue from A join B on A.product = B.product

If you have any question, please feel free to ask. 

Regards,
Shrek Li