Displaying a message when table is empty

Hi all,

I tried to display a message when the table does not have any rows/data but I didn't find the solution yet!
an example with .rptdesign would be nice if dear members can post.
I use BIRT 2.3 version and XML source for the connexion.

My best regards!

Solofo

Find more posts tagged with

Comments

Took me a while to find the answer and I wrote it. Search needs some tuning.

http://www.birt-exchange.org/org/forum/index.php/topic/20094-how-to-check-whether-the-resultset-of-a-query-is-null/page__hl____rownum__fromsearch__1

Add a 'No Data Found for Given Parameters' Label to a Header row of the Table displaying the DataSet.
Then give this label (or Row) a Visibility hide expression of row.__rownum >= 0. If there are no rows it returns -1 and the label will appear.