0

I have multi Valued Parameter which have list of values in the Drop down .

I am trying to apply filter on the data set.My requirement is when i choose a value from Drop down,it should be filtered on that value.

I am using the below value in my DATA SET Filters

 =join(Parameters!TierStatus.Value,",")

But i am getting an Error like

"Failed to evaluate the FilterValues of the Dataset"

How can write a filter expression based on the multi valued parameter

SqlLearner
  • 763
  • 8
  • 23
  • 37

1 Answers1

1

If you are using "IN" as the operator, you should be able to simply put your parameter in the Value field (do not use the JOIN function).

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c02370b5-aeda-47ec-a3a8-43b2ec1e6c26/reporting-services-multi-value-parameter

Tab Alleman
  • 31,483
  • 7
  • 36
  • 52
  • I tried with Simply putting the parameter without join , But it is not taking the multiple values – SqlLearner Aug 11 '14 at 19:31
  • You need to show more of what you are doing and what is happening then, because according to the article I referenced, that is the solution that should work. – Tab Alleman Aug 11 '14 at 19:57