Handing Big Arrays in Selection Expert 2

[aamkumar]

I have a Zip code list which I need to exclude from the data retrieved for my report and the list of zip codes is around 1800 and the other big problem is these zip codes are not present in database tables. I tried putting all these zipcodes in one selection expert constraint as

not {command.zip_code} in (["12343","34564",.....,"56756"])
but I am getting an error in selection expert that the array is too big.

So I tried breaking the zip codes into multiple arrays of 300 each to a total of around 6 arrays (300*6=1800) as

(
(not {command.zip_code} in (["12343","45434",.....,"54322"]))

or 
(not {command.zip_code} in (["13433","34564",.....,"56756"]))

or

(not {command.zip_code} in (["98943","34953",.....,"55356"]))
)
-
-
-
-
-

Iam not getting any errors now but It is am not getting filtered results.

Please give your suggestions

 

[synapsevampire]

In your second attempt, you used ORs, should have been ANDs.

Using a table is the best idea.

At any rate, don't expect qualified answers when you won't even bother to post your software version...


-k

 

[Madawc]

If you put your zip codes into an Excel spreadsheet, you should be able to get your Crystal report to read it. Use SEARCH to get details from older threads.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[aamkumar]

OPPS...I m sorry about that synapsevampire ..
I am using CR XI.
I will try with "and