JasperReports Ultimate Guide - Samples - Schema - Configuration - Functions - FAQ - API (Javadoc)

JasperReports - Scriptlet Sample (version 6.21.0)


Shows how the scriptlets could be used to manipulate data during report filling.

Download All Sample Source Files
Browse Sample Source Files on Git


Main Features in This Sample

Scriptlets

Alternate Row Colors In The Detail Section


top

ScriptletsDocumented by Luke Shannon


Description / Goal
How to perform custom calculation and tailor the report filling process using report scriptlets implementations.

Since
0.2.5


There are situations when a calculation is required during the report filling stage that is not included in JasperReports provided calculations.
Examples of this may be complex String manipulations, building of Maps or Lists of objects in memory or manipulations of dates using 3rd party Java APIs.
Luckily JasperReports provides us with a simple and powerful means of doing this with Scriptlets.

What is a Scriptlet?

A Script is a Java Class that extends one of the two following classes:

The sample extends the JRDefaultScriptlet. The difference between the two is with JRAbstractScriptlet a developer must implement all the abstract methods.
By extending JRDefaultScriptlet a developer is only required to implement that methods he/she needs for their project.
Once the Scriptlet has been referenced in the report, during the Filling stage of the Report Life Cycle, the JasperReports API will ensure to call the appropriate methods within the Scriptlet.
It is within these methods you will place your own logic to manipulate data in the report.
Before we discuss more what these methods do lets discuss how to run this sample.

Running the Sample

Prerequisites
Ant is required. By running 'ant --version' you will be able to check if ant is set up on your system (at least version 1.5 is required):
    
    C:\>ant -version Apache Ant version 1.8.0 compiled on February 1 2010
	
	
You can obtain ant from http://ant.apache.org/, instructions for installation can be found there as well.

Starting the Data Source
In a command prompt/terminal window browse to the demo/hsqldb folder of the JasperReports source and run the command 'ant runServer'.
Leave window/terminal running (see below for sample output).
    
    C:\js-workspace\jasperreports\demo\hsqldb>ant runServer
	Buildfile: C:\js-workspace\jasperreports\demo\hsqldb\build.xml

	runServer:
     [java] [Server@83cc67]: [Thread[main,5,main]]: checkRunning(false) entered
     [java] [Server@83cc67]: [Thread[main,5,main]]: checkRunning(false) exited
     [java] [Server@83cc67]: Startup sequence initiated from main() method
     [java] [Server@83cc67]: Loaded properties from [C:\js-workspace\jasperreports\demo\hsqldb\server.properties]
     [java] [Server@83cc67]: Initiating startup sequence...
     [java] [Server@83cc67]: Server socket opened successfully in 19 ms.
     [java] [Server@83cc67]: Database [index=0, id=0, db=file:test, alias=] opened sucessfully in 1104 ms.
     [java] [Server@83cc67]: Startup sequence completed in 1125 ms.
     [java] [Server@83cc67]: 2010-03-10 11:32:30.423 HSQLDB server 1.8.0 is online
     [java] [Server@83cc67]: To close normally, connect and execute SHUTDOWN SQL
     [java] [Server@83cc67]: From command line, use [Ctrl]+[C] to abort abruptly
    
	
Generating the Report
Open up a separate command prompt/terminal window and browse to the root directory of the sample.
By running 'ant -p' you will be presented with a list of options available. Of interest in this list is all the exporters available for testing.
Each export type will generate a output type in the build/report folder.
By running the command 'ant' the following actions will be performed:
  • All java code will be compiled to produce class files.
  • JRXML fills will be compiled by JasperReports to produce a .jasper file (this is a serialized version of a JasperReports object).
  • The report will be filled with data and the resulting object, JasperPrint, will be serialized to the file system as a .jrprint.
  • All the exporters the sample is configured to test will run.

You can now run 'ant view' to see a version of the report in the JasperViewer (a Swing report viewer contained in the JasperReports package which can be used to view a .jrprint object).
Each of the these task can be ran separately as well:
  • ant clean - removes all generated files.
  • ant javac - compiles all java code, this should be done before running further tasks.
  • ant compile - compiles the JRXML generating a .jasper file.
  • ant fill - fills the report with data, some reports use the empty data source, others use the HSQL DB and other an inline data source. A .jrprint object is generated in this step.
  • ant view - opens the report in the JasperViewer
  • ant pdf - generates a PDF (other exporters are available run 'ant -p' for a full list)
Note: All generated files can be found in build/reports.
You now have a working version of the report you can review and tweak to learn more about Scriptlets.

What does a Scriptlet do?

A Scriptlet allows the developer to obtain the values of Fields, Variables and Parameters from the report during specific events in the Filling stage of the Report Life Cycle.
It also allows you to set data in the report as it executes its Fill Cycle. We will discuss this more in the sections below.
If you look at Scriptlet.java within this sample you will see all possible methods have been implemented. Most contain output statements.
By running the sample from the command line or in iReport you will see the outputs of these statements along with the generated report itself.
The method afterGroupInit contains all the most interesting logic and will be the main focus of our discussion.

Working with Report Data
A developer can read the values from Fields (which map to the data source), Values and Parameters from the report into variables within the Scriptlet.
Examples of this can be seen in afterGroupInit method. In this method we obtain the value of a variable and a field from the report as it is filling:
    
    String allCities = (String)this.getVariableValue("AllCities");
	String city = (String)this.getFieldValue("City");
    
	
In the first line of code we get the value of the AllCities variable, the second we get the value of the Field "City".
It is important to note we get these values at the time of the event this method in the Scriptlet corresponds with.
In this case, after a JasperReports group has been initalized, the logic in this report will be executed (provided the check on the group name performed at the start of the method is successful).
In the same method we see an example of how to write to a variable in the report:
    
	this.setVariableValue("AllCities", sbuffer.toString());
	
	

The important part when ensuring a variable in your report template is filled by a Scriptlet (or subreport) is to ensure the Variable has a calculation type of 'System' in the report design:
	
	<variable name="AllCities" class="java.lang.String" calculation="System"/>
	
	
Also notice that there is *no* Variable Expression.
Make sure you remember these two points when creating Variables in your own report with values supplied by Scriptlets.

Creating Helper Methods
At the end of the class a extra method called hello has been defined:
	
	public String hello() throws JRScriptletException
	{
		return "Hello! I'm the report's scriptlet object.";
	}
	
	
This is an example of a method that can added to the Scriptlet that actually returns a value, rather than setting a Variable.
The ScripletReport.jrxml has a method in the Summary band that illustrates how to use such a method. The expression is:
	
	$P{REPORT_SCRIPTLET}.hello()
	
	
The Parameter referenced is a built-in Parameter managed by the JasperReports API and contains a reference to the Scriptlet.
As can be seen the hello() method is called. The Type of the TextField containing this expression is String.
This corresponds to the type returned by the method in the Scriptlet.
How do you use a Scriptlet in a report? A Scriptlet can be associated with a Report by adding a scriptletClass property to the JasperReports tag:
    
    <jasperReport 
    xmlns="http://jasperreports.sourceforge.net/jasperreports" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" 
    name="ListReport" 
    columnCount="2" 
    pageWidth="595" 
    pageHeight="842" 
    columnWidth="250" 
    columnSpacing="15" 
    leftMargin="40" 
    rightMargin="40" 
    topMargin="50" 
    bottomMargin="50" 
    scriptletClass="com.myproject.reporting.MyScriptlet">
    
	
Note: The fully qualified reference is used for the Scriptlet class.

top

Alternate Row Colors In The Detail SectionDocumented by Sanda Zaharia


Description / Goal
Shows how to get alternate row colors in a detail section using conditional styles.

Since
1.2.0

Other Samples
/demo/samples/crosstabs
/demo/samples/list


Alternate Row Colors In The Detail Section

Conditional styles combined with some specific report built-in variables can be used to generate alternate row colors in the detail section.
As known, the detail section is repetitive and contains common layout information for records in the dataset. For each record in the dataset, a detail section filling process is called at fill time. Being related to records, one of the most common layouts used for the detail section is the table row layout. And like in any other table, alternate row colors might be needed.
To obtain alternate row colors, two things are necessary:
  1. to know the current record number in order to determine if it's odd or even
  2. a conditional style with specific style properties for odd or even rows
The first requirement is accomplished with the help of report built-in counting variables:
  • REPORT_COUNT - if the row color alternation does not depend on the page, column or group breaks
  • PAGE_COUNT - if each new detail page should start with the same row color
  • COLUMN_COUNT - if each new detail page column should start with the same row color
  • <group_name>_COUNT - if each new group of records should start with the same row color
  • ROW_COUNT - available only for crosstabs; the ROW_COUNT variable returns the current row number in a crosstab. An example of conditional styles in a crosstab can be found in the Crosstabs sample.
The conditional style required at point (2) is illustrated in the scriptlet sample like below:
<style name="AlternateDetail">
  <conditionalStyle>
    <conditionExpression><![CDATA[$V{CityGroup_COUNT} % 2 == 0]] ></conditionExpression>
    <style mode="Opaque" backcolor="#C0C0C0"/>
  </conditionalStyle>
</style>
Here, the odd rows in the CityGroup will be rendered in the default background color (usually white), and the even ones will be rendered in gray.

Other examples of generating alternate rows can be found in:
  • Crosstabs sample, based on the built-in ROW_COUNT and COLUMN_COUNT variables.
  • Crosstabs sample, based on the built-in REPORT_COUNT variable.



© 2001- Cloud Software Group, Inc. www.jaspersoft.com