Java Reference
In-Depth Information
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//
EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport name="DatasetDemoReport" leftMargin="5" rightMargin="5">
<subDataset name="Aircraft_Models">
<parameter name="StateParam" class="java.lang.String"/>
<queryString>
<![CDATA[select
a.city, am.model, a.tail_num
from aircraft a, aircraft_models am
where a.state=$P{StateParam} and am.model like 'C%'
and a.aircraft_model_code = am.aircraft_model_code
order by city, model]]>
</queryString>
<field name="tail_num" class="java.lang.String"/>
<field name="model" class="java.lang.String"/>
<field name="city" class="java.lang.String"/>
</subDataset>
<queryString>
<![CDATA[select distinct state from aircraft where state in (
'MD', 'NY', 'VA') order by state]]>
</queryString>
<field name="state" class="java.lang.String"/>
<detail>
<band height="100">
<textField>
<reportElement x="0" y="10" width="500" height="20"/>
<textFieldExpression><![CDATA[
"Aircraft registered in" + $F{state}]]>
</textFieldExpression>
</textField>
<crosstab>
<reportElement width="782" y="30" x="0" height="60"/>
<crosstabDataset>
<dataset>
<datasetRun subDataset="Aircraft_Models">
<datasetParameter name="StateParam">
<datasetParameterExpression>
<![CDATA[$F{state}]]>
</datasetParameterExpression>
</datasetParameter>
</datasetRun>
</dataset>
</crosstabDataset>
<rowGroup name="cityGroup" width="100" totalPosition="End">
