COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: pali on 20 Sep 2006 12:33:03 AM

Title: master detail-related issue
Post by: pali on 20 Sep 2006 12:33:03 AM
Hi all
I am passing a value from master list to detail lists. There are many detail list assocaited with that master query.
My problem is that i want to hide the master value when there is no record in detail lists.
Since there is no link between the no. of records for each detail list with master list i am unable to hide the Master value.
Its really urgent.
Title: Re: master detail-related issue
Post by: BIsrik on 10 Nov 2006 02:32:11 AM
have an inner join between the tables used in master query and child query. For eg. if table a is used as master query and table b is used in child query, then have inner join between table a and table b in master query itself.

srik