Java Reference
In-Depth Information
<![CDATA[select (select count(*)
from aircraft_models am
where am.aircraft_type_id = 4) as
fixed_wing_single_engine_cnt,
(select count(*)
from aircraft_models am
where am.aircraft_type_id = 5) as
fixed_wing_multiple_engine_cnt,
(select count(*)
from aircraft_models am
where am.aircraft_type_id = 6) as
rotorcraft_cnt]]>
</queryString>
<field name="fixed_wing_single_engine_cnt" class="java.lang.Integer"/>
<field name="fixed_wing_multiple_engine_cnt" class="java.lang.
Integer"/>
<field name="rotorcraft_cnt" class="java.lang.Integer"/>
<detail>
<band height="100">
<textField>
<reportElement x="20" y="0" height="20" width="500"/>
<textFieldExpression>
<![CDATA["Total Fixed Wing Single Engine Aircraft Models: "
+$F{fixed_wing_single_engine_cnt}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="20" y="20" height="20" width="500"/>
<textFieldExpression>
<![CDATA["Total Fixed Wing Multiple Engine Aircraft Models:"
+$F{fixed_wing_multiple_engine_cnt}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="20" y="40" height="20" width="500"/>
<textFieldExpression>
<![CDATA["Total Fixed Wing Aircraft Models: " +
($F{fixed_wing_single_engine_cnt}.intValue() +
$F{fixed_wing_multiple_engine_cnt}.intValue())]]>
</textFieldExpression>
</textField>
<textField>
