The link below is a 'sample' database ( HSQL - embedded OpenOffice database ) that includes two Reports and some Queries:
- HSQL_Database_Index_Information
- HSQL_Database_Table_Information
The idea is, if you place this database on your machine, open both this database and your HSQL database, COPY ( drag and drop ) from this database, the two Reports to your HSQL database, it will create reports describing your database definition.
Additionally, one could 'explore' the Reports to see an example of using the Sun Report Builder. For example, use of 'functions', 'groups', etc.
- For OpenOffice 3.1 http://www.mediafire.com/file/nyzuwwkwm ... DB-RPT.odb
- For OpenOffice 3.2 http://www.mediafire.com/download.php?5w5memzmhdo
Enjoy.
Sliderule