Column Heading for the next 3 months

building reports webintelligence
1

I have a report that uses several breaks and filters to give a summary of data. It works as is and would take a lot for me to convert to a crosstab report (probably the better way to do it). Bottom line here is my question. I have 4 columns where the header looks something like this:

=Month(CurrentDate()) =(MonthNumberOfYear(CurrentDate())+1) =(MonthNumberOfYear(CurrentDate())+2) =(MonthNumberOfYear(CurrentDate())+3)

I am trying to get 4 columns that show:

August September October November

The first formula works correctly when properly formatted as a date I get August. I can’t figure out how to use the Month Function (or any other function) and add 1 month to the current date to give me September.

Right now I get:

August 9 10 11

=Month(CurrentDate()+1) doesn’t work

Any help would be really appreciated.

Using Desktop Intelligence XI, Oracle DB but I have to do this at the report level. No access to the universe.

Thanks

MAXFLI (BOB member since 2007-08-28)

2

Right or wrong here is how I fixed it:

= If (MonthNumberOfYear(CurrentDate())+1)= 1 Then “January”
Else If (MonthNumberOfYear(CurrentDate())+1)= 2 Then “February”
Else If (MonthNumberOfYear(CurrentDate())+1)= 3 Then “March”
Else If (MonthNumberOfYear(CurrentDate())+1)= 4 Then “April”
Else If (MonthNumberOfYear(CurrentDate())+1)= 5 Then “May”
Else If (MonthNumberOfYear(CurrentDate())+1)= 6 Then “June”
Else If (MonthNumberOfYear(CurrentDate())+1)= 7 Then “July”
Else If (MonthNumberOfYear(CurrentDate())+1)= 8 Then “August”
Else If (MonthNumberOfYear(CurrentDate())+1)= 9 Then “September”
Else If (MonthNumberOfYear(CurrentDate())+1)= 10 Then “October”
Else If (MonthNumberOfYear(CurrentDate())+1)= 11 Then “November”
Else If (MonthNumberOfYear(CurrentDate())+1)= 12 Then “December”

MAXFLI (BOB member since 2007-08-28)

3

You look like you will have a problem in December. December + 1 = 13. 13 should equal January in your case statement?

weaver (BOB member since 2008-10-17)