Skip to Content
0
Former Member
Jan 03, 2008 at 10:06 PM

Crystal report SQL Command and using IN

18 Views

Post Author: geozuh

CA Forum: Crystal Reports

Does any one know how to get a multiple value prompts to work in Crystal report SQL Commands? I have an extremely large database and do not want to pull back all the records to the report. I know I can do the filtering in the report, but due to the size of the database, I am restricked from doing do.

I would like to set the State as a multiple value parameter/prompt to be used in the SQL Command.

Ex.

Select CustID, FirstName, LastName

from Customer

where State in ('WI', 'IL', 'MN') --this would be turned into a parameter