title: Parameter default to all every time
body: <p>I created a drop down menu by getting values from a query. I created so that every time a the user can select one department name or all option. Also, i havent added any dafault values.</p>
  
  <pre><code>select distinct departmentid, name from department
  union
  select Null, 'ALL'
  order by department  
  </code></pre>
  
  <p>Now when I tried to preview the report. It by default selects "ALL" option and runs the report. How do I make it let me choose the option. I am fairly new to SSRS and I am not sure what went wrong.</p>
  
  <p>edited: I reason I use  NUll is because department id is uniqueidentifer and I wouldn't let me use int values. Also, when I created the parameter i set the parameter to allow null values to let me see if the 'ALL' option in the parameter. Now, when I take out the allow null values, it doesn't default.</p>