How to filter on multiple values given as a single param in a report ?
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.
Accepted Solution
Updated: 10 Aug 2022 9:16 EDT
Rulesware
PE
@ShezadM8You need to escape the quotes in the parameter. For example
Param.values = "\"value1\", \"value2\", \"value3\""
Oligos
FR
@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 <value1> <value2> <value3>
Updated: 10 Aug 2022 12:24 EDT
Oligos
FR
@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