How to filter on multiple values given as a single param in a report ?

General
,
1

Hi,

I’m wondering if what i want to do is achievable or not using a Report Definition.

In fact, on a report, when we Filter on a String property, we can choose multiple values by clicking on “Select Values” button. They appear as a String “Value1”,“Value2”,“Value3” after selection.

The report runs perfectly that way with the operator “Equals” in this filter.

I didn’t achieve to give that same list in a single parameter of my report to make this list dynamic. If i try, it is getting considered as a single concateneted text and didn’t return any result.

Is there any way to do that with a Report definition, or is it impossible and my design approach should be different ?

Thank you.

2

@ShezadM8 You need to escape the quotes in the parameter. For example

Param.values = "\"value1\", \"value2\", \"value3\""
3

@Deivit Thanks for your solution but it have been tried without any success.

In fact, it’s still considered as a single parameter in the SQL

<"value1", "value2", "value3">

instead of

4

@Deivit After few more tests, it depend from where we give thoses escaped values.

It seems giving the values inside of a Data Page or from a Section didn’t work but giving it through a Data Transform work !

Thanks for your help