Reportnet report - Dynamic Column heading

[spicysudhi]

hi

i want to hav a column heading generated dynamically. THe column is Forecast for current month, next and next+1 month. I want it to be displayed as October, Nov and Dec. Next month when report is run, it should say Nov, Dec and Jan.

how to do this, please suggest.
thanks in advance.

regards,
sudi

 

[lincon]

You can select report expression property for column current month,next and next+1.Expression is defined like
following:
Current Month:
case month(now)
when '1' then 'Jan'
when '2' then 'Feb'
.....
when '12' then 'Dec'
end


Next Month:
case month(now)
when '1' then 'Feb'
when '2' then 'Mar'
.....
when '12' then 'Jan'
end


Next+1 Month:
case month(now)
when '1' then 'Mar'
when '2' then 'Apr'
.....
when '12' then 'Feb'
end