Also, can a Parameter be set in a command that will allow for multiple entries?

 

Yes, you can use a multi-select parameter in a command.  Then syntax looks something like this:

 

myTable.MyField in {?MyMultiParam}

 

-Dell

How does the MUltiParam look in the Crystal Command with the talbe and field above?

 

Where ABC.Client in {?MultiParam}

 

-Dell

Here is my COMMAND. Highlighted in RED is the parameter I would like to be a paramter that allows multiple entries. Can you you help me get this right.

thx

select distinct

(SUBSTRING(right('000000000' + cast(a3.Employee_SSN as varchar),9), 1, 3) + '-' +

SUBSTRING(right('000000000' + cast(a3.Employee_SSN as varchar ),9), 4, 2) + '-' +

SUBSTRING(right('000000000' + cast(a3.Employee_SSN as varchar ),9), 6, 4)

) as ssn,

--a1.Client_ID,

--a1.employee_id,

a5.Plan_Desc,

a4.Plan_Type,

a1.Coverage_Start_Date,

a1.Coverage_End_Date,

a2.Employee_First_Name,

a2.Employee_MI,

a2.Employee_Last_Name,

a2.Employee_Address1,

a2.Employee_Address2,

a2.Employee_City,

a2.Employee_State,

a2.Employee_Zip_Code,

a4.*

from dbo.Employee_Benefit (NOLOCK) a1,

dbo.Employee(NOLOCK) a2,

dbo.dt_Employee_Client(NOLOCK)      a3,

dbo.Employee_Benefit_Detail(NOLOCK) a4,

dbo.Benefit_Plans(NOLOCK) a5,

dbo.Benefit_Plans_Plan_Type(NOLOCK) a6

where a1.Employee_ID = a2.employee_id

and a1.Employee_ID = a3.employee_id

and a1.Client_ID = a3.client_id

and a4.Employee_ID=a1.Employee_ID

and a4.Client_ID=a1.Client_ID

and a4.Plan_ID=a1.Plan_ID

and a5.Plan_ID=a1.Plan_ID

and a2.DWH_DatabaseID=a5.DWH_DatabaseID

and a2.DWH_DatabaseID = '10000000'

and a1.Client_ID = {?ClientID}

and a1.Coverage_Start_Date = '2012-09-01'

and a1.status_code='A'

and a4.Plan_Date_ID=(select MAX(plan_date_id) as plan_date_id  from

dbo.Employee_Benefit_Detail(NOLOCK) det where

det.Client_ID=a1.client_id and

det.Employee_ID=a1.employee_id and

det.Plan_ID=a1.plan_id group by

det.plan_id,det.client_id, det.employee_id )

--and a1.Employee_ID='F64287'

order by  a2.Employee_Last_Name

 

-Dell