Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.


tJasperReportExec


  • Author: jlolling
  • Categories: Component
  • First revision date: 2012-06-04
  • Latest revision date: 2013-12-20
  • Compatible with: Data Integration releases 4.2.1, 4.2.2, 4.2.3, 4.2.4, 5.0.0, 5.0.0M1, 5.0.0M2, 5.0.0M3, 5.0.0M4, 5.0.0M5, 5.0.0RC1, 5.0.0RC2, 5.0.0RC3, 5.0.1, 5.0.2, 5.1.0, 5.1.0M1, 5.1.0M2, 5.1.0RC1, 5.1.1, 5.1.2, 5.1.3, 5.2.0, 5.2.0M1, 5.2.0M2, 5.2.0RC1, 5.2.0RC2, 5.2.1, 5.2.2, 5.2.3, 5.3.0, 5.3.0M1, 5.3.0M2, 5.3.0M3, 5.3.0RC2, 5.3.1, 5.4.0, 5.4.0M1, 5.4.0M2, 5.4.0M3, 5.4.0RC1, 5.4.1
  • Downloads: 618

About: Lets you compile, fill and export jasper reports without installed iReport or Jasper Server.
Any database connection can be used as data source.
You can set report parameters as well.
*New*: It use the JasperLibrary release 5.5.0
*New*: Advanced Options for output format PDF and XLS / XLSX (mostly reflecting the capabilities of iReport in its Export Options).
*New*: Improvements for font usage if font replacement takes place.
*New*: Number of created pages in the output document can retrieved as return value.
*New*: Groovy supported as language (current library)
*New*: Resource Bundles in the same directory as the JRXML files (e.g. for subreports) can be used.
*New*: Missing jasper files will be created automatically (also for sub reports, also if the .jrxml file is newer) This keeps the reports always up-to-date with the design files.
*New*: Can optional use XML files as data source
*New*: XML datasource can use the XPath query from the report
*New*: The Excel output format allows to use a template Excel file.
Because of a limitation of the component size, the necessary libraries for using barcodes are not included in the component. You can add these libraries to your job with tLoadLibrary.
For the Barbecue bar codes please load
babecue-1.5-beta1.jar
For the Barcode4J bar codes please load this bunch of jars:
barcode4j-2.1.jar
commons-cli-1.0.jar
commons-lang-1.0.jar
batik-bridge-1.6-1.jar
batik-gvt-1.6-1.jar
batik-awt-util-1.6-1.jar
batik-script-1.6-1.jar
batik-svg-dom-1.6-1.jar
batik-dom-1.6-1.jar
batik-css-1.6-1.jar
batik-xml-1.6-1.jar
batik-parser-1.6-1.jar
batik-ext-1.6-1.jar
xercesImpl-2.5.0.jar
xmlParserAPIs-2.0.2.jar
I suggest combining all into a single jar.
You will find all libraries in the current version of iReport.

Related links

Revision list

expand/collapse all

Revision 1.9 101 Downloads, Released on 2013-12-20
Download revision 1.9

Compatible with: 5.4.1, 5.4.0, 5.3.1, 5.3.0, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.0.2, 5.0.1

XML datasource can use the XPath query from the report.
Excel output format can use an existing Excel file to write into.

Revision 1.8 22 Downloads, Released on 2013-11-25
Download revision 1.8

Compatible with: 5.4.0, 5.3.1, 5.3.0, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Add the data source chooser and can use XML files as data source.
Latest JasperLibrary 5.5 used.

Revision 1.7 76 Downloads, Released on 2013-10-22
Download revision 1.7

Compatible with: 5.4.0, 5.4.0RC1, 5.3.1, 5.3.0, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Bug fixed: missing locale setting causes Java code errors
Improvements:
The component checks if the .jasper file is newer than the .jrxml file.
Missing jasper files will be created - also for sub reports.
Apache POI 3.10 beta2 will be used - brings more stability for Excel exports.
Latest Jasper API 5.2 used.

Revision 1.6 81 Downloads, Released on 2013-07-28
Download revision 1.6

Compatible with: 5.4.0RC1, 5.4.0M3, 5.4.0M2, 5.4.0M1, 5.3.1, 5.3.0, 5.2.3, 5.2.2, 5.2.1, 5.2.0, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.0.2, 5.0.1, 5.0.0

Resource bundles will be found in the same directory as the JRXML file.

Revision 1.5 120 Downloads, Released on 2013-02-15
Download revision 1.5

Compatible with: 5.3.1, 5.3.0, 5.3.0RC2, 5.3.0M3, 5.3.0M2, 5.3.0M1, 5.2.2, 5.2.1, 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.4, 4.2.3

Groovy Library updated to 1.7.6 to follow the embedded Groovy Enironment in Talend Studio

Revision 1.4 47 Downloads, Released on 2013-01-11
Download revision 1.4

Compatible with: 5.2.1, 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.3, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.4, 4.2.3

Bug fixed: Output type PDF needs always a filled password (even it is not needed)
* Groovy support enabled
* Advanced option to use always the Java compiler
* new JasperReport library version 5.0.1

Revision 1.3 41 Downloads, Released on 2012-12-18
Download revision 1.3

Compatible with: 5.2.1, 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.4, 4.2.3, 4.2.2, 4.2.1

Switched to the latest iReport library 5.0.0.
No functionality changed.

Revision 1.2 25 Downloads, Released on 2012-12-16
Download revision 1.2

Compatible with: 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.4, 4.2.3, 4.2.2, 4.2.1

Advancements:
Advanced Options for output formats PDF and XLS/XLSX (options depending on the output format).
Bug prevented: If as generation language in the reports is something other than Java, it will reset to Java to prevent the annoying Groovy error.
If fonts are missing, the font property bold and italic now will be applied to the replacement font (through a patch for the original Jasper library).

Revision 1.0 105 Downloads, Released on 2012-06-04
Download revision 1.0

Compatible with: 5.2.0, 5.2.0RC2, 5.2.0RC1, 5.2.0M2, 5.2.0M1, 5.1.2, 5.1.1, 5.1.0, 5.1.0RC1, 5.1.0M2, 5.1.0M1, 5.0.2, 5.0.1, 5.0.0, 5.0.0RC3, 5.0.0RC2, 5.0.0RC1, 5.0.0M5, 5.0.0M4, 5.0.0M3, 5.0.0M2, 5.0.0M1, 4.2.4, 4.2.3, 4.2.2

First tested version

Reviews (4)

 brilliant By ceesvl on December 30, 2013
what can i say, it works! would be nice if this could be a standard component
 Very useful! By Zoltan on October 28, 2013
If you need to generate reports made with iReport without too much fuss (only the .jrxml file is needed), it is perfect.
Thanks!
 Barcodes By Zoltan on October 23, 2013
Thanks for this useful component, mostly works as expected.
What I didn't succeeded to do is generating barcodes: it gave me an "Exception in thread "main" java.lang.Error: java.lang.Error: java.lang.NoClassDefFoundError: net/sourceforge/barbecue/BarcodeException" error.
I tried with barcode4j as well: similar error message.
In iReport preview is working, so I suspect some missing jars.
So, could this overcome somehow or what I'm doing wrong ? Or maybe, this component it wasn't supposed to generate barcodes (yet) ?
Regards

Solved By  on October 23, 2013
I\'ve put a tLibraryLoad component and loaded with it the corresponding barbecue .jar from iReport library folder and it works great . Thanks again for this great component.
 Engineer By Michel on July 29, 2013
Works fine for me, using bundles as well. Useful (for me) with simple apps, without need for deploying a server.
Thanks Jan
Regards
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
ParserRule

Tweets

1.0 scorreia 2013-11-20
18

get information from tweets.
Extract the date/time, user, hashtags, referenced users and urls from Twitter messages.

Regex

Only alphabetical characters not empty

1.0 dcortinovis 2013-06-19
62

Only alphabetical characters not empty.
And at least one (empty forbidden)

Indicator

EMail validation via mail server

5.4/5.3 mzhao 2013-06-03
517

This Java UDI check emails by sending a SMTP request to mail server. the code sample can be found at: http://www.rgagnon.com/javadetails/java-0452.html

Indicator

Frequency table of hours

2.0 scorreia 2013-04-25
355

This indicator helps to analyze the most frequent day hours that appear in date time columns.

Indicator

Sample Standard Deviation

1.1 scorreia 2013-04-25
268

This indicator computes the sample standard deviation of any numerical column

Indicator

Variance

1.1 scorreia 2013-04-25
249

This indicator computes the variance of numeric columns

Indicator

Trimmed

1.0 scorreia 2013-04-25
60

evaluate the number of data which are correctly trimmed

Indicator

Week Frequency

2.0 scorreia 2013-04-25
270

aggregates Date fields into weeks

Indicator

Duplicate Rows

2.0 scorreia 2013-04-25
774

this indicator counts the number of duplicate rows.
It's different from the system indicator called "duplicate count" because it counts the number of duplicate rows, not the number of duplicate values.

Indicator

Length Range Frequency

1.1 scorreia 2013-04-25
122

get length ranges of data.

group data according to their length range.
Ranges are the following:
data of length < 10
data of length < 20
data of length < 30
data of length >= 30
null data

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
559

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
376

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
705

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1109

Talendshop Demo (Demo Project)


93 ms