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