COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: sencognos on 17 Jun 2022 07:09:45 AM

Title: Cognos Report Studio - Hide a List 1 if no data on List 2
Post by: sencognos on 17 Jun 2022 07:09:45 AM
Hi Cognos Experts,

I have a reporting scenario .

Requirement : There are 2 list List 1 and List 2 pointing to different queries connected with Master Detail Relation Ship .

Need to hide List 1 if the Row Count in Lsit 2 is Zero basically , if List 2 has No Data then List 1 should be hidden .

I tried to create a variable but the list one does not associate the variable .

PLease share your thoughts and expert advise how to approach this requirement .

Thanks in Advance !
Title: Re: Cognos Report Studio - Hide a List 1 if no data on List 2
Post by: sencognos on 17 Jun 2022 07:44:25 AM
Dear Cognos Experts !

Any suggestions on this topic would be much much helpful .

Thanks in advance !
Title: Re: Cognos Report Studio - Hide a List 1 if no data on List 2
Post by: BigChris on 28 Jun 2022 02:11:23 AM
Sounds like you need a render variable. Possibly based on a count from List 2