Results 1 to 3 of 3

Thread: [RESOLVED] The ) is missing. How to use IN in CR 8.5

  1. #1

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Resolved [RESOLVED] The ) is missing. How to use IN in CR 8.5

    I would like to run the code below in Record Selection Formula of CR 8.5
    However, I met a problem that missing of ). For my passed experience i wondered how to handle to use IN in CR 8.5.Thus, what can I do at the passed is create another table to store record for show and link to main table. This time I'm having a lot of IN statement. Thus, It was inflexible if create a lot of table for showing record.

    Any experts here can guide me the better method to overcome my problem.



    SQL Code:
    1. {Machine_Desc.Mac_Name} = 'ACONT'
    2. AND {Machine_Desc.Mac_Type} IN('Assembly Machine','Auto Foaming Machine','BLOCK CUTTER MACHINE')
    3. AND {Machine_Desc.Loc} IN('BLOCK A','BLOCK B')
    4. AND {Machine_Desc.Status} IN('ABSOLUTE CRITICAL')
    5. AND {Machine_Desc.Vendor} IN('Chang Yee','Chia Berhad ','Fides (Italy)')
    6. AND {Machine_Desc.Mac_Year} >= '1968' AND {Machine_Desc.Mac_Year} <= '2000'


    Thanks for a million.
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: The ) is missing. How to use IN in CR 8.5

    Crystal syntax is square brackets

    AND {Machine_Desc.Loc} IN ['BLOCK A','BLOCK B']

  3. #3

    Thread Starter
    Hyperactive Member nUflAvOrS's Avatar
    Join Date
    Jul 2007
    Location
    Malaysia/ Currently at Singapore
    Posts
    372

    Re: The ) is missing. How to use IN in CR 8.5

    Thanks brucevde .....
    you solved my problem :=)
    Where there is no hope, there can be no endeavor.

    There are two ways of rising in the world, either by your own industry or by the folly of others.

Posting Permissions

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



Click Here to Expand Forum to Full Width