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 
(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 (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,
=v_count=0Hope that helps.
BO_Chief (BOB member since 2004-06-06)
Hi,
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 (BOB member since 2006-02-13)