Kbase 17194: Actuate - How to display logical fields in Actuate
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Actuate - How to display logical fields in Actuate
KBase 17190 explains how logical fields are displayed in SQL format in
Actuate (0/1) while Progress is true/false or yes
o.
One of the ways to change this is to:
Drag the field from the field list and set it's format to "Yes/No".
or
You could also do the following:
1. Choose a Text Control and place it in the Control Frame.
To do this you will need to click on the "Controls" icon
and then click on the "Text" icon and drag and drop it into
the Control Frame.
2. It will now ask you for the ValueExp.
3. You can use the Expression Builder to convert the field using
IIF() function.
IIF([dbname.logicalfield] = "0", "No", "Yes")
Now, when you run your report it will display Yes and No for this
logical field.
Progress Software Technical Support Note # 17194