Expertise

 
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
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
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
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
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
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
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
Templates
(custom report starting points)
User-defined Libraries
(reusable report pieces )

not as refined

not as refined
Styles
  • colors
  • fonts
  • borders
  • margin
CSS
 Trademarks
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.