Kbase 19642: Report Builder -- How to Concatenate Integer Values
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/06/2004 |
|
Status: Unverified
GOAL:
How to concatenate Integer values in Report Builder using a combination of Functions in a Calculated Field.
FIX:
Because integer fields as such can not be concatenated, the Values must first be converted to Strings.
In the example below, a "1" is appended as the last digit to the Sports.Customer.Cust-Num field. The value is then converted back to an Integer.
INTEGER(NUMERIC(TRIM(STRING(Cust-Num,"99999") + STRING(1,"9"),".")))