User Tools

Site Tools


exchange:reporting:reporting_project

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
exchange:reporting:reporting_project [2010/03/08 04:08]
ben
exchange:reporting:reporting_project [2010/04/28 05:29] (current)
ben
Line 115: Line 115:
  
 Some very useful reporting queries are on the **[[exchange:​reporting_project:​database_queries|Useful Queries]]** page. Some very useful reporting queries are on the **[[exchange:​reporting_project:​database_queries|Useful Queries]]** page.
 +====== OpenRPT Notes ======
 +To allow OpenRPT to save reports to the database:
 +<​code>​
 +create table report (  report_id serial primary key,  report_name text,  report_descrip text,  report_grade integer not null, report_source text  );
 +</​code>​
 +
 +Also need to check out:
 +
 +http://​www.eclipse.org/​birt/​phoenix/​intro/​
 +
 +http://​oreports.com/​
 +
 +http://​www.pentaho.com/​
 +
 +http://​www.jaspersoft.com/​ - http://​jasperforge.org/​
 +
 +Setup for datavision - copy mysql connector J .jar file into lib directory, setup connection like:
 +
 +{{:​exchange:​reporting:​datavision_connection_info.png|}}
 +
exchange/reporting/reporting_project.1268039297.txt.gz ยท Last modified: 2010/03/08 04:08 by ben