Expressions can contain values from data sources. A string
representation of the field is used to reference that field from the data
source. The proper syntax for the reference is the name of the data source and
the field name with a full-stop character or decimal point separating them,
surrounded by curly braces:
In cases where the data source has a parent relationship with another data source, you can reference other fields from the parent data source. The proper syntax, in this scenario, is the name of the data source,
followed by the relation name, and then the field name. Each name should be separated by a full-stop character or a decimal point, and the entire thing should be surrounded by curly braces, as before.
If you have a set of information like the following:
The above expression will yield the name of a category for a
cabinet in the report.
A column can be called through multiple relationships. For
example:
The above expression will yield the name of a category for a
cabinet in the report. This is has been done without a direct call to the Categories data source.
All data items are converted to the type that is specified in the options column. This dynamic conversion helps to accelerate the development of reports. To acquire data from a column without conversion,
specify the data source directly.
In C#:
The above expression will return data from the Cabinets data source without conversion.
In VB.NET: