Int data type used in multi value parameter RRS feed

  • Question

  • Sorry for my inexperience with SSRS in advance.  I need to setup a multivalue parameter in the report builderfor an integer data type.  My stored procedure is like

    @id int

    Select * from dbo.test where ID in (@id)

    In SSRS I go into the parameter properties and I set the parameter to multivalue and I set the data type to int but when I run the preview I get this error.

    "Error converting data type nvarchar to int."

    I am assuming it is having trouble converting the comma to an integer data type so how do I get around this error?

    Any help on this matter would be much appreciated.


    Sunday, July 8, 2012 7:25 PM