Fillter on Due Date in BO 6.5 Deski Report

building reports desktopintelligence
1

Hi
I need to modify the report as per the following Instruction in BO 6.5 Deski So please help me with solution or any idea.
Need A formula for filter in BO 6.5 in Report on Due Date Column.
Priority Date will not be there in the report, It will be there in Universe.

If u don’t have Idea about BO just send me formula in Oracle or Sql… Just need an Idea…

Example

Current Report

Priority Date ///// Due Date ///// Title
10/10/08 ///// 10/10/09 //// 12 Month proceed
21/08/08 ////// 21/08/09 ///// 12 Month Proceed
24/06/08 ///// 24/06/09 //// 12 Month Proceed

(Current Date is 21/08/2009)

I don’t want rows with the current date as due date and even due date passed out (like 24/06/09).
Need formula or Filter on Due Date(Column in BO)
So the final result should be as follows.
Report should display only the rows with due date after current date.

Priority Date //// Due Date //// Title
10/10/08 //// 10/10/09 //// 12 Month proceed

Note:(/////(space between fields))
Let me know if any clarification needed from my end.
Thanks in advance, I would appreciate if somebody helps me with the solution

Reshi (BOB member since 2009-01-27)

2

Hi,

Create a new report-level variable/flag with the syntax:

=<Due Date> > CurrentDate()

Then filter only records where the =1.

Marek Chladny :slovakia: (BOB member since 2003-11-27)