Opensource reporting services?

Question

Hi,

Are there any free and opensource reporting services which we can deploy in a web server, and which wouldn't require any licensing. Actually I'd be interested in the whole framework/toolkit, report designing, viewing, and hosting. It should be able to pull data from mssql database servers.

Answer 1

The open source Pentaho suite includes a report server. I believe it's Java-based, so will connect to any datasource for which JDBC drivers are available (including SQL Server).

SQL Express with Advanced Services includes a free version of SQL Server Reporting Services.

Answer 2

Check the JasperForge projects (JasperReports, iReports, etc) at http://jasperforge.org/ I think is one of the most used plataform for reporting in Java projects.

Also check this comprehensive list of Java open source resources for reporting. Includes short descriptions for

• JFreeChart
• BIRT
• jCharts
• Cewolf
• JCCKit
• JChart2d
• DocumentBurster
• SWTJasperViewer
• iReport
• JasperReports
• JOpenChart
• Chart2D
• JFreeReport
• Datavision
• ART
• Open Reports
• Pentaho - Business Intelligence
• JMagallanes
• FreeReportBuilder
• OpenReports
• OpenI
• JGraphT
• prefuse
• QN Plot

Answer 3

but how do we know which is more better... there is no comparison available