Hi
In my matrix cell I have a cell with the following Expression:
=Fields!monthname.Value & " " & Fields!Year.Value
In one of my datasets I have a SELECT CAST(FCYB.cyb_yearname AS int) AS 'Year' ... amongst other things.
Now, how do I make 'Year' to say 07 instead of 2007? What is the proper way to do it? In the expression or in the SQL code?
Thanks in advanced as always
KR
Use Right(fields!Year.Value,2)|||
Thanks a lot!! Worked perfectly!!
No comments:
Post a Comment