If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Hide table rows

Started by dune1914, 23 Jan 2016 06:45:38 AM

Previous topic - Next topic

dune1914

Hello,

We have a list fed by Query1 with one column that we unlocked and then inserted a Table of 1Columnx6Rows. QUERY1 = US AND GERMANY.

Inside the table, in the 1st "row",in first table cell, we have inserted some text objects and some data items coming from Query1.

On 3rd row we have inserted one DETAIL list object fed by "Query1" to show US and GERMANY Info.
On 4th row we have inserted some text.

On the 5th row we have some text objects and another list object fed by "Query2"=USA.
We are hiding its column list "TITLES" because we only want it to show TOTALS for USA and for esthetic matters (we need to display totala only 3 lines lower) we cannot really use the LIST's automatic SUMMARIZATION.

On the 6th row we have some text OBJECTS and another list object fed by "Query3".
We did the same as we did for the 5th row's list object bu this is for GERMANY data only.

So far so good.

QUESTION:
How do we manage to hide row5 and/or row6 if NO DATA at all in both lists ?