Hi everybody,

using Crystal Reports X I am wondering if the following is possible and how to do it:

I have a file containing multiple patient-id´s, now I want to use those ID´s as a filter in my report (so I dont have to input them manually, since there are a great number of ID´s).
I need the choise of filtering so that only data with the same ID´s as those in my textfile are returned in the report.

Any ideas on how to solve this?

Ok, and thanks for the reply. But I´m somewhat new in using crystal as well as in more advanced SQL.

To be more specific, this is similar to the function I am looking for:

SELECT c1, c2, c3
FROM table1
WHERE table1.c1 = file.c1

Here the file is the xls file containing my list of patientnames that I want to extract from my database.
The actual SQL command if done manually would look something like this:

SELECT c1, c2, c3
FROM table1
WHERE table1.c1 = value1 or value2 or value3...

But how to do this in crystal in an easier way? I managed after your reply to add my xls file as input source, but I have no clue to how to use all the data it contains for filtering (since I need to filter out data for all the entries in the file at once).