Handling no-data conditions for tables and charts

PuckPuck

I have a BIRT design and I want to make a table not appear (including the header) if no data for the bound data set is available. Same for a chart.

What is the most straight forward, less script intensive way of doing this?

Virgil Dodson

Hi PuckPuck,

To hide the table when there is no data returned by the query, you can add the following script to the Visibility property of the table.

(Total.count() < 1)

To do this:

1. Select the table.
2. Select the Visibility property in the Property Editor
3. Check Hide Element
4. Replace the word 'true' (which will hide it all the time) with the script above so it only hides when there are no data rows.

You can add the same script to the visibility property of a chart, although in my testing, the charts in BIRT 2.2 may be hiding themselves under these conditions.

Virgil