Consultor Eletrônico

Actuate Can not execute All parameters not have values bound

Try to run an Actuate report. Get the error:

Basic Error 1011
Module: C:\Actuate\DEVWB\afc\db.bas
Line: 144

Database Error
10 Can not execute statement since all parameters do not have values
bound.

There are at least two possible reasons for this.

1. You are trying to reference a global parameter in the query editor.
If you would like to create a parameter and prompt the user to enter a
value for this parameter via the requester box, do not go into View ->
Parameter and create a parameter. This would create a global
parameter. The query editor can not use global parameters.

Instead, you may create a local parameter "on the fly" in the query
editor in the Conditions tab by prepending your parameter name with a
colon. For example, in the Conditions tab:

Under Column Name, select a field name, such as Customer.Cust-Num.
Under Query Expression, type, for example, >= :lowvalue.
This creates a local parameter called lowvalue which will appear in
the requester box when the report is run.

You may now create default values, groups, etc. for lowvalue under
View -> Parameter, select lowvalue, -> Modify.

2. This error can also be caused by having defined two or more
parameters with the same name. Check the Parameter Editor (View ->
Parameter) to see a list of currently defined parameters. Compare
this with parameters you may have defined on the Conditions tab of the
Query Editor. It is possible for these two editors to get out of sync
with each other. Renaming or removing the duplicate parameter can
often fix this error.

Progress Software Technical Support Note # 17127