SSRS 2008 R2 BIDS I have created a line graph. In the legend I put: =year(Globals!ExecutionTime) The report runs but gives me the following warining: [rsInvalidExpressionDataType] The LegendText expression used in chart Chart4 returned a data type that is not valid. It also does not display the year but instead displays the column name. What am I doing wrong?

Hello Scott, Nothing looks to me wrong in your expression but still try this:- 1. Close your project as well as solution under BIDS and restart IDE. (I think this should get rid of warning and it should display YEAR correctly) 2. If than also doesn't work try this expression "=Year(CDate(Globals!ExecutionTime))" Please let us know your feedback. Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS

Hi Kumar, I restarted BIDS. I am not sure what IDE is. That did not help. I also tried your expression it did not help either. I did however get it to work by using: =CStr(year(Globals!ExecutionTime)) Thanks for your help.