Is there a way to drop table based on dataset rowcount

Muthul

In my design, I have 2 datasets and 2 tables.

Let me know is there a way to drop table based on dataset rowcount.

I tried using global variable to store rowcount and it is not working. (PFA design)

Appreciate your advice in this.

johnw

Not sure what you mean by "drop". If you mean just do not display a table based on a row count, you can use a Visibility Expression, and use a Count aggregation in the table to trigger it.

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

You can update this to use an aggregation as opposed to the Total.count used in the article.

John