Kbase 13709: Report Builder, passing sort criteria at runtime
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Report Builder, passing sort criteria at runtime
Passing sort criteria at runtime can be done with user-defined
parameters. Sort on a calculated field with an expression such
as CASE(RUNTIME-PARAMETER("SORTFIELD"),"NAME",NAME,"CUSTNUM"
CUSTNUM,"ZIPCODE",ZIPCODE,CITY). This allows for the choice of 4
sort fields at runtime.
Note that you are limited to choosing among fields that have the same
data type, since the CASE function requires that all potential return
values have the same data type.
Progress Software Technical Support Note # 13709