> 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: [email protected] 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
