Kbase P4632: Report Engine: Date fields compared with the unknown value ('?') within a filter degrades performanc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/02/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.3x
Windows
SYMPTOM(s):
Performance problem using Report Builder and the Report Engine
When a date field is compared with the unknown value ('?') within a filter, the report takes about 20 minutes to retrieve and display the data
If the same date is evaluated with a value other than the unknown value the report runs in under one second
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
To workaround this problem do the following:
Create a boolean calculated field in the report called 'is-date-unknown' and make the calculation as follows:
IIF(<some date field> = ?, yes, no)
Then set RB-FILTER to 'is-date-unknown = yes' when the report should display records where the date field is unknown and 'is-date-unknown = no' when the report should display records where the date field contains a valid date.