Select Distinct Year

• SilhouetteBS

  SSCommitted

  Points: 1597

  More actions

  February 1, 2016 at 2:06 pm

  #399659

  I have a query for a report in SSRS that is bringing back various columns for the report I am working on. One of the columns is 'year'. In my report I would like to populate a parameter with all of the distinct year values from a table. Do I need to create a new dataset and use SELECT DISTINCT year in order to get the distinct years, or can I use the already existing query to get them?

• pietlinden

  SSC Guru

  Points: 63556

  More actions

  February 1, 2016 at 2:12 pm

  #1855826

  You have to create a new dataset (option 1).