Print Page - Cross tab report rows

Title: Cross tab report rows
Post by: jak on 01 Sep 2007 05:33:38 AM

Hi Guys,

I am new for Cognos.

Iwould like to get my report in a cross tab in the following.

Year Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
___________________________________________________________
Previous year 10 20
Curren year

Title: Re: Cross tab report rows
Post by: manishtirpude on 03 Sep 2007 10:10:36 AM

Hi,
Use the functions to display the current year and previous year.
to_char(current_date,'YYYY')---for current year
to_char(_add_years(current_date,-1),'YYYY')---for previous year.

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jak on 01 Sep 2007 05:33:38 AM