What I want to be able to do is (for now) have a pdf report that shows the statistics (records, averages, deviations) and charts that show up to four variables on the same axis. So the first question is can I do that with Base and Calc? This needs to be automated so that each day I run a report on the current data and get the report. I have no problem with using LO scripting language if needed, I just need to know that this can be done and generally how.
If the answer is that it can't be done, or would require extensive work, then waht are the alternatives? I looked at MariaDb, but did not see any built-in tools to do what I want. As I mentioned in the original post, I'm fine with using Base and an external program like R if it can produce waht I want. Dave, On Sun, Jun 22, 2014, at 02:25 PM, Tom Davies wrote: > Hi :) > As i understand it Calc and Writer are meant to be used for the Forms and > Reports. > > The in-built Forms&Reports are just to make Base more familiar for people > moving away from MS Access. > > Similarly Base also allows data tables to be kept internally in the > in-built back-end = just like MS Access. However, unlike Access, it is > really meant to be used with an external back-end and that could be on a > file-server or somewhere weird for security or to allow many different > machines to share the same data easily. About the 1st things Base asks > for > is where the data is. In your case you could set Base to use the > spreadsheet that you already have as it's back-end = then later on move > the > data to a different back-end program (such as MySql/MariaDb or Postgresql > or something) for greater stability. > > This way of modularising the database means that normal users see the > data > in a familiar program (eg Writer or Calc) without needing to learn all > about the complexities of database design. It means even normal users > can > use existing Forms and Reports to make new ones or to make minor > modifications without much risk to the database itself. > > Regards form > Tom :) > > > > > On 22 June 2014 18:28, anne-ology <lagin...@gmail.com> wrote: > > > I too am interested in knowing if & how LO can do graphs, et.al.. > > > > > > > > From: dave boland <dbola...@fastmail.fm> > > Date: Sat, Jun 21, 2014 at 10:42 PM > > Subject: [libreoffice-users">libreoffice-users] Base graphics/visualization > > To: users@global.libreoffice.org > > > > > > All, > > > > I have been collecting data for over a year in Calc. I will be rolling > > over to Base to use the data more effectively. 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, so my first question is what is the best way to create > > graphics in the Base reports? For example, imagine a report that shows > > the temperature highs and lows of a month, along with the average and > > devation along with a graph of the daily temperature. I can see that > > Calc can be used, but that approach seems like a lot of work, and may > > not be able to be extensively automated. 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. So I > > would like some comments of the best way forward for my project. > > > > Thanks, > > Dave > > -- > > dave boland > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@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 > > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 dbola...@fastmail.fm -- http://www.fastmail.fm - The professional email service -- To unsubscribe e-mail to: users+unsubscr...@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
