Kbase 16155: Multiple date variables in report engine RB-OTHER-PARAMETERS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Multiple date variables in report engine RB-OTHER-PARAMETERS
Here is an example of how to include multiple data variables in the
RB-OTHER-PARAMETERS parameter of the Report Engine.
In this example, the user has been prompted to supply values for two
dates which will be used as RUNTIME-PARAMETERS in a report. These
dates are stored in the variables Low-Vaule and High-Value.
Each variable must be separated by a line-feed character, either ~n
or the ascii equivalent CHR(10). (See page 3-23 of the version 8
Report Builder Deployment Guide for more info and examples.) The
entire expression is concatenated together as a single string.
RB-OTHER-PARAMETERS would read as follows:
"B-Date = " + string(low-value) + "~n E-Date = " + string(high-value)
In this example, B-Date (beginning date) and E-Date (ending date) are
used in the report as runtime-paramters. For example, the report
might have a calculated field as follows:
IIF(ship-date >= DATE(RUNTIME-PARAMETER("B-Date")) AND ship-date <=
DATE(RUNTIME-PARAMETER("E-Date")),YES,NO)
B-Date and E-Date must be converted back into dates as
RB-OTHER-PARAMETERS only passes strings to the Report Engine.
Progress Software Technical Support Note # 16155