Hi There.
I have seen this topic sort of discussed a few times recently but they always seem to assume access to the oracle database.
I have a data item that returns a number 1 thru 12 and I would like to convert it to display as the Month so 1 would display as January.
Is this possible to do in Report Studio?
Do you mean that for some reason you don't want to use Oracle functions, like below?
to_char(to_date(to_char([your numeric column],'09'),'MM'),'Month')
I can use oracle functions inside Report Studio?
Unfortunately I'm pretty much a novice at this and been given a monster of a dataset that I can't change and must mould to fit the requirements from inside Report Studio.
You can if the Oracle function set is included in the package you are working with, and I can't imagine that it wouldn't have been if that's your platform. I'm not sure exactly "where" you can use them in C8 - we are still running Reportnet, where you can use them at the Tabular level but not at Query level. Try putting the function in a calculated data item and see what happens.
Another alternative, if you simply need to display the month name rather than use it in subsequent calculations, using Cognos function only:
_make_timestamp(2008,[your numeric value],1)
...then format the item on your report as Date with long display of month and no display of year or day