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.