Mindmajix

How to Create Master Detail Relationship in Cognos Report Studio

Master Detail Relationship Report

  • The 2 containers can be merged using master details relationship
  • The 2 containers should have a common query item to merge the data
  • Add the following query items to the list
  • Staff name
  • Order number
  • Order date
  • Revenue
  • From toolbox,
  • Drag the list drop beside the revenue
  • Add the following query items to the list2
  • Order number
  • Product name
  • Description
  • Quantity
  • From List2,
  • Select order number
  • From toolbar click on cut
  • From list2,
  • Select quantity
  • From data menu,
  • Select aggregate
  • Click on total
  • From data menu
  • Select Master Detail relationship
  • Click on new link
  • From list2
  • Select quantity
  • From data menu
  • Select aggregate
  • Click on total
  • From data menu
  • Select Master Detail relationship
  • Click on new link
  • From query1
  • Select order number
  • From query2
  • Select staff name
  • From structure menu
  • Click on Group
  • From structure menu
  • Select Headers & Footers
  • Click on create headers
  • Select the staff name header cell
  • From toolbar, click on delete
  • Edit the fonts
  • Run the report

MASTER DETAIL RELATIONSHIP REPORT

master detail relationship

Screenshot_1019

Screenshot_1020

Screenshot_1021

Screenshot_1022

Screenshot_1023

Screenshot_1024

Screenshot_1025

Screenshot_1026

Screenshot_1027


 

0 Responses on How to Create Master Detail Relationship in Cognos Report Studio"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.