LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 12-18-2012, 11:30 AM   #1
jmvidalvia
LQ Newbie
 
Registered: Mar 2011
Posts: 23

Rep: Reputation: 0
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,
 
Old 12-19-2012, 08:57 AM   #2
thesnow
Member
 
Registered: Nov 2010
Location: Minneapolis, MN
Distribution: Ubuntu, Red Hat, Mint
Posts: 122

Rep: Reputation: 27
Openoffice/Libreoffice?
 
Old 12-19-2012, 02:20 PM   #3
jmvidalvia
LQ Newbie
 
Registered: Mar 2011
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by thesnow View Post
Openoffice/Libreoffice?
Sorry, I forgot to mention the server is running no GUI, so I amb searching for a CLI solution.
My fault.
 
Old 12-20-2012, 04:09 PM   #4
student04
Member
 
Registered: Jan 2004
Location: Georgia
Distribution: OS X, CentOS
Posts: 669

Rep: Reputation: 34
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.
 
Old 12-21-2012, 06:18 AM   #5
jmvidalvia
LQ Newbie
 
Registered: Mar 2011
Posts: 23

Original Poster
Rep: Reputation: 0
Quote:
Originally Posted by student04 View Post
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!
 
  


Reply

Tags
mysql, reports


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weblizer - Making reports on virtual servers and moving them to view on the net kitek Linux - Software 1 04-18-2011 03:34 PM
Any advice on software to generate online reports from a MYSQL database? will103 Linux - Software 1 05-07-2010 03:29 PM
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 08:36 PM
phpinfo() reports wrong mysql version shambler Linux - Server 4 01-22-2007 06:18 PM
MYSQL Reports Ronw Linux - Software 7 01-20-2004 03:44 PM


All times are GMT -5. The time now is 04:52 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration