title: SSRS parameter one label but multiple values
body: <p>I have a query that has classify codes: if 'PC' it returns 'Compatible, if Null then it returns Unclassified, if everything else returns 'Not-Compatible'.  The alias column is "Classification".  </p>
  
  <pre><code>&gt; SELECT   CASE WHEN class.code IS NULL THEN 'Unclassified'
  &gt; WHEN class.Code = 'PC' THEN 'Compatible' ELSE 'Not-Compatible'
  &gt; END Classification,  FROM classification class
  </code></pre>
  
  <p>Now I want to set this Classification as a parameter in my SSRS report.  </p>
  
  <pre><code>WHERE class.Code LIKE @Classification
  </code></pre>
  
  <p>Then in my @Classification parameter<a href="https://i.stack.imgur.com/xnLAZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xnLAZ.jpg" alt="Parameter Set up"></a></p>
  
  <p>So, in my report, user is prompted choose a classification, how do I get user to choose "Everything Else" that returns "Unclassified"?  I can't use the alias column name "Classification" to get value.  If there a way to set multiple values into the label "Unclassified"? </p>