Creating class joins in reports
Extend the scope of your report by displaying data from various classes. For example, if your report about insurance policies applies to the Work- class, you can include specific data from different classes by joining the classes together.
By default, report definitions include data from only the class to which the report applies. By using the class join functionality, you can make your reports more comprehensive.
In comparison with association rules, joins are not reusable across multiple report definitions, and apply only to the report that you edit.
- In the navigation pane of Dev Studio, click Records, and then click .
- In the list of report definitions, click the report definition that you want to edit.
- Click the Data access tab.
- Create a join between classes:
- In the Class joins section, click Add class join.
- In the Prefix field, enter a short alias for the
class that you want to join with the class to which your report
definition applies.The prefixes help the system to distinguish classes and ensure that classes are joined accurately.
- In the Class name field, enter the name of the class that you want to join.
- Click Edit conditions.
- In the Column field, specify a property of the class that you want to join.
- In the Value field, enter a property of the class to which your report definition applies, and then click Submit.
- In the Type list, select the type of join to use.
- Click the Query tab, and in the Edit columns section, click Add column.
- In the Column source field, enter the prefix of the joined class, and then select the specific properties that you want to include in the report.
- In the upper-right corner of the report definition, click Save.
Previous topic Viewing associations that are available for reporting Next topic Using join filters to combine data in reports