BaseReportExtension

Description

With this small extension you are able to fill tables in a writer-document with data derived from a registered datasource, or the current opened database. That's not new, the built in reportbuilder does that too, but:

You gain all the benefits from both:

• all the formatting features of a table in a LO-Writer document combined with
• all possibilities of queries or SQL in LO-Base.

Data definitions are easily done by inserting one custom property (plain text) for each table you want to fill. At the end the LO-Writer document can either be

1. opened (even with a non-LO-program that you specify), it can be
2. mailed (if your mail client supports sending from commandline (... Mozilla's Thunderbird does)), it can be
3. saved as pdf/otd or it can be
4. returned as a BASIC-object (e.g. if called from another macro and you want to do something else with it).

Some other features you'll find:

• refer in your query easily to contents of currently opened Base-forms
• use data from many different datasources in one report
• merge adjacent cells of a table
• save your report directly as odt or pdf to the path you define per default
• display the pdf after saving
• run a SHELL after the report was generated – e.g. mail it or load it up per ssh
• text overflow in cell of a table will enlarge the cell
• The extension is well documented - you can easily improve it for your own needs if you know the basics of Staroffice-Basic
• Support-Forum: http://www.libreoffice-forum.de/viewtopic.php?f=12&t=16045