[libreoffice-users] Re: Fwd: Re: Base graphics/visualization

Le 23/06/2014 16:37, dave boland a écrit :

Hi David,


> Thank you so much for the info!  I have not spent much time on this, so
> I'm guessing that the plan (for me) is to use LO Base, then use one of
> these products to create the reports?  These report generators require
> either an ODBC or JDBC driver, so I'm hoping that Base has one or the
> other.  I did some Googling and it is not clear to me that it does.  So,
> does that mean that I should be focusing on PostgreSQL or MariaDB for
> example?

LO Base uses an embedded hsqldb engine by default (and an old version at
that), you can not access it directly from other applications even over
a JDBC driver.

There are several alternative strategies :

- you use Excel sheets, CSV files ot delimited text files as your data
source - I believe, from preliminary reading, that at least some of the
report designers I indicated allow this possibility ;

- you use a separate, or external, hsqldb instance - there are tutorials
for this out there on the web (look in the OOo forum), but I think that
this is also given a mention in the LO Base handbook - as the standalone
hsqldb package comes with a JDBC driver you could then use that in one
of the report designer software programs I indicated ;

- you use a known RDBMS - postgres, mysql, mariadb, firebird as a
separate backend for your data, and then attach to that using the
relevant ODBC or JDBC connector via the report designer software.

If you want to do the whole "LO-integrated" thing and have complex
reports including multivariable graphs, etc,  you will need to learn to
program LO via Basic or python, as I indicated in my first response.
That as such, would be no mean feat.


Alex




-- 
To unsubscribe e-mail to: users+unsubscribe@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