CrossTab question

[sandradj]

I am pretty new to Cognos. I have a crosstab report in Crystal that I need to recreate in Cognos. I am having an issue with row format. Row heading is the Oracle datetime field with the format: 2008-01-31 12:00:00.000

My report needs to look like this:
Void Paid
Mar-08 5 10
Apr-08 12 13

I need to group row headings (datetime field) by month. Does anyone have an idea how to do this? Thank you!!!!

 

[blom0344]

Various solutions.
One would be to use the Cognos extract function:

extract(month,[dateitem])

and assign this expression to a new query-item

If your package supports native Oracle function you could use:

to_char([dateitem],'MM') or to_char([dateitem],'MON')

Use these for grouping..

Ties Blom

 

[sandradj]

Thank you! extract(month,[dateitem]) worked perfect. Another question, how do you add totals to both rows and columns so the report would look like this:

Void Paid Total
Mar-08 5 10 15
Apr-08 12 13 25
Total 17 23 40

I was able to add total to the rows but not to columns.

Thank you.

 

[sandradj]

Disregard the question about totals. I figured it out.