Passing a custom filter to report?

Tiwaz

Hello everyone
I have a field FilterValue on my RequestPage where I enter multiple values for filter and it currently looks like this:
Value1 | Value 2 | Value3 etc.
Then I add that field to my Dataset Designer and pass it's value in group filter in Object designer where I placed Field1 = FilterValue
But when I enter multiple value ex:Value1 | Value 2 | Value3 it doesn't display anything. When I enter just one: Value1 for example it works.
I believe it's because RDLC designer does not recognize | or & as conditions.
What can I enter as a substitute?
Thanks

Kishorm

Yes, but then you can do a...

SETFILTER(MyField,MyFilterExpression)

...in the OnPreDataItem() trigger

mohana_cse06

Isn't it possible to filter on Dataitem instead of in rdlc?

Tiwaz

I need a client to choose values to filter on, via LookUp page which is called from RequestPage and then multiple values are primarily displayed there.

Kishorm

Yes, but then you can do a...

SETFILTER(MyField,MyFilterExpression)

...in the OnPreDataItem() trigger

Tiwaz

Thank you @Kishorm. That totally slipped my mind