Java Reference
In-Depth Information
The JRXML template used to generate this report is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN"
"http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport name="BarChartDemoReport">
<queryString>
<![CDATA[(select a.city, am.model
from aircraft a, aircraft_models am
where city='NEW YORK'
and state='NY'
and a.aircraft_model_code = am.aircraft_model_code
order by model)
UNION ALL (select a.city, am.model
from aircraft a, aircraft_models am
where city='WASHINGTON'
and state='DC'
and a.aircraft_model_code =
am.aircraft_model_code
order by model)]]>
</queryString>
<field name="city" class="java.lang.String"/>
<field name="model" class="java.lang.String"/>
<variable name="totalAircraft" class="java.lang.Integer"
calculation="Count" resetType="Group" resetGroup="modelGroup">
<variableExpression>
<![CDATA[$F{model}]]>
</variableExpression>
<initialValueExpression>
<![CDATA[new java.lang.Integer(0)]]>
</initialValueExpression>
</variable>
<group name="modelGroup">
<groupExpression>
<![CDATA[$F{model}]]>
</groupExpression>
</group>
<summary>
<band height="750">
