Tuesday, December 15, 2009

Conditional expressions in Cognos Reportstudio

 Syntax

if(?monthcode?='1')
then
(' January')
else if(?Report Period?='2')
then
(' February')
else if(?Report Period?='3')
then
(' March')
else if(?Report Period?='4')
then
(' April')
.
.
.
.
.

else if(?Report Period?='12')
then
(' December')


Case when syntax
 
case ?monthcode?
When 1 then 'Jan'
When 2 then 'Feb'
...
When 12 then 'Dec'
end

No comments:

Post a Comment