To add relationship columns:
- Go to Report Builder.
- In the Relationship viewer pane, select Add Relationship icon. The Add Relationship dialog appears.
- Select the down arrow in the Type field and select the type you want. The Relationships display in the tab. Or use Quick search to locate the relationship you want.
- If you want to add Hidden Relationships, select the Advanced Options button and select the check box for 'Show Hidden Relationships'. System relationship are mainly the hidden relationships.
- Select the Add button for the Relationship you want to add.
- Click OK.
- Select SAVE to save the report. The data displays in view mode of the report
Use the Search field to search for a relationship by its Name.
Add Name field to the Report is checked by default and the Name field of the related resource is added to the report.
A relationship can be added multiple times to the Report.