Print Page - How could i write Query expression

Title: How could i write Query expression
Post by: nesanurisundar on 12 Apr 2011 12:54:38 AM

Hi All,

I've expression like
In Data Item1 -- sales amount where month=?month? and
In Data Item2 -- sales amount where month=?month?-1.
and i have prompt value in prompt page i.e., month
i've getting values for first data item but not getting value for second data item...
So how could i write the expression in data item

note: month value is in 2 digit character

Thanks
Sundar

Title: Re: How could i write Query expression
Post by: babu babu on 12 Apr 2011 06:10:43 PM

Hi Sundar,

Disable the global filter for month and change the aggregation property to total for the dataitem1 and data item2.

Thanks!
Anand.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nesanurisundar on 12 Apr 2011 12:54:38 AM