BIRT Display "No Data" When Table Is Empty Example
This example demonstrates one way to hide a table and to report that no data is present if the query returns no data. A computed column is added to the dataSet that counts the dataSet rows. In the visibility expression for the table, the table is hidden if this is 'null'. In the script for the OnCreate method of the detail row, a variable that was created in the Initialize method of the report is incremented if a row is created. A label is placed below the table with an expression stating that the dataSet is empty. Scripting is done in the OnCreate method of the label to check whether there were any detail rows created. If there were, the label text is set to "".<br />
<br />
Instead of the label idea used in this report design, you could also use a dynamic text box and bind it to the table or dataSet and check the value of the computed column to decide what to display.<br />
<br />
This report was created in BIRT 2.3.0
<br />
Instead of the label idea used in this report design, you could also use a dynamic text box and bind it to the table or dataSet and check the value of the computed column to decide what to display.<br />
<br />
This report was created in BIRT 2.3.0
Warning
No formatter is installed for the format ipb
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 106 General Questions
- 142 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management