Kbase 17294: How to use multiple parameters in Actuate query editor
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to use multiple parameters in Actuate query editor
How do I prompt the user to fill in values for multiple parameters at
run time?
Suppose you want to run a report which prompts the user to enter a
values for a range a customer numbers when the report is run.
In the Conditions tab of the Query Editor, you must enter each
parameter on a separate line. For example:
Under Column Name, select Customer.Cust-Num
Under Query Expression, type: >= :Lowvalue
Now go to the second line in the Conditions tab.
Under Clumn Nmae, once again select Customer.Cust-Num
Under Query Expression, type: <= :Highvalue
Highvalue and Lowvalue will now appear as parameters in the Requester
dialog box.
(It will not work to type a Query Expression as:
>= :Lowvalue AND <= :Highvalue )
See also kbase entry 17127 "Actuate Can not execute All parameters not
have values bound"
Progress Software Technical Support Note # 17294