want to hide table when there is no data in the table

I am trying to hide the table when the rownum =0. table is hidden but i see the column names . not sure why . please help.

Find more posts tagged with

Comments

CBR

The table seems to be hidden because it contains 0 detail rows. Header and footer are still shown (so you tried to hide the table without success).
Hiding a table if it contained no data is not that easy. Here is a way of how to do it:

You first need a second table that is shown before the table you want to hide. That table is responsible for counting the number of rows to a global variable (let's assume you named that variable rowCount) and will be generally hidden. If you place the original table somewhere below the hidden one you can just use the condition rowCount==0 as the expression to hide the table.

johnw

No need to use two tables for that.

http://digiassn.blogspot.com/2007/03/birt-hide-report-table-when-no-data-is.html

I wrote it several years ago, but the idea should be the same. You add a count aggregation to the table. You create a visibility expression on the table that is true when the count aggregation < 1. The above article used the older Total.count, in version of BIRT > 2.5.X, you can just drop an aggregation component into the table and refer to it in the visibility expression.

srikala

<blockquote class='ipsBlockquote' data-author="'johnw'" data-cid="83587" data-time="1317323617" data-date="29 September 2011 - 12:13 PM">
No need to use two tables for that. 
 
<a class='bbc_url' href='http://digiassn.blogspot.com/2007/03/birt-hide-report-table-when-no-data-is.html'>http://digiassn.blogspot.com/2007/03/birt-hide-report-table-when-no-data-is.html</a> 
 
I wrote it several years ago, but the idea should be the same. You add a count aggregation to the table. You create a visibility expression on the table that is true when the count aggregation < 1. The above article used the older Total.count, in version of BIRT > 2.5.X, you can just drop an aggregation component into the table and refer to it in the visibility expression. </blockquote>
 
Thanks a lot , its working!