title: How do I allow a drop-down list parameter in SSRS to have a default value of "-- All -- "?
body: <p>I have a drop-down list that gets populated based on a stored-procedure - that parts works fine.</p>
  
  <p><img src="https://i.stack.imgur.com/0HuKF.png" alt="enter image description here"></p>
  
  <p>It gets populated dynamically, based on whatever the "Survey ID" is</p>
  
  <p>But I don't want it to say <code>&lt;Select a Value&gt;</code> , rather it should say <code>" -- All -- "</code> , because that is how the report works.</p>
  
  <p>So far I tried to create a dummy-dataset that returns <code>Null</code> and the label of "all" but it didn't work. Maybe I did that wrong? I used this:</p>
  
  <pre><code>select distinct  Name, ID  from LK_TargetTypes
  where Name like '%pizza'
  union select '-- All --', null ;
  </code></pre>
  
  <p>So <code>LK_TargetTypes</code> is some irrelevant table. I want to merge that with the other DDL-values.</p>
  
  <p>Here's another picture:</p>
  
  <p><img src="https://i.stack.imgur.com/n1tI6.png" alt="enter image description here"></p>
  
  <p>Any tips appreciated thanks.</p>