COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gollavinaykumar on 11 Jul 2012 03:35:28 PM

Title: Alternative for Master-detail relationship
Post by: gollavinaykumar on 11 Jul 2012 03:35:28 PM
Hello ,

I have designed a page layout for showing insurance Claims details such as name,id,address etc.

Query1 has claimant name, claiamant number, reported date, location, address of the claiamant etc.

each claiamant number may have one ore more claimant names.

So, in my Output page I created list with query with just claimant name and claimant number and created a master-detail relationship to the list. But it is taking long time to give the output.

is there a way to remove the master detail relationship and what should I do to display the claimant number and many claiamnat names below that?

thanks
Title: Re: Alternative for Master-detail relationship
Post by: pricter on 11 Jul 2012 03:49:13 PM
You can try to create a list and use as a header  the "claiamant number"
Title: Re: Alternative for Master-detail relationship
Post by: gollavinaykumar on 11 Jul 2012 03:59:53 PM
I am not sure what do you mean by header.

This is the format I need in each page.

Agency Name:   XXXXXXXXX
Insured:  XXXXXXX
Policy #:  XXXXX
Claim #:  12345
Claimants:
               AAAA
               BBBB
               CCC




Title: Re: Alternative for Master-detail relationship
Post by: pricter on 11 Jul 2012 04:36:24 PM
Look at the attached picture if this is your case