Print Page - Filtering data at final report level.

Title: Filtering data at final report level.
Post by: rajivgupta1107 on 18 Dec 2008 04:13:17 AM

Hi

I want to filter data for prepaid and postpaid on some flag. How can I filter the same. I cant put the filter on flag in detail filter. I need to show data in 2 separate lists on display page (for prepaid and postpaid).

So is there any way of doing the same?

Regards

Title: Re: Filtering data at final report level.
Post by: Gopinath on 18 Dec 2008 06:22:28 AM

Have a Main query with all the data items

create 2 more queries for 2 lists

Take the data items from the main query and filter accordingly in each of the 2 queries which you use to display

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rajivgupta1107 on 18 Dec 2008 04:13:17 AM