Thats a great solution but i have a problem, my parameters have multiselect option setting local parameters is giving me error, can any one help... please

Query -

DECLARE @LOCAL_VAR_ORGN VARCHAR(MAX)

SET @LOCAL_VAR_ORGN in (@Organisation)

DECLARE @LOCAL_VAR_BL VARCHAR(MAX)

SET @LOCAL_VAR_BL in @BusinessLine

DECLARE @LOCAL_VAR_SE VARCHAR(MAX)

SET @LOCAL_VAR_SE in @SalesExecutive

selectvd.Month,

vd.month_No,

vd.Year,

vd.Week,

vd.Date,

vd.Organisation,

vd.[Business Line],

vd.[Sales Executive],

count(distinct vd.CSTMR_KEY)[Total no of Lines],

(

case when SUM(vd.[Total Amount Due])>0

then COUNT(distinct vd.CSTMR_KEY) else 0 end

)[Total No Of Unpaid Lines],

SUM(vd.[Total Amount Due])[Total Amount Due]

from IV_DBT_RPT_FR_ORGNSTN VD

where (vd.Date>=@FromDate and vd.Date<=@ToDate)

AND VD.Organisation IN (@LOCAL_VAR_ORGN)

AND VD.[Business Line] IN (@LOCAL_VAR_BL)

AND VD.[Sales Executive] IN (@LOCAL_VAR_SE)

group by vd.AR_BHVR_KEY,

vd.[Business Line],

vd.C,

vd.CNTRCT_DD,

vd.CSTMR_KEY,

VD.Year,

vd.Date,

vd.month_No,

vd.Month,

VD.Week,

vd.Organisation,

vd.[Sales Executive]

--order by VD.Date