JasperReports

Infobox Software
name = JasperReports
latest_release_version = 3.0.1
latest_release_date = release date and age|2008|8|12
developer = JasperSoft
operating_system = Cross-platform
language = Multilingual
genre = Enterprise Reporting
license = GNU Lesser General Public License
website = [http://www.jasperforge.org/jasperreports JasperReports]

JasperReports is an open source Java reporting tool that can write to screen, to a printer or into PDF, HTML, Microsoft Excel, RTF, ODT, Comma-separated values and XML files.

It can be used in Java-enabled applications, including J2EE or Web applications, to generate dynamic content. It reads its instructions from an XML or .jasper file.

Features

JasperReports is an open source reporting library that can be embedded into any Java application. Features include:

* PDF, HTML, Microsoft Excel, RTF, ODT, CSV and XML files. The engine allows report definitions to include charts, with the rendering provided by the JFreeChart library which supports many chart layouts, such as Pie, Bar, Stacked Bar, Line, Area, Scatter Plot, Bubble, and Time series.

* Multiple sources can be merged together.cite web|url=http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-opensourceprofile.html|title=Reports made easy with JasperReports|work=JavaWorld.com|author=Erik Swenson|date= 2002-09-20|accessdate=2007-01-11] The data can be retrieved from defined data sources such as JDBC, CALS Table Models, JavaBeans, EJBQL, XML, Hibernate, and Comma-separated values, and additional data sources can be added to the JasperReports framework by plugging in a custom "JRQueryExecuter". An extension is available to use Oracle PL/SQL stored procedures as a data source. [ [http://www.jasperforge.org/sf/projects/oraclestoredprocedures OracleStoredProcedures sub-project] ]

* Scriptlets may accompany the report definition, which the report definition can invoke at any point to perform additional processing. The scriptlet is built using Java, and has many hooks that can be invoked before or after stages of the report generation, such as Report, Page, Column or Group.

* Sub-reportscite journal | url = http://www.oio.de/public/opensource/JS_01_07_Reporting.pdf | title = Freie Reporting-Tools im Vergleich | author = Christian Brell, Tobias Kieninger | work = Orientations in Objects | journal = JavaSpektrum | date = January 2007 | accessdate = 2007-07-14 |format=PDF]

For users with more sophisticated report management requirements, reports designed for JasperReports can be easily imported into the JasperServer - the interactive report server. [http://jasperforge.org/jaspersoft/opensource/business_intelligence/jasperserver/ JasperServer Project Page]

JasperSoft

Infobox Company
name = JasperSoft
company_
type = Software engineering
foundation = 2005
location_city =
location_country =
location =
locations =
key_people = Paul Doscher, founder
area_served =
industry = business intelligence
products = JasperSoft BI [cite web | url = http://weblog.infoworld.com/openresource/archives/2007/07/jaspersoft_bi_s.html | title = JasperSoft BI Suite 2.0 | date = July 23, 2007 | author = Zack Urlocker | work = InfoWorld weblog | accessdate = 2007-07-30 ]
services =
revenue =
operating_income =
net_income =
num_employees =
parent =
divisions =
subsid =
slogan =
homepage = [http://www.jaspersoft.com jaspersoft.com]
dissolved =
footnotes =
intl =

Teodor Danciu began work on JasperReports [http://jasperforge.org/jaspersoft/opensource/business_intelligence/jasperreports/ JasperReports Project Page] in June 2001, the sf.net project was registered in September 2001cite web|url=http://rootprompt.org/article.php3?article=8332|title=An Interview with Teodor Danciu of JasperReports|work=RootPrompt|date=February 16, 2005|accessdate=2007-01-11] and JasperReports 0.1.5 was released on November 3rd 2001 [ [http://freshmeat.net/projects/jasperreports/#comment-12052 freshmeat.net: Project details for JasperReports:Comment] ] .

JasperReports Version 1.0 was released on July 21, 2005 [cite web|url=http://www.theserverside.com/news/thread.tss?thread_id=35381|title=JasperReports 1.0 released|work=theserverside|accessdate=2007-01-11] .

The code was originally licenced under a copyleft JasperReports License and later moved to LGPL.

In April 2005, Paul Doscher, formerly of Business Objects, formed JasperSoft by acquiring the copyright of JasperReports from Teodor Danciu [cite web|url=http://blogs.zdnet.com/BTL/index.php?p=1306|title=Can an open source project get acquired? One just did.|work=zdnet blogs|date= April 25, 2005|accessdate=2006-12-28] , hired him, and as of July 2005 had raised $23.3m in capital [cite news|url=http://www.cbronline.com/article_news.asp?guid=63F53188-256B-44D9-A48A-894F0635FB35|title=Open source BI grabs more VC attention|work=Computer Business Review|date= 21 July 2005|accessdate=2007-01-11] . As a result, JasperSoft is able to provide commercial software around the JasperReports product, and negotiate contracts with software developers that wish to embed the JasperReports engine into a closed source product.

JasperSoft's main related product is JasperServer [http://jasperforge.org/jaspersoft/opensource/business_intelligence/jasperserver/ JasperServer Project Page] , a Java EE web application that provides advanced report server capabilities such as report scheduling and permissions. It is available under an open source license for use in conjunction with open source infrastructure such as MySQL and JBoss, or a commercial license for enterprise deployments involving commercial databases and application servers.

JasperSoft has leveraged their JasperServer product to enter the OnDemand BI space with a reporting platform for salesforce.com, Jasper4Salesforce. [http://www.jaspersoft.com/JasperSoft_Jasper4Salesforce.html Jasper4Salesforce Product Page] Jasper4Salesforce provides BI around data stored within salesforce.com. Jasper4Salesforce is marketed through salesforce.com's AppExchange application marketplace. [http://www.salesforce.com/appexchange/detail_overview.jsp?id=a0330000002PvWuAAK Jasper4Salesforce AppExchange Marketplace Page] JasperSoft is a gold partner with MySQL [cite web|url=http://solutions.mysql.com/solutions/partner.php?partner=1102|title=MySQL AB :: Jaspersoft|date=2006-06-27|accessdate=2007-01-11] , and JasperReports was included in the PostgreSQL distribution "Bizgres" version 0.7. [cite web | url = http://www.bizgres.org/articles.php?id=9 | title = Bizgres 0.7 Released | date = August 3, 2005 | work = bizgres.org |accessdate=2007-01-11] [cite news|url=http://www.regdeveloper.co.uk/2005/08/03/postgre_bi/|title=Bizgres gets down to business with open source BI stack|author=Gavin Clarke|work=RegDeveloper|date= 3 August 2005|accessdate=2007-01-11 ] [cite web|url=http://www.osdbmigration.org/misc/case_datawarehouse.pdf|author=Jutta Horstmann|title=Migrating to Open Source Databases: The Data Warehouse Case Study|date=November 10, 2005|accessdate=2007-01-11|format=PDF]

JRXML

JasperReports are defined in an XML file format, called JRXML, which can be hand-coded, generated, or designed using a tool. The file format is defined by a Document Type Definition (DTD), providing limited interoperability. [cite web|url=http://ensode.net/jasperreports_intro.html|title=JasperReports Tutorial/Getting Started Guide|author=David R. Heffelfinger|accessdate=2007-01-11]

The main difference between using XML and a .jasper file is that the XML file should be compiled in runtime using the JasperCompileManager class.

Third party tools

There are many tools providing JasperReport [http://jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/ JasperReports Project Page] capabilities:

* iReport, [http://jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/ iReport Project Page] an open source standalone graphical program that provides report designer capabilities, and is able to run reports using all data source supported by the JasperReports engine. iReport is actively maintained by JasperSoft. [cite web|url=http://www.ensode.net/ireport_review.html|title=Review: iReport Designer for JasperReports|author=David R. Heffelfinger|accessdate=2007-01-11]
* SWTJasperViewer, an open source reusable component that can be embedded in any SWT/JFace application such as Eclipse. [cite web|url=http://eclipse-plugins.info/eclipse/plugin_details.jsp?id=884|title=SWTJasperViewer: plugin details|work=Eclipse-Plugins.info|date=25 November 2004|accessdate=2007-01-11]
* five Eclipse plug-ins that provide report designing and debugging capabilities, including:
** an open source iReport plugin for Eclipse
** a commercial Eclipse plug-in called JasperAssistant. [cite web|url=http://www.ciol.com/content/search/showarticle1.asp?artid=84612|title=Generating reports with Jasper Reports|author=Anadi Misra|date=May 31, 2006|accessdate=2007-01-11] The JasperAssistant plug-in is built using SWTJasperViewer. [cite web|url=http://eclipse-plugins.info/eclipse/plugin_details.jsp?id=507|title= JasperAssistant: Plugin details|work=Eclipse-Plugins.info|date=12 December 2006|accessdate=2007-01-11]
* [http://www.jasperforge.org/sf/projects/webreportbuilder WebReportBuilder] , an open source Java J2EE web application that allows web based developers and non developers to create basic and advanced Reports based on JasperReports to be used as a Web Report Server.
* OpenReports, a Java EE web application that provides advanced report server capabilities with support for four open source reporting engines: JasperReports, JFreeReport, JXLS, and Eclipse BIRT. [cite web|url=http://www.brianburridge.com/2005/04/08/jasper-and-open-reports/|title=JasperReports and OpenReports|author=Brian Burridge|date= April 8, 2005|accessdate=2007-01-11]
* JasperTags [http://jaspertags.org] , a JSP tag library for easy inclusion of reports in web applications.

IDE Integration

Many prominent Java IDEs provide instructions for users wishing to integrate JasperReports into a project. [ [http://jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/ JasperReports Project Page] ]
* IBM Websphere Studio Application Developer [cite web|url=http://www-128.ibm.com/developerworks/websphere/library/techarticles/0411_olivieri/0411_olivieri.html|title=Generating online reports using JasperReports and WebSphere Studio|author=Ricardo Olivieri|work=IBM developerWorks|date=17 November 2004|accessdate=2007-01-11]
* NetBeans [cite web|url=http://developers.sun.com/prodtech/javatools/jsenterprise/reference/techart/jse8/jasper_reports.html|title=http://developers.sun.com/prodtech/javatools/jsenterprise/reference/techart/jse8/jasper_reports.html
title=Integrating and Using JasperReports in NetBeans|author=Craig Conover and Marina Sum|work=Sun Developer Network|date=September 1, 2006|accessdate=2007-01-11]
** JasperReports Visual Designer for NetBeans - [https://jarvis.dev.java.net/]
*Eclipse

Further reading

*
*

Code refactoring

JasperReports has been the focus of several academic papers on code refactoring
*
*
*
*
*
*

References

Further reading

*

External links

* [http://jasperforge.org/jaspersoft/opensource/business_intelligence/jasperreports/ JasperForge.org JasperReports Project Landing Page]
* [http://jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/ JasperForge.org iReport Project Landing Page]
* [http://jasperforge.org/sf/projects/jasperreports JasperReports JasperForge.org Project Page]
* [http://www.jasperforge.org/ JasperForge.org (Home Page)]
* [http://dynamicjasper.sourceforge.net/ DynamicJasper Open Source extension for dynamic columns reports]
* [http://www.brianburridge.com/tag/jasper-reports/ JasperReports: Tips and Information]
* [http://products.databasejournal.com/dbtools/dev/1123257918.html JasperReports] on Database Journal
* [http://jasperforge.org/sf/projects/webreportbuilder WebReportBuilder (JasperForge.org Project Page)]
* [http://www.jasper4salesforce.com Jasper4Salesforce (Product Page)]