Hi

I am using ssrs 2016 version. In my report, we have a dropdown list called visit type which is having multi selection option. When user choose select all option, it returns the value as '1,2,3'. 

I am getting the following error in stored procedure.

Conversion failed when converting the nvarchar value '1,2,3' to data type int

CREATE PROCEDURE [dbo].[VisitsReport]
(
    @VisitID NVARCHAR(500)
)
AS
BEGIN
	SELECT * FROM VisitTypeReportDataSet WHERE FK_VisitTypeID IN (@VisitID) ORDER BY VisitDate
END

Thanks

Babu