Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.
First draft of the live reporting sqldatamart is up on my github . There are instructions in the readme if someone wants to try it out.
The OpenClinica live server can be postgres 8.4. The reporting server must be postgres 9.3. Everything happens in postgres now, so no more Access required (unless using it as a study client). A full refresh on an instance with 400k item_data rows takes about 2 minutes.
Also, Linas sent some updates for his powershell/xsl files, to deal with Unicode characters in R. The commit can be viewed at .