title: How do I set a Default Value of "Select All" in SSRS?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2508910/select-all-as-default-value-for-multivalue-parameter">Select All as default value for Multivalue parameter</a>  </p>
  </blockquote>
  
  
  
  <p>I have a drop-down parameter in SSRS that gets populated via the following query:</p>
  
  <pre><code>select ID, name from accounts where LK_RecordStatusID = 1 order by Name asc
  </code></pre>
  
  <p>I need it to be a multi-value parameter. In SSRS, I can do this. However, I can't also let it be a null value . However, I'd like it to have a default-value of "Null", that corresponds to the "Select All" choice.</p>
  
  <p>I looked online and I see something about using -1 as an alternative to null? It seems I can't specify a null value . Any tips appreciated, thanks </p>
  
  <p><img src="https://i.stack.imgur.com/344MY.png" alt="enter image description here"></p>