Switch Command Equivalent
Posted on 2006-05-30
I have a field in my SQL query that pulls out the month part of a date field. So, this field naturally displays when I run the query as 1, 2, 3, etc. On the report, I would like to have the actual month name show. I am working in the layout view in SQL Reporting services. In the header, where the numbers currently show, I would like to write an expression that would replace the number 1 with Jan, the number 2 with Feb, the number 3 with Mar, etc. In Access, I would use a Switch command to accomplish this. I am not sure how to go about it in SQL Reporting Services. Thanks in advance.