|
Variables |
|
|
|
|
|
Variables |
|
|
|
|
Defined
Variables are a space reserved in computer memory that can store information. Variables used in the Report Builder are visible only within the Report Builder itself - other areas of ComQuest cannot use variables that you create for use with reports, and are deleted from computer memory once the report has been generated.
User Variables - Modify
These buttons are available only for the User Variables section of the dictionary.
User Variable control buttons
From left to right the buttons allow you to:
| • | Add a new variable to the dictionary |
| • | Modify an existing variable |
| • | Delete an existing variable |
User Variables - Save
This button is available only for the User Variables section of the dictionary. Save changes made to user variables that are stored in the dictionary.
Concatenation
Concatenation is a fancy word that means "join together"; it is most often used in the computer programming world, which is why you've probably never heard of it.
The ampersand symbol ( & ) is used to join together one string field or string variable to another. The length of the resulting string is the sum of the lengths of the two strings. Numeric data types may be concatenated with strings or other numeric variables or constants. In many cases, the CLIP() function should be used to remove any trailing spaces from a string being concatenated to another string.
Examples: clip(NAM:Lastname) & ', ' & clip(NAM:Firstname)
'$' & ITM:UnitCost
