title: How to filter a column using multi value parameter list in SSRS
body: <p>I am new to SSRS. What I thought should be very simple took me 1 day and I am not able to fix it. All I need is the following</p>
  
  <pre><code>Select * from table1 where len(username) &lt;= 6
  Select * from table1 where len(username) &gt;= 7
  </code></pre>
  
  <p>I want to display a drop menu with two options Short Username and Long Username.
  When a username click the short username the first query result is showed and when the user click Long username the second query result is showed.</p>
  
  <p>What I did so far is I added a parameter list with two values i.e Short parameter list = 6 and Long parameter list = 7. I then added two filters. In the first the expression= len(NameColumn.value)  operator= &lt;= value = @parameter. In the second the expression= len(NameColumn.value) operator= >= value = @parameter. Can you please what can I do to achieve it.</p>