|
-
Dec 14th, 2007, 01:08 AM
#1
Thread Starter
Hyperactive Member
[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.
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.
-
Dec 14th, 2007, 10:46 AM
#2
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']
-
Dec 14th, 2007, 07:14 PM
#3
Thread Starter
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|