Report Studio

Creating a Join Relationship

You can create a join relationship to join two queries.

Note: In general, join relationships should be created in the model. Create a join relationship in Report Studio reports if what you are trying to do cannot be accomplished using the model.

To create a join relationship:

Pause the pointer over the query explorer button and click Queries.
From the Toolbox tab, do the following:

Drag Query to the work area.
Drag Join to the right of the query.
Two drop zones appear to the right of the operator.
Drag a Query object to each drop zone.
Two queries are created in the work area, and a shortcut to each query appears in the drop zones.

Double-click each query that makes up the join query and add the data items that you want.
On the toolbar, press the back button to return to the Queries work area.
Click Join.
In the Properties pane, double-click the Join Relationships property.
Click New Link.
Click a data item in the left query, and then click a data item in the right query to create a link.
For each query, click Cardinality, and then click the cardinality that you want to use.
Click Operator, and then click the operator that you want to use.
To convert the join relationship to an expression, click the Convert to expression button.
Convert the join relationship to an expression to make changes to the join definition.

Note: After you convert the relationship to an expression, you cannot change it back to a relationship.
Double-click the join query.
In the Source tab , drag the data items that you want to add to the Data Items pane.

The join query is complete. You can now link it to a data container in the layout.