Select Distinct Year

  • 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?

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply