Knowledgebase: Reports and Letters
Concatenation in the Report Writer
Posted by Linda on 07 May 2009 03:10 PM
An interesting note about concatenation in the report writer:

The math functions in the report writer can be used for concatenating variables by writing a regular equation with a plus sign.
Changing the type of variable from an "numeric" to a "string" changes the output from regular math to concatenation.

REGULAR ADDITION FORMULA SYNTAX

@tvar12# = 12
@tvar34# = 34
@tvar1234 = @(tvar12+tvar34)
//@tvar1234 will now be equal to 46.

CONCATENATION THROUGH 'ADDITION' FORMULA SYNTAX

@tvar12* = 12
@tvar34* = 34
@tvar1234 = @(tvar12+tvar34)
//@tvar1234 will now be equal to 1234.

Note, the only difference is the # and the *, and # stands for INTEGER where * stands for STRING.
(0 vote(s))
Helpful
Not helpful

Comments (0)