title: Multiple value in a parameter
body: <p>I have a query that has 3 parameters Start Date, End Date and Location.  The query is stored in SQL Stored Procedure, and I am calling the Stored Procedure in SSRS (EXEC dbo.ups_Calls @Start, @End, @Location) (see below code).  </p>
  
  <pre><code>CREATE PROC dbo.Calls
      @Start DATETIME=NULL,
      @End DATETIME=NULL,
      @Location VARCHAR(25)=NULL
  AS
  BEGIN
  
  SELECT CALLDATE, LOCATION
  FROM CALL_DETAILS WITH (NOLOCK)
  WHERE CALLDATE BETWEEN @START AND @END
  AND LOCATION IN (@Location)
  
  END
  GO
  </code></pre>
  
  <p>ISSUE: Calling the stored procedure from SSR query box (see below) is only pulling one site from the SSRS location parameter even though I selected more than one location, BUT if I embed the query itself in SSRS then I am able to pull multiple sites.</p>
  
  <p><a href="https://i.stack.imgur.com/bxwGM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bxwGM.jpg" alt="enter image description here"></a></p>