Constructing derived values through combining strings.
Combining string values is one of the most common requirements when building reports.
In this example, I will illustrate how to concatenate string values together to build a simple Contact field.
I’ll begin with a simple dataset containing Supplier data.
As you can see, the data contains four fields, two of which I want to combine into one field – Contact Name and Contact Title.
Instead of simply displaying both fields values in separate fields, I want to combine them.
First, I’ll invoke the Expression Editor.
Within the editor, I can either manually create my expression or select fields from a list.
Also, I may select from an extensive list of operators and functions to build the desired derived values.
Now, I have a “Contact” column that display both the contact’s name and their title.