How to enter a filter expression Not in?

6 posts, 0 answers
  1. Shoji Kaburagi
    Shoji Kaburagi avatar
    27 posts
    Member since:
    Jul 2012

    Posted 05 Feb 2014 Link to this post

    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!
  2. Stef
    Admin
    Stef avatar
    3050 posts

    Posted 10 Feb 2014 Link to this post

    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.

  3. DevCraft banner
  4. Shoji Kaburagi
    Shoji Kaburagi avatar
    27 posts
    Member since:
    Jul 2012

    Posted 10 Feb 2014 in reply to Shoji Kaburagi Link to this post

    It works. Thanks!
  5. Shoji Kaburagi
    Shoji Kaburagi avatar
    27 posts
    Member since:
    Jul 2012

    Posted 18 Feb 2014 Link to this post

    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?
  6. Stef
    Admin
    Stef avatar
    3050 posts

    Posted 20 Feb 2014 Link to this post

    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.

  7. Shoji Kaburagi
    Shoji Kaburagi avatar
    27 posts
    Member since:
    Jul 2012

    Posted 20 Feb 2014 in reply to Stef Link to this post

    Got it

    Thanks!
Back to Top
DevCraft banner