Multivalue parameters and OpenAccess

[Joakim Winkler]

Hi!

Is it possible to use multivalue parameters together with an openaccessdatasource?
I have problems when using them in filter expressions.

/Joakim

[Steve]

Hello Joakim,

Can you share what is the exact problem you've encountered? Do you get any errors? Note that multivalue report parameters return System.Object[], so you should respect that when creating expressions with multivalue report parameters. You can see how multivalue report parameters are used in Filters in our Product Line Sales demo report, where we filter the Table items. Here is a sample expression:

Expression	Operator	Value
=Fields.ProductSubcategory	In	=Parameters.ProductSubcategory.Value

where =Parameters.ProductSubcategory.Value is a multivalue parameter.

Kind regards,
Steve
the Telerik team

[Joakim Winkler]

I think I solved it. When I changed from single to multivalue I only changed from = to IN in the filter expression. Now I tested to also remove the .Value on the parameter side and it worked.
Like: =Fields.fieldid IN =parameters.parametername