Show/Hide when Empty issue

building reports webintelligence
1

Hi,

I have a single data provider with some 20 + objects.

The report body is as follows:

Section Start

Table with some 10 columns

Table with 2 columns

Table with 2 columns

Table with 2 columns

Table with 2 columns

Table with 2 columns

and so on…

Section End

Here whenever the “Table with 2 columns” are null ie both the columns are null, i want to hide it. I unchecked 'Show When empty".

It works when the query doesn’t return any row. But when the query return data for the query and even these 2 columns are null, the table is displayed.

since there are some 14 such 2 column tables and mostly null, it wont make sense displaying null blocks that too 14 :shock: .

Any idea where I m going wrong.

Thanks
Vinesh

VKK (BOB member since 2008-08-21)