17+ Free and Open Source Reporting Tools

29047

Both free and open source reporting tools are listed here. The free versions are sometimes cut down versions of a commercial product, but some are fully functional.

Zoho Reports is an online reporting and business intelligence service that helps you easily analyze your business data, and create insightful reports & dashboards for informed decision-making. It allows you to create and share powerful reports. The free service limits users (2) and data, and has cut down functionality.

BIRT is an open source software project that provides the BIRT technology platform to create data visualizations and reports that can be embedded into rich client and web applications, especially those based on Java and Java EE. BIRT is a top-level software project within the Eclipse Foundation, an independent not-for-profit consortium of software industry vendors and an open source community. The project is sponsored by Actuate along with contributions from IBM, and Innovent Solutions.

DataVision is an Open Source reporting tool similar to Crystal Reports. Reports can be designed using a drag-and-drop GUI. They may be run, viewed, and printed from the application or exported as HTML, XML, PDF, Excel, LaTeX2e, DocBook, or tab- or comma-delimited text files. The output files produced by LaTeX2e and DocBook can in turn be used to produce PDF, text, HTML, PostScript, and more. DataVision is written in Java and runs almost anywhere. It can generate reports from databases or text data files. Any database with an available JDBC driver should work: Oracle, PostgreSQL, MySQL, Informix, hsqldb, Microsoft Access, Progress, and more. Columns read from text files can be separated by any character. Report descriptions are stored as XML files. This means you can not only use the DataVision GUI but you may also edit reports using your favorite text editor.

dmyReports is a dynamic report generator for MySQL, enabling end users to generate ad hock reports on the fly using web based interfaces. The users can select the required tables, fields and set conditions for generating the reports, these generated reports can then be exported to other formats.

fyiReporting RDL Project is a powerful report and charting system based on Report Definition Language (RDL). Tabular, free form, matrix, charts are fully supported. Report output may be displayed as HTML, PDF, Excel, RTF, XML, .Net Control, Web Archive, and to a printer. Libraries exist for use in ASP.NET, Windows .Net, and command line applications. A WYSIWYG designer allows you to create reports without knowledge of RDL. Wizards are available for creating new reports and for inserting new Tables, Matrixes, and Charts into existing reports.

i-net Clear Reports is a full-blown reporting solution completely coded in Java and also available for .NET. It comes with a free report designer program to custom design report template files and is Platform Independent. It provides Crystal Reports Support, Ad Hoc Reporting, Report Repository and free mobile repository apps for Android OS and iPhone, iPod touch with iO.

icCube community edition is a free end-to-end BI solution covering reporting and analytics. The reporting is designed for business users and facilitates exploration of OLAP data via reports, graphs and dashboards. Analytics include an ETL layer and support for multidimensional analysis and MDX+. XMLA is also supported for connection to other reporting tools (eg Excel), and support for R and Java means other forms of analysis can be carried out.

Intellicus is a comprehensive suite of all BI & Reporting capabilities; Ad-Hoc & Standard reports, Dashboards, ETL, OLAP and more. Visualizations provide contemporary style of web controls allowing users to derive meaningful value from their data. Generate, format and analyze multiple Ad-hoc reports with ease. Use desktop and web studio to design complex & pixel perfect reports. Visualize your business data in dashboards. Free cut down version and full enterprise version.

Jaspersoft Community addresses the creation of reports and charts. The Community edition essentially provides a reporting and charting environment with supporting infrastructure. The report designer supports charts, images, crosstabs and sub-reports for sophisticated report layouts. Interactive report viewing is a browser based report viewer with sorting, filtering and formatting of report snapshot views. A centralized repository provides infrastructure for reporting and stores user profiles, reports, dashboards and analytic views.

JMagallanes is an open source end user application for Olap and Dynamic Reports written in Java/J2EE. It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports.

reportserverbw

ReportServer provides an extremely flexible open source reporting and dashboard environment. It supports Eclipse Birt, JasperReports and SAP Crystal Reports reporting engines in addition to its own ad-hoc oriented reporting tools. The user interface is web based and it supports a wide range of admin tools. Central to ReportServer is the Dynamic List. This is the preferred method supporting a wide range of functions such as column selection, filtering, sorting, grouping, sub-totals, calculation and so on. JasperReports and Eclipse Birt tend to be used for ‘pixel perfect’ reporting with output to a pdf file. Finally Script Reports are used for particularly complex reports, and require programming skills to use. Interactive dashboards are supported and are generally constructed for items called dadgets (Dashboard Gadgets) – these can be anything from a report to an interactive HTML5 app.

MyNeoReport library is a free and easy to use way to design and add reports to .NET applications. It supports a WYSIWYG report designer and the libraries have to be distributed with the application.

Pentaho Community main components are the reporting tools, the data integration platform, the ROLAP analytics platform and the data mining tools. With the Pentaho-Report-Designer users can create report-definitions in a graphical environment. Reports are usually published to the Pentaho-Platform, which allows user to manage, run and schedule the reports created. Pentaho Data Integration (PDI, also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Pentaho Analysis consists of the Mondrian ROLAP engine, an analysis schema creation tool called Schema Workbench, and an analysis cube performance enhancement tool called Aggregation Designer. Pentaho Data Mining, based on Weka project, is a comprehensive set of tools for machine learning and data mining. Its broad suite of classification, regression, association rules, and clustering algorithms can be used to help users understand the business better and also be exploited to improve future performance through predictive analytics.

Report manager is a reporting application (Report Manager Designer) and a set of libraries and utilities to preview, export or print reports. Include native .Net and Delphi/C++Builder libraries, ActiveX component and also standard dynamic link library for use in any language like GNU C. The reporting engine includes a TCP enabled Report Server so thin clients can obtain reports processed in the server. Also a fully functional web report server application is available, generating Adobe PDF files on the fly.This is a true net and web report server with no license fees and multiprocessor support.

ReportMax is a free reporting tool for .NET Framework developers on Visual Studio.NET 2010 and 2012. It is easy to use and rich in features. Export reports to PDF, Excel or CSV. Build simple or complex reports with Data Fields, Images, Sub Reports, Charts, Calculated fields and more. Integrated from within Visual Studio for WinForms and WebForms projects. Easily customizable to connect to any data source. Runtime customization through Event handlers.

Seal Report is an Open Source for the Microsoft .Net Framework entirely written in C#. It supports dynamic SQL sources, native pivot tables, HTML 5 charts and Microsoft charts, HTML rendering using the Razor engine, web report server and task scheduler.

SpagoBI (free BI suite) is essentially a very large collection of open source software brought together to create a broad business intelligence capability. In fact it goes beyond the traditional notion of BI to embrace domains such as data mining and BPM. The main areas of functionality include Reporting, Multidimensional analysis, Charts, KPI, Interactive Cockpits, Ad-Hoc Reporting, Location Intelligence, Free Inquiry (Query by Example), Data Mining, Real Time Dashboards and Console, Collaboration, Office Automation, ETL, Mobile, Master Data Management.