BusinessObjects Board

Hide table when empty

I am using 6.5 sp2. I have a table that is returning no rows. I want to hide the whole table if no rows are returned. I thought of using the CountAll function, but that is based on a data provider and I would prefer not do create another data provider.

ldcaudle (BOB member since 2005-10-04)

You can hide the block, as explained in this example. (There may be other examples, that was the first I found on a Search.)

Anita Craig :us: (BOB member since 2002-06-17)

This requires that I create a new data provider and I don’t want to do that.
Search returned nothing, so that’s why I’m making this post. How do I count the rows in the table - even if there are none?

ldcaudle (BOB member since 2005-10-04)

That was just meant to give you a hint. Create a second block of some sort, perhaps with just a message. Toggle it to be hidden if your data provider returns data, else toggle the main table if the data provider doesn’t return data.

Anita Craig :us: (BOB member since 2002-06-17)

Create a variable ‘v_count’ :

= Count(<your_object>)

Go To --> Format Table --> Appearance Tab --> in the HIDE table formula use,


Hope that helps.

BO_Chief :us: (BOB member since 2004-06-06)

In the table properties in the apperance tab there is one check box called Hide Block.

Check that and then write the formuala =NumberofRows(“Data Provider Name”)=0

It will hide the block if that particualr Data Provider does not return any rows.

Omkar Paranjpe :us: (BOB member since 2006-02-13)