Kbase 13695: Report Builder and overriding the filter condition
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/12/2008 |
|
Status: Verified
GOAL:
Interaction between Report Builder and passing the filter condition parameter.
GOAL:
Report Builder and overriding the filter condition?
FACT(s) (Environment):
Report Builder
Progress 7.x
Progress 8.x
Progress 9.x
FIX:
If you create 4GL code, and the 4th parameter which is RB-INCLUDE-RECORDS is O for override and the 5th parameter which is RB-FILTER is a filter condition, example cust-num < 10, the client side evaluates the condition.
Report Builder does NOT pass that filter condition to the SQL engine.
Prior to previewing the report, it will apply the filter condition locally. This may decrease performance.
It has been recognized that this is not the best approach to this problem. Development is addressing this. Starting in 7.3B it will be such that if the filter condition contains only server-evaluatable expressions, then this condition will be passed to the server and the client will not have to apply the filter prior to previewing the report.