If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

filter on start date

Started by tgs728, 28 Mar 2012 05:37:26 AM

Previous topic - Next topic

tgs728

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

LOUM

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.