Selection Formula Help

[TEM3]

Crystal Reports 8.5/Oracle Tables:

I currently have a selection formula that looks like this-

{LABCASE.Department Code} = uppercase({?Department}) and
{LABITEM.Custody Of} = "ESTP" and
{LABITEM.Location} in ["VS127", "VS073", "VCR1", "VCF1", "VAULT", "TPBS02", "TPBS01"] and
{LABREPT.Date Completed} < currentdate

BUT, I need to filter for almost 100 more {LABITEM.Location}'s out of 400 to 500.

Do I have any options other then to type them all in separately? Is there a wildcard (?/*) way I can take care of some of them??

 

[kskid]

For wildcard, yuou can use the following

(
{LABITEM.Location} startswith "V" or
{LABITEM.Location} like "TPS*"
)

 

[lauriesamh]

If this is going to be a report you run many times. You could also pull all the {LABITEM.Location} data into an Access database or Excel spreadsheet and either eliminate the locations you won't need or create a new field that you can group the ones you need to pull. Then link the database/spreadsheet into your report and modify your selection criteria.

 

[TEM3]

Excellent idea lauriesamh! I have not tried it, but from your answer I assume I can mix databases (Oracle and Access or whatever, in this case)??

I will give it a try.

 

[TEM3]

OK, dummy question time:

I have selected the records from the Oracle table I need to filter/select on and saved them as an Excel file. How can I use this new (Excel) table with the Select Expert??