i executed the the below function

CREATE FUNCTION SPLIT(@VAL VARCHAR(MAX))

RETURNS @T1 TABLE(COL1 VARCHAR(MAX))

AS

BEGIN

WHILE CHARINDEX(',',@VAL)>0

BEGIN

INSERT INTO @T1 VALUES(SUBSTRING(@VAL,1,(CHARINDEX(',',@VAL))-1))

SET @val=SUBSTRING(@VAL,(CHARINDEX(',',@VAL))+1,LEN(@VAL))

END

INSERT INTO @T1 VALUES(@VAL)

RETURN

END

Below mentioned is my SP

--exec Fms_Subject 'M001,L001,D004,B001'

Alter Proc...

Thnks divya..its working

i have only 1 multi value parameter "P"

thank you,

in SSRS 2005 there is option to separate thousands(1,234,567,890).but i need in lakhs separator (1,23,45,67,890)...

do you have any idea how to do this.. if u do ..please explain it...

=sum(Fields!Total_Amount.Value)

this is the expression i am using to sum the particular value.can anyone tell me how to use the below condition for the above expression...

=Format(Fields!Price.Value, "#,##0.00")