You are here

Comparison Matrix

Designer Components

Report Parameterization

Component Reuse

	BIRT™	Jaspersoft® Studio	Pentaho®
Open Source Website	eclipse.org/birt	community.jaspersoft.com	reporting.pentaho.com
Commercial Web Site	developer.actuate.com	jaspersoft.com/reporting	www.pentaho.com
License	Eclipse Public License (EPL)	JasperReports Lib LGPLV3 JasperSoft Studio EPL	Pentaho Reporting LGPL V2.1 (or later)
Report Designer	BIRT Report Designer 4.4.1 Built on Eclipse 4.4.1	JasperSoft Studio 6.0.1 Built on Eclipse 3.8.1	Pentaho Report Designer 5.2.0-GA
Designer Platforms	Windows, Linux, Mac OS X	Windows, Linux, Mac OS X	Windows, Linux, Mac OS X
Eclipse Plug-in Available
NetBeans Plug-in Available
Standalone Java Client Available
Design Paradigm	web page design frames tables lists	banded reports pixel positioning	banded reports pixel positioning
Report Compilation	Not required	Required	Not required
Report Format	XML (.RPTDESIGN)	Report design files (.JRXML) compile to Java Byte Code (.JASPER) Deploy/Run .JASPER files	XML Report file (.PRPT) is a ZIP of Design and other resources

Report Designer Components	BIRT™	Jaspersoft® Studio	Pentaho®
Common Report Designer Components: Report Editor, Palette, Data Explorer, Property Editor, Outline view of structure, Preview, Expression Builder, Report Problems, Chart Builder, Script Editor
Geometric shapes
Barcodes
Callouts / notes in design mode	in property editor	as report element
Table of Contents as a standard component		tricky - but functional
Index component (as a standard component)		tricky - but functional
Sub-reports
Side-by-side report components
Tables
Cross-tabs			Experimental
Horizontal Panning		Always scroll down even if crosstab expands side-to-side
Newspaper / multi-column layout
Hyperlinks within a report
Actionable charts (drill downs, hover over, hyperlinks)
Cascading Style Sheets (CSS controlled format)
Conditional Formatting

Data Sources	BIRT™	Jaspersoft® Studio	Pentaho®
Multiple data sources and queries per report		via sub-reports/charts	via sub-reports/charts
Support for joining multiple data sources in the Designer			pentaho data integration
Report can further manipulate query data re-sort filter group		Partial
Non JDBC Data Sources
Cassandra			PDI
CSV
Custom Data Adapter
EJB
Excel			PDI
Hadoop Hive
Hbase			PDI
Hibernate
Hadoop Hive
JNDI
JSON			PDI
Mondrian
MongoDB
Pentaho Data Integration
Pentaho Meta Data
POJO
Script	JavaScript		BeanShell Groovy JACL JavaScript Jython Netrexx XSLT
Web Services			PDI
XML
XML/A Server
JDBC Drivers	Generic JDBC Native Drivers are installed through UI	Generic JDBC Cloudscape Derby Firebird Hadoop Hive H2 HSQLDB IBM DB2 Inetdae7 Informix Ingres JDBC - ODBC Bridge MS SQLServer MariaDB Mondrian MySQL OLAP4J Oracle PostgreSQL SQLite Sybase Vertica	Generic JDBC AS/400 Apache Derby Borland Interbase Calpont InfiniDB Exasol 4 ExtenDB Firebird SQL Greenplum Gupta SQL Base H2 Hadoop Hive Hadoop Hive 2 Hypersonic IBM DB2 Infobright Informix Ingres Ingres VectorWise Intersystems Cache Kettle thin JDBC Driver KingbaseES LucidDB MS Access MS SQLServer MS SQL Server (Native) MaxDB (SAP DB) MonetDB MySQL Native Mondrian Neoview Netezza Oracle Oracle RDB PostgreSQL Remedy Action Request System SAP ERP System SQLite Sybase SybaseIQ Teradata UniVerse database Vertica Vertica 5+ dbase III/IV/5
Query Designer
Graphical Query Designer
Scripting	JavaScript Java Event Handlers	JavaScript Groovy Java	JavaScript Bean Script Framework (BSF) Bean-Script Host (BSH) Single Value Query Metadata data-source scripting extension

Output Formats	BIRT™	Jaspersoft® Studio	Pentaho®
Paginated HTML
Unpaginated HTML
XHTML
PDF
Excel (XLS 7 XLSX)
XML			via API
Plain Text
Rich Text (RTF)
Powerpoint (PPT)
CSV
Postscript
OpenOffice report types (document + spreadsheet)
Flash (SWF)
Custom Formats

Charts	BIRT™	Jaspersoft® Studio	Pentaho®
Chart Wizard
Chart Interactivity	mouse-over tool tips drill-through hyperlinks hide/show series etc.	hyperlinks
Chart themes
Precise control over format of all control elements
Common Chart Types: 2D, 3D, Pie, Multi-pie, Bar, Stacked Bar, Bar XY Line, Line XY Area, Area XY, Stacked Area, Bar Line, Bubble, Scatter Plot, Multi-Axis
Study Charts
Ring Chart
Tube chart
Cone chart
Pyramid
Time Series
Meter / Gauge
Waterfall
Step Area
Step
Difference
Radar / Spider
Thermometer
Candlestick / Stock Chart (High/Low)
Gantt
Survey Scale
Bar Sparkline	Via regular charts	Via regular charts
Line Sparkline	Via regular charts	Via regular charts
Pie Sparkline	Via regular charts	Via regular charts
Maps as a standard component
SVG (Vector Graphics) charts

Report Parameterization	BIRT™	Jaspersoft® Studio	Pentaho®
Static Parameters select parameter values from a hard-coded list of values
Dynamic Parameters users select parameters from a list of values that came from a database
Cascading parameters		Cascading input controls are report independent
Calendar date-picker for parameters of type date.
Can specify default values
Drop-down list boxes
Radio buttons
Check boxes
Combo Boxes

Aggregates - Summary Data	BIRT™	Jaspersoft® Studio	Pentaho®
Common Aggregations	Average Count Distinct Count First Is-Bottom-N Is-Botton-N-Percent Is-Top-N Is-Top-N-Percent Last Max Median Min Mode Moving Ave Percentile Percent-Rank Percent-Sum Quartile Rank Running Count Running Sum Standard Deviation Sum Variance Weighted Average	Average Count Distinct Count Sum First Lowest (Minimum) Highest (Maximum) Standard Deviation Variance System	Average Count Count by Page Group Count Sum Minimum Maximum Sum Quotient Sum Quotient Percent Calculation Count for Page Sum for Page Sum (Running) Count (Running) Group Count (Running) Count Distinct (Running) Average (Running) Minimum (Running) Maximum (Running) Percent of Total (Running)
User Defined Functions / Expressions	Java, JavaScript	Java, JavaScript or Groovy
User Defined Aggregates

Component Reuse	BIRT™	Jaspersoft® Studio	Pentaho®
Templates (custom report starting points)
User-defined Libraries (reusable report pieces )		not as refined	not as refined
Styles colors fonts borders margin
CSS

Trademarks	BIRT™	Jaspersoft® Studio	Pentaho®
Copyright© 2010-2015 Innovent Solutions Inc. All Rights Reserved.	BIRT is a registered trademark of the Eclipse Foundation Inc.	Jaspersoft Studio is a registered trademark of TIBCO.	Pentaho is a registered trademark of Pentaho Inc.