We have a requirement to show report in the following order...
the user runs the report on a week day, the report variable should be filled with
earlier week sunday as low value and saturday as high value
QUERY WEEK WEEK WEEK
RUNDAY DAY LOW HIGH
28/10/07 SUN 21/10/07 27/10/07
29/10/07 MON 21/10/07 27/10/07
30/10/07 TUE 21/10/07 27/10/07
31/10/07 WED 21/10/07 27/10/07
01/11/07 THU 21/10/07 27/10/07
02/11/07 FRI 21/10/07 27/10/07
03/11/07 SAT 21/10/07 27/10/07
04/11/07 SUN 28/10/07 03/11/07
05/11/07 MON 28/10/07 03/11/07
PLS OBSERVE LAST TWO ROWS CLEARLY...
Low Value: Always default to the prior Sundays date
High Value: Always default to the prior Saturdays date
This is the query logic and if anyone came accross this logic,
can you send me the code for the customer exit for this logic or
any help regarding the same will be heartly appreciated.
thanks in advance