How to populate list of years as a multi-valued parameter?

• sarayucm

  SSC Veteran

  Points: 220

  More actions

  August 16, 2012 at 4:23 am

  #266017

  Hi,

  I need to have a Year parameter on my report which is a drop down with a list of years default to current year. How to populate list of years in this parameter? Please note that I'm not using SQL Server as a datasource. I'm using fetchxml quieries with CRM online. Kindly help me.

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  August 16, 2012 at 5:11 am

  #1526480

  How many years are needed?

  If it's just a few, you can add a list of values in the parameter properties screen by selecting 'Specify Values' on the Available Values tab.

  You'll have to maintain the list yourself though.

  On the Default tab, use =Year(today) or something like that.