Alex,
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?
Thanks,
Dave
On Mon, Jun 23, 2014, at 09:11 AM, Alex Thurgood wrote:
Le 23/06/2014 04:53, dave boland a écrit :
Hi Dave,
So, I'm back to where we started. I have ver. 4.1.3.2, and I know
there is a new version in the works for later July. Will I be able to
use the report facility to build charts based on the data form the
query? If so, how?
Forget using Base/Calc to build complex charts from your data, unless
you have some serious time and coding skills to hand to be able to drive
all of this via scripts and one of LO's UNO interfaces (Python, Basic,
JS, Beanshell, etc).
Look for another reporting solution that integrates chart handling in a
(seemingly) more reliable way :
JReport (very similar to what appears to be available in Base, but
organised in a better way, IMHO :
http://www.jinfonet.com/manualpro/tutorial/index.htm
Pentaho Business Reports (this is the superset of tools to JFreeReport,
the reporting tool used by LO Base)
http://wiki.pentaho.com/display/Reporting/Pentaho+Reporting+-+User+Guide+for+Report+Designer
iReport / JasperReports
http://sourceforge.net/p/ireport/wiki/Home/
http://community.jaspersoft.com/wiki/ireport-designer-getting-started
The latter enables you to export your report to a multitude of formats,
including ODF, and PDF.
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
--
dave boland
dboland9@fastmail.fm
--
http://www.fastmail.fm - Access all of your messages and folders
wherever you are
--
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
Context
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.