title: How to select all parameter values in SSRS?
body: <p>I have a parameters @Year and @Month in my report, where month has assigned values like January(label): 1(values), February: 2, ...
  My datased is feeded by stored procedure which has a filter
  <a href="https://i.stack.imgur.com/6Hppa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Hppa.png" alt="enter image description here"></a></p>
  
  <pre><code>WHERE (cal.CalendarYear = @Year) AND (cal.MonthId = @Month)
  </code></pre>
  
  <p>When I check 'Allow multiply values' in parameter settings, it returns an error</p>
  
  <blockquote>
    <p>Error converting data type nvarchar into int.</p>
  </blockquote>
  
  <p>How can I select all values (by default)?</p>