Re: [libreoffice-users] Base graphics/visualization

> I have been collecting data for over a year in Calc.  I will be
> rolling over to Base to use the data more effectively.

One word of free advice: Avoid the "built in" database engine. Use an
external client-server RDBMS. It's so much safer. The driver for
PostgreSQL comes with LO. Embedded database files can too easily get
corrupted. That's not necessarily a problem specific to LO and/OR
HSQLDB. 

> However, Base has some drawbacks that I need some help with.  I have
> been using the Calc data to create graphs of some of the data.  I did
> not see a way to do this in Base directly,

You can still pull the data from the database into Calc.

https://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=18511

> so my first question is what is the best way to create graphics in
> the Base reports? 

Don't know about the report builder, never used it.

> I'm also aware of a data visualization program called R. I have not
> used R, and don't know if it will integrate with Base, or replace the
> Base report altogehter.

R is a statistical analysis software, implemented as a "fork" of the
commercial S+. It should at least integrate with LO through Python,
since Python has an interface module RPy. Or someone may have written a
plugin that allows to use. Oh, here it is:

http://tinyurl.com/na2fatp

BTW: For anything that's not directly implementable using Calc
functions and plugins, Python is a great scripting language for
"data crunching" anyway, so learning it can be useful. It's not just for
reporting, and not just with LO and PostgreSQL. 

Sincerely,

Wolfgang

-- 
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