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.
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
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.
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.
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.
For unsubscribe instructions e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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