Passing a custom filter to report?

Tiwaz · 2016-11-21

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 · 2016-11-21

Yes, but then you can do a...

SETFILTER(MyField,MyFilterExpression)

...in the OnPreDataItem() trigger

mohana_cse06 · 2016-11-21

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

Tiwaz · 2016-11-21

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 · 2016-11-21

Yes, but then you can do a...

SETFILTER(MyField,MyFilterExpression)

...in the OnPreDataItem() trigger

Tiwaz · 2016-11-23

Thank you @Kishorm. That totally slipped my mind

Passing a custom filter to report?

Best Answer

Answers

Categories