IBM Support

How to create a Master Detail Relationship

Troubleshooting


Problem

This document describes how to create a Master Detail Relationship in Report Studio

Resolving The Problem

Associate the master query to a Page break so that the two Queries are not at the same level so that Query1 is associated to the Page Break and Query2 is associated to the List.

These steps describe how to have two lists on a single page, and have a Master Detail relationship between them...

1. In Report Studio, insert two lists on one page.

2. Add the required columns to both lists.

3. In the master list, group the column that is to be used as the link in the master detail relationship.

4. Insert a filter into the master list so that you only see the records that you want to see in the child list.

5. From the View menu, select Report Pages.

6. Click anywhere on Page1 to enable the Properties pane on the bottom left of the screen.

7. In the Properties pane, under Data\Query link the master query to the page.

8. Double-click anywhere on Page1 to return to the report layout screen.

9. Click anywhere on the detail query. From the Data menu, click Master Detail Relationships.

10. Create a New Link to establish the appropriate relationship between the two queries.

11. Click OK.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21339010