Calling MS Sql Stored Procedure from jasper studio

I tried followed syntax in jasper studio (Note Parameter Class is 'java.lang.String')

SP_Name $P(Parameter)

and also tried

SP_Name $P!(Parameter)

and I have a stored procedure like by following

ALTER PROCEDURE [dbo].[SP_Name ]
    @Parameter VARCHAR(50)
 
    AS
    BEGIN
 
    SELECT * FROM tablename WHERE id IN (@Parameter)
 
    END

while trying the above scenario i got the following error in jasper studio

> procedure have too many arguments

or

> Conversion failed when converting the varchar value '1,2' to data type
> int.

please provide a proper solution for this..
Thanks in advance...