Starting from minor version 2025.2.2, a new relation parameter JoinType was introduced in Stimulsoft products. It defines the type of join between two data sources. In this article, we’ll take a closer look at how to use this parameter.
Algorithm of work
The JoinType parameter is used in data transformation and in dashboards. It specifies how two data sources should be joined.To begin, open the report designer and locate (or create) two data tables in the Data section that need to be joined.
Create a new relation by right-clicking on one of the tables and selecting New Relation.
In the relation settings window, specify the parent and child tables, as well as the fields used for joining.
Then, using the JoinType option in the relation settings, select one of the available join types.
Available join types
Stimulsoft’s reporting tool supports four main types of table joins through the JoinType parameter:
INNER
Returns only matching records from both tables. If there are no matches, the rows are excluded.
LEFT (Main data source)
Includes all records from the main data source and the matching ones from the right.
RIGHT (Child data source)
Similar to LEFT, but keeps all records from the right table.
FULL
Returns all records from both tables.
Using the correct join type allows you to flexibly control how data from two tables is merged in your dashboard, which is essential for accurate data display and analysis.