BaseReportExtension

11 5

Generate with one click a report like a data sheet an invoice a letter... . Save/mail/ssh it (pdf or odt) somewhere. There are some striking features in this extension, that the built in reportbuilder does not offer. e.g.: Easily refer your query to the content of controls of a currently opened LO-Base-Form (e.g. the ID of the current record...) and others!

Project 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

Category/Categories

All modules, Writer Extension, Calc Extension, Base Extension

Current Release

BaseReportExtension - 0.1.0

Released Mar 09, 2016 — tested with:

LibreOffice 4.2, LibreOffice 5.1,

first release
More about this release…

basereportextension.oxt
File size: 17 kb
basereportextension.oxt
File size: 0 kb
quick_reference_basereportextension.odt
File size: 382 kb
schnelleinstieg_basereportextension.odt
File size: 407 kb

All Releases

Version

Released

Platform(s)

Compatibility

Description

License(s)

Status

0.1.1

  • All platforms
  • LibreOffice 3.4
  • LibreOffice 3.5
  • LibreOffice 4.2
  • LibreOffice 4.3
  • LibreOffice 4.4
  • LibreOffice 5.0
  • LibreOffice 5.1
  • LibreOffice 5.2
Bugfixes: 1 Translation to Italian (thx to charlie.it)
  • GNU-GPL-v3 (General Public License Version 3)
pre-release

0.1.0

Mar 09, 2016
    • LibreOffice 4.2
    • LibreOffice 5.1
    first release
    • GNU-GPL-v3+ (General Public License Version 3 and later)
    final

    Legal Disclaimer and Limitations for Downloads

    The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
    websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.

    Changes

    Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

    If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.