Monday, January 25, 2010

How to filter for a range of dates?

Typically, users create two date prompts: A Start date prompt and an End Date prompt to get data for a period.

IBM Cognos Report Studio lets you accomplish this using one Date prompt and using “in_range “ operator.
Steps:
1. Drag and Drop a Date prompt
2. Enable the Create a Parameterized filter
3. Select a date field ( such as ship date, Order date etc)
4. Select the Operator as “in-range” as shown below:


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
5. Click Finish and run your report