This is a migrated thread and some comments may be shown as answers.

How to enter a filter expression Not in?

5 Answers 417 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Shoji Kaburagi
Top achievements
Rank 1
Shoji Kaburagi asked on 05 Feb 2014, 10:39 PM
Hello,

I am trying to create a report that filters anything BUT the list of values. I can create one that includes list of values as this:

=Fields.USER_LOCATION In =Split("|", "BH-0019|BH-0030|BH-0019")

But how can not create a filter that filters anything BUT the list of values?

Any help is appreciated.

Thanks!

5 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 10 Feb 2014, 03:11 PM
Hi Shoji,

Test to create an expression evaluating to a Boolean e.g.:
Expression: =Fields.USER_LOCATION Not In Split("|", "BH-0019|BH-0030|BH-0019")
Operator: Equal(=)
Value: =True

For more details check our Operators help article.

I hope this helps you.

Regards,
Stef
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Shoji Kaburagi
Top achievements
Rank 1
answered on 10 Feb 2014, 10:26 PM
It works. Thanks!
0
Shoji Kaburagi
Top achievements
Rank 1
answered on 18 Feb 2014, 07:59 PM
Sorry to bother you again, but how do I enter a string value if one of values contains a double-quotes ex BH-135|AB"C|BH-035?
0
Stef
Telerik team
answered on 20 Feb 2014, 05:25 PM
Hi Shoji,

Please refer to the Note and further details in the Expressions Constants help article.

Regards,
Stef
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Shoji Kaburagi
Top achievements
Rank 1
answered on 20 Feb 2014, 06:27 PM
Got it

Thanks!
Tags
Report Designer (standalone)
Asked by
Shoji Kaburagi
Top achievements
Rank 1
Answers by
Stef
Telerik team
Shoji Kaburagi
Top achievements
Rank 1
Share this question
or