Kbase 19929: How to Change the Label of an ADHOC Parameter in Actuate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/3/2008 |
|
Status: Verified
GOAL:
How to change the labels of the ADHOC parameters you use in Actuate reports.
FACT(s) (Environment):
Actuate 4.x
Actuate 5.x
CAUSE:
In certain circumstances you can encounter a confusing prompt that asks you for a parameter value.
The following example illustrates the scenario.
Assume you have a table with a name that has a hyphen (-) in the middle (cod-company) and a field called "comp-name":
Actuate replaces the "-" with "x2d". If you make the field "comp-name" an ADHOC parameter, you get the following expression asking for the parameter value:
codX2dcompany.compX2dname.
This expression is confusing because the value the report asks for is unclear.
FIX:
Take these steps to change the label and not affect the report:
1) Open the report.
2) Go to the menu VIEW.
3) Select the option PARAMETERS. A list of parameters appears, including the ADHOC.
4) Select the parameter whose label you want to change.
5) Press the MODIFY button at the bottom of the window. A window with the information of this ADHOC parameter will appear.
6) There is an ALIAS field where the expression of your request can be placed. Write the correct expression.
7) Press OK and close this window.
8) Run the report again to regenerate the .rox
Now when you run the report, the ALIAS expression text you just supplied (and not the confusing Actuate version) appears when you are asked for the ADHOC parameter values.