COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 10 Feb 2020 12:00:53 PM

Title: the master-detail link is missing from the crosstab - Repeater table
Post by: peewan on 10 Feb 2020 12:00:53 PM
I'm creating a page break on cross-tab with a repeater table (Product Type). The page will break on Product type name and the cross-tab will show the details. But while doing this, "The master-detail link is missing from the crosstab or chart" error is coming.

Note: Repeater table with 2 columns: First: Product type, second is Crosstab with all details

Please help! Thank you.
Title: Re: the master-detail link is missing from the crosstab - Repeater table
Post by: Francis aka khayman on 10 Feb 2020 03:54:00 PM
you might need to associate your page to a query, then define a master detail relationship between your page and your crosstab.
Title: Re: the master-detail link is missing from the crosstab - Repeater table
Post by: peewan on 10 Feb 2020 04:04:11 PM
Quote from: Francis aka khayman on 10 Feb 2020 03:54:00 PM
you might need to associate your page to a query, then define a master detail relationship between your page and your crosstab.

1. I click on 'Drop down' select 'Page'
2. In DATA, Query - select 'Report Query'
3. in DATA, Master detail relationship: click on this, but it said 'No Master query context can be found for this object'


Would you please give more details? this is my first corsstab report :) Thank you
Title: Re: the master-detail link is missing from the crosstab - Repeater table
Post by: Francis aka khayman on 11 Feb 2020 07:33:57 AM
yeah that is expected. so...

4. select the crosstab.
5. On Data, Master detail relationships, click the ... and define the relationship.
Title: Re: the master-detail link is missing from the crosstab - Repeater table
Post by: peewan on 19 Feb 2020 11:34:25 AM
Quote from: Francis aka khayman on 11 Feb 2020 07:33:57 AM
yeah that is expected. so...

4. select the crosstab.
5. On Data, Master detail relationships, click the ... and define the relationship.

Thank you! That works now :)