[libreoffice-users] Re: How get LibreO-Base working?

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: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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