Kbase 19631: Results - How to concatenate fields in GUI Results?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2005 |
|
Status: Verified
GOAL:
How to concatenate fields in GUI Results.
FIX:
The Sports database is used to illustrate the process.
1) From the Progress ADE Desktop, select Tools > Results.
2) Connect to the Sports database.
3) Select Query > New > Report and choose the Customer table.
4) Select the Cust-Num, Name, City and State fields.
5) Select Field > Add Calculated Field > String Function.
6) In the Add Field - String Function dialog box, double-click on
Combine Strings. Notice the expression {string} + {string}
in the Expression window. The first (string) is highlighted.
7) In the Function/Field window, double-click first on City then
on State. sports. Notice that the Expression window contains
the expression Customer.City + sports.Customer.State.
8) Give the expression a name or label and assign the formatting
you wish using the Properties dialog box.
9) Run Print Preview.