I thought this would be pretty simple, but there must be something I am missing. I have a parameter placed on the month number in my report. I want that month number to be changed to the month name so that I can include the month name in the header once the report is launched.
I tried using a single_value_query function and used a Case statement. (i.e. Case When 1 then 'January'
When 2 then 'February'
etc, etc, etc.
Although I think the problem here is that the parameter value keeps being returned as null to the query therefore it produces no results.
How do you do this so the parameter value is not null?