LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Making reports from MySQL and R data (http://www.linuxquestions.org/questions/linux-software-2/making-reports-from-mysql-and-r-data-4175441993/)

jmvidalvia 12-18-2012 11:30 AM

Making reports from MySQL and R data
 
Hi!
I use to get my queries in plain text files form MySQL or R, and quite often find myself in the need of making a decent report with the output.
Till today, I buid a Latex document and import the data to it, after configuring the suitable table, but find the work quite hard as I have to exactly fit the data into the said table.
Is there any other suitable tool to "easily" build reports mixing charts and tables from pre-prepared data?
Thanks,

thesnow 12-19-2012 08:57 AM

Openoffice/Libreoffice?

jmvidalvia 12-19-2012 02:20 PM

Quote:

Originally Posted by thesnow (Post 4852885)
Openoffice/Libreoffice?

Sorry, I forgot to mention the server is running no GUI, so I amb searching for a CLI solution.
My fault.

student04 12-20-2012 04:09 PM

What do you mean by "fit the data into the table" and "import the data to it"? I don't quite understand exactly what you are trying to do. Is your data already in MySQL and you want to export it to some file that R can manipulate? What are you doing now that is difficult? "Table" in your context isn't clear, whether it applies to MySQL, a latex table, or a table in R.

R can make plots from data. I use it for my work when writing papers.

jmvidalvia 12-21-2012 06:18 AM

Quote:

Originally Posted by student04 (Post 4853933)
What do you mean by "fit the data into the table" and "import the data to it"? I don't quite understand exactly what you are trying to do. Is your data already in MySQL and you want to export it to some file that R can manipulate? What are you doing now that is difficult? "Table" in your context isn't clear, whether it applies to MySQL, a latex table, or a table in R.

R can make plots from data. I use it for my work when writing papers.

Sorry for not beeing clear enough.
Will try to explain my need a bit better:
1. The Company I am working for has an ordinary ERP.
2. I extract all the positions delivered to customers in plain text.
3. I import the into MysQL, where I have some other tables with information regarding the sector of the customers, the family of products, etc.
4. I wote some queries, where I can get info about sales per region, sales per customer, etc etc
5. I export this queries in plain text format.
5. One of the queries is feeding R, where I draw a barchart of sales per month, regresion line, etc.
6. Finally, I prepared a LaTeX report that automatically gets the tables I exported from MySQL and the charts I got with R, and puts everyting together into a pdf.
Everything is scripted and automatic.
My question was: once I have the plain text tables and some charts, is there any better tool than LaTeX to put them together and create a nice pdf?
Thanks!


All times are GMT -5. The time now is 12:49 AM.