Expertise

 
BIRT™
JasperReports™
Pentaho™
Open Source Website  eclipse.org/birt  jasperforge.com  reporting.pentaho.com
Commercial Web Site  birt-exchange.com  jaspersoft.com/reporting  www.pentaho.com
License  Eclipse Public License  JasperReports LGPL V3
iReport GPL V3
Pentaho Reporting LGPL V2.1 (or later)
Report Designer  BIRT Report Designer 3.7  Jaspersoft iReport 4.5.0 Pentaho Report Designer 3.8.3-GA
Designer Platforms  Windows 32-bit & Linux
OS X is unofficial
 Windows 64-bit & 32-bit Linux Mac OS X Windows Linux Mac OS X
Eclipse Plug-in Available  
Note that the Pentaho Design Studio is not a report designer even though it is an Eclipse plug-in.
NetBeans Plug-in Available  
For NetBeans IDE 6.5.x and later
Standalone Java Client Available  
JasperStudio 1.0.1
rewrite of iReport for Eclipse
Design Paradigm  web page design
frames tables lists
 banded reports pixel positioning  Note that the Pentaho Design Studio is not a report designer even though it is an Eclipse plug-in.
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
Index component (as a standard component)
Sub-reports
Side-by-side report components
Tables
Cross-tabs  
Experimental
(since Pentaho 3.5)
Horizontal Panning  
Always scroll down even if crosstab expands side-to-side
Newspaper / multi-column layout
Hyperlinks within a report
Actionable charts  
drill-down hyperlinks mouse-overs
 
Partial
Cascading Style Sheets (CSS controlled format)
Conditional Formatting
 Data Sources
Multiple data sources and queries per report  
plus support for joining them
 
via sub-reports
 
via sub-reports
or charts
Support for joining multiple data sources in the Designer
Report can further manipulate query data
re-sort filter group
 
Partial
Data Sources Type (native JDBC below)  
  • Generic JDBC
  • XML
  • Web Services
  • Flat files:
  • CSV SSV PSV TSV
  • Hadoop Hive
  • OLAP MDX
  • Scripted:
    • POJO
    • EJB
    • Hibernate
    • XML Stream
 
  • Generic JDBC
  • NetBeans JDBC
  • XML
  • JavaBeans
  • CSV File
  • Text File
  • Microsoft Excel (.xlsx & .xls)
  • Hibernate HSQL
  • Spring Hibernate
  • EJBQL
  • XML/A Server
  • Mondrian OLAP
  • POJOs
  • Custom
  • Remote XML files
  • JSON
  • Hadoop Hive
 
  • Generic JDBC
  • XML
  • Manual Table
  • OLAP
  • Pentaho Analysis
  • XML/A via OLAP4j
  • Pentaho Metadata
  • Pentaho Data Integration
  • Scripted:
    • POJO
    • EJB
    • Hibernate
    • JMI
Native JDBC Drivers  
  • requires user to locate and install
 
  • MS SQLServer
  • MySQL
  • Oracle
  • PostgreSQL
  • Sybase
  • Vertica
 
  • AS/400
  • Apache Derby
  • Borland Interbase
  • Calpont InfiniDB
  • ExtenDB
  • Firebird SQL
  • Greenplum
  • Gupta SQL Base
  • H2
  • Hypersonic
  • IBM DB2
  • Infobright
  • Informix
  • Ingres
  • Ingres VectorWise
  • Intersystems Cache
  • KingbaseES
  • LucidDB
  • MS Access
  • MS SQLServer
  • MS SQL Server (Native)
  • MaxDB (SAP DB)
  • MonetDB
  • MySQL
  • Neoview
  • Netezza
  • Oracle
  • Oracle RDB
  • PostgreSQL
  • Remedy Action Request System
  • SAP ERP System
  • SQLite
  • SybaseIQ
  • Teradata
  • UniVerse database
  • Vertica
  • dbase III/IV/5
Query Designer
Graphical Query Designer  
special type of data source
 
(SQL Leonardo)
 (SQL-Leonardo)
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  
Experimental
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
Designer provides  
Partial
 Component Reuse
Templates
(custom report starting points)
User-defined Libraries
(reusable report pieces )
Styles
  • colors
  • fonts
  • borders
  • margin
CSS
 Trademarks
Copyright© 2010-2012 Innovent Solutions Inc. All Rights Reserved.  BIRT is a registered trademark of the Eclipse Foundation Inc.  JasperReports is a registered trademark of Jaspersoft Corporation.  Pentaho is a registered trademark of Pentaho Inc.