Results 1 to 2 of 2

Thread: Crystal Reports if (blah) IN [ ] problem

  1. Aug 19th, 2010, 10:30 AM #1
    greenheck
    greenheck is offline

    Thread Starter
    Junior Member greenheck's Avatar
    Join Date
    Jan 2010
    Location
    Wisconsin
    Posts
    24

    Question Crystal Reports if (blah) IN [ ] problem

    Hi,

    so I know I can do something like
    Code:
    {Contract Units.UNIT #} in ["7610","7611","7612","7613","7614","7615","7616","7617","7853","7858","7859","7860"]
    but how can I do

    Code:
    {Contract Units.UNIT #} NOT in ["7610","7611","7612","7613","7614","7615","7616","7617","7853","7858","7859","7860"]
    It seems that CR is not accepting the NOT before the IN ... Im using Seagate CR 6 (the one that comes with VB6 package!)


    Thanks a lot
    Reply With Quote Reply With Quote
  2. Aug 19th, 2010, 01:32 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Crystal Reports if (blah) IN [ ] problem

    Use

    Code:
    NOT ({Contract Units.UNIT #} in ["7610","7611","7612","7613","7614","7615","7616","7617","7853","7858","7859","7860"])
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width