[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:
{Machine_Desc.Mac_Name} = 'ACONT'
AND {Machine_Desc.Mac_Type} IN('Assembly Machine','Auto Foaming Machine','BLOCK CUTTER MACHINE')
AND {Machine_Desc.Loc} IN('BLOCK A','BLOCK B')
AND {Machine_Desc.Status} IN('ABSOLUTE CRITICAL')
AND {Machine_Desc.Vendor} IN('Chang Yee','Chia Berhad ','Fides (Italy)')
AND {Machine_Desc.Mac_Year} >= '1968' AND {Machine_Desc.Mac_Year} <= '2000'
Thanks for a million. :)
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']
Re: The ) is missing. How to use IN in CR 8.5
Thanks brucevde .....
you solved my problem :=)