1

I have a report query that has "Year" as a parameter. If user selects 2016 in the parameter, the query produces 2016 values in a column named "SelectedYear", and 2015 values in a column called "PreviousYear".

I want the legend for the bar chart to then be 2016 and 2015 respectively. If I go Series Properties - Legend - Expression and I do =Parameters!Year.Value, THIS one gets 2016.

If I do =Parameters!Year.Value - 1 for the other one, the legend name remains the column name instead of 2015.

0m3r
  • 12,286
  • 15
  • 35
  • 71
opperman.eric
  • 314
  • 1
  • 14

1 Answers1

1

For the year selected in the parameter the expression takes the value of the parameter as it is and displays it as the legend text with no problem. !param - 1 gave issues.

SSRS wants the result to be a string but it comes as int. Thanks Alan Schofield for making me think about this. In this case the integer must be converted to string so the correct expression is:

=CStr(Parameters!Year.Value - 1)

This needs to be in the Series properties - Legend

opperman.eric
  • 314
  • 1
  • 14