Quote:
Originally Posted by will103
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.