Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Am 01.02.2012 08:43, Alex Thurgood wrote:

And I would state that that is an "unusual" user setup. The user here
wants a relational database with subforms and reports and does not want
to use mysql, so where does that leave him her with regard to Base -
IMO, with HSQLDB, the stock db engine provided with LO. For that, you
need a JRE/JDK.

And we all know why one must not use the built-in HSQLDB for productive databases. The so called "Base document" with its built-in HSQLDB is the most horrible face-palm feature since OOo 2.0.

And Calc for reports is OK, much as is Writer, but for anything a bit
more than a simple report, the user will have to deal with not only the
idiosyncrasies of the respective tool used for creating the report,
plus, in general, learn to use macros. The whole benefit of having a
specific reporting tool (the Java based ORB extension) is that this is
suppose to ease that pain.

I hardly ever use any macros at all. I simply use Calc's database ranges with registered data sources as they are intended to be used. Without a single line of macro code I open a document through a hyperlink button on a form, confirm a dialog to refresh unsaved import ranges and get a brand new collection of nicely formatted reports and charts.

Personally, I'd love to be able to say, you get a great and easy to use
db reporting engine without Java in LO, but that is simply not the case
at the moment.

Calc provides all kinds of calculations and charting based on dynamically changing import ranges (much better than with spreadsheet data). Data pilots provide a second type of database report. Things do simply *work* with Calc as report engine. If things really *work*, I don't care too much about the perfect look.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.