title: SSRS filtering using Parameters and Dataset values
body: <p>I have a report that when run produces a list of numbers based upon a parameter which signifies year. For instance I choose 2019 on the parameter, numbers 1 - 10 come out in rows with additional columns based on that. What I want to do it select 2018 and have it only show 1-7 and 10, thus removing 8 and 9 but when i select say 2019 it shows all 10 rows again.</p>
  
  <p>Any ideas how I can do this under the filter option in group properties? The group is on the field that has the numbers in, several rows per number initially show, thus grouping on the numbers creates one row per number.</p>
  
  <p>Parameter 2019:</p>
  
  <p>E1001  1   Tom<br>
  E1002  2   Rob<br>
  E1003  3   Ben     </p>
  
  <p>Parameter 2018:</p>
  
  <p>E1001  1   Tom<br>
  E1003  3   Ben        </p>