Variables

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

 

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.

 

RepBuildControls

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