title: Error Converting Datatype nvarchar to int in SSRS for multivalued Parameter
body: <p>I have a parameter Client in the report which takes Multivalues.
  When i run the value for one client, it's working fine, but when i include more than 1 client it's giving the error like:</p>
  
  <blockquote>
    <p>"Error Converting Datatype nvarchar to int in SSRS for multivalued Parameter"</p>
  </blockquote>
  
  <p>Here is the stored procedure which is giving the data based on the client parameter</p>
  
  <pre><code>Create PROCEDURE SampleLead 
  @InvClientId int    
  AS
  begin
  
   SELECT [SourceSystemId]
    ,[SourceLeadId]
    ,[FirstName]
    ,[LastName]
    ,[Title]
    ,[TitleType]
    ,[Role]
    ,[CustomerName]
    ,[Address1]
    ,[Address2]
    ,[City]
    ,[State]
    ,[ZipCode]
    ,[Country]
    ,[InvClientId]
    ,[Campaign]
    ,[Email]
    ,[Phone]
    ,[InvUserId]
    ,[RevenueRangeId]
    ,[EmployeeRangeId]
    ,[Industry]
    ,[SICCode]
    ,[NAICSCode]
    ,[DUNSNo]
    ,[CreatedDate]
    ,[ModifiedDate]
    ,[LeadStatus]
   FROM [CRMIntegration].[dbo].[Lead]
   Where InvClientid in (@invClientID)
  
  END
  GO
  </code></pre>
  
  <p>invClientId is declared as int in the source table
  And SSRS parameter i have set the datatype as int.</p>
  
  <p>Can you help me why it is not working for multiple values but working when i select single value?</p>