LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Any advice on software to generate online reports from a MYSQL database? (http://www.linuxquestions.org/questions/linux-software-2/any-advice-on-software-to-generate-online-reports-from-a-mysql-database-806275/)

will103 05-06-2010 05:51 AM

Any advice on software to generate online reports from a MYSQL database?
 
Hi,

I work for a not for profit research organisation that works in the clinical sector.

Currently I create summary reports for each of our studies that are then made available through our website. These reports are generated from data that is stored in a MYSQL database residing on a RHL Enterprise server. The data analysis however is performed using Microsoft Excel and then I use excel to create the final report pages, which are finally PDF'd. This approach has served me well however I am currently working to port the data analysis to R and have the analysis performed on the server side.

Now I have to consider how to generate reports. Here is my question. Could anyone recommend software that I could use to prepare and review reports generated directly from the data residing in the MYSQL database? I have no experience with this area as my background is in microbiology.

Any help would be great.

Cheers

will103

TB0ne 05-07-2010 03:29 PM

Quote:

Originally Posted by will103 (Post 3959090)
Hi,

I work for a not for profit research organisation that works in the clinical sector.

Currently I create summary reports for each of our studies that are then made available through our website. These reports are generated from data that is stored in a MYSQL database residing on a RHL Enterprise server. The data analysis however is performed using Microsoft Excel and then I use excel to create the final report pages, which are finally PDF'd. This approach has served me well however I am currently working to port the data analysis to R and have the analysis performed on the server side.

Now I have to consider how to generate reports. Here is my question. Could anyone recommend software that I could use to prepare and review reports generated directly from the data residing in the MYSQL database? I have no experience with this area as my background is in microbiology.

Any help would be great.
Cheers
will103

Why don't you use OpenOffice to pull the data right from MySQL directly, and save it as a PDF?? Don't need Windows or Excel for that, and you can command-line interface it (or script it), if you want.

If you want to shoot me a PM about your organization, maybe I can help you guys directly, if it's a good cause. :)


All times are GMT -5. The time now is 10:35 AM.