Producing Reports using OpenOffice.org
Many people are unaware of the functionality included in OpenOffice.org, but powerful reporting capabilities are built in to the standard word processing and spreadsheet applications, allowing you to retrieve data from a wide range of database systems.
Additionally, even more flexible reports can be produced with OpenOffice templates and some Python scripting. Clockwork have produced a utility that allows OpenOffice.org XML files to be unzipped and filled with data from your data source of choice (Anything that can be accessed using Python)
Two versions of this course are available:
Reporting for End-Users
This introduction assumes no existing knowledge of programming or querying databases. Some knowledge of other query systems such as the Query By Example grids in Microsoft Access would be beneficial, but nothing will be assumed
Report Generation for Programmers
This is a more in-depth course for programmers who wish to produce reports that can be integrated into an application for regular generation.