Print Page - filter on start date

Title: filter on start date
Post by: tgs728 on 28 Mar 2012 05:37:26 AM

Hi al,

I am having a issue to apply a filter,

Product line product type start date
CE CGears Aug 02 2012
Tents Sep 21 2012
Tools Oct 23 2012
GE AB Sep 21 2012
BC Aug 22 2012

CE CGears Aug 02 2011
Tents oct 13 2011
Tools Sep 28 2011

Here i need to avoid the tools whose start date is les than the tents.

Guys can you help on this ho w to write a filter in report studio.

Thanks ,
TGS

Title: Re: filter on start date
Post by: LOUM on 30 Mar 2012 10:31:21 AM

Are you trying to stay aay from a specifica date frame based on the start date? Or would how would you like the data to show?

Filter the start date maybe: start date < = ?Start Date?

This will create a prompt that when you enter the date it will only pull data with a start date less than or equal to the date.

In this filter you would not see the tools because of the greater start date.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tgs728 on 28 Mar 2012 05:37:26 AM