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