68 lines
4.5 KiB
Plaintext
68 lines
4.5 KiB
Plaintext
<jasperReport name="OrdersReport" language="java" pageWidth="500" pageHeight="842" columnWidth="500" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="10ec9c66-f0a7-416e-8fb0-d1fd1cea41fc">
|
|
<style name="Sans_Normal" default="true" fontName="DejaVu Sans" fontSize="8.0" bold="false" italic="false" underline="false" strikeThrough="false"/>
|
|
<style name="Sans_Bold" fontName="DejaVu Sans" fontSize="8.0" bold="true" italic="false" underline="false" strikeThrough="false"/>
|
|
<style name="Sans_Italic" fontName="DejaVu Sans" fontSize="8.0" bold="false" italic="true" underline="false" strikeThrough="false"/>
|
|
<parameter name="CustomerID" class="java.lang.String"/>
|
|
<query language="xPath"><![CDATA[/Northwind/Orders[CustomerID='$P{CustomerID}']]]></query>
|
|
<field name="Id" class="java.lang.String">
|
|
<property name="net.sf.jasperreports.xpath.field.expression" value="OrderID"/>
|
|
</field>
|
|
<field name="OrderDate" class="java.util.Date">
|
|
<property name="net.sf.jasperreports.xpath.field.expression" value="OrderDate"/>
|
|
</field>
|
|
<field name="ShipCity" class="java.lang.String">
|
|
<property name="net.sf.jasperreports.xpath.field.expression" value="ShipCity"/>
|
|
</field>
|
|
<field name="Freight" class="java.lang.Float">
|
|
<property name="net.sf.jasperreports.xpath.field.expression" value="Freight"/>
|
|
</field>
|
|
<variable name="TotalFreight" calculation="Sum" class="java.lang.Float">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<pageHeader height="14">
|
|
<element kind="frame" uuid="4a580d60-8a5e-4e55-8a52-b88cde59c162" mode="Opaque" x="0" y="2" width="356" height="10" forecolor="#CCFFFF" backcolor="#CCFFFF">
|
|
<element kind="staticText" uuid="d2ab3078-a562-4679-85d2-8345668f8fff" mode="Opaque" x="0" y="0" width="48" height="10" backcolor="#CCFFFF" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[ID]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="c8c56ac9-453f-4904-8cf1-a4efc6a393ff" mode="Opaque" x="54" y="0" width="87" height="10" backcolor="#CCFFFF" hTextAlign="Center" style="Sans_Bold">
|
|
<text><![CDATA[Order Date]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="4c98dac9-95fc-4da9-8b96-09f556997c91" mode="Opaque" x="146" y="0" width="108" height="10" backcolor="#CCFFFF" style="Sans_Bold">
|
|
<text><![CDATA[Ship City]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="b62f2bab-65f3-4300-a4a5-2422a89122c9" mode="Opaque" x="259" y="0" width="92" height="10" backcolor="#CCFFFF" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Freight]]></text>
|
|
</element>
|
|
</element>
|
|
</pageHeader>
|
|
<detail>
|
|
<band height="14">
|
|
<element kind="textField" uuid="42985753-7ba1-4b43-a8a2-13a9e3894651" x="0" y="2" width="51" height="10" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Id}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="1886b1ce-67ff-4457-89de-7baeae1446d0" positionType="Float" x="54" y="2" width="87" height="10" textAdjust="StretchHeight" pattern="yyyy, MMM dd" hTextAlign="Center">
|
|
<expression><![CDATA[$F{OrderDate}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="c8ea91e7-4bc6-4059-99e6-ad296e4dcf26" positionType="Float" x="146" y="2" width="108" height="10" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipCity}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="fe05b06c-95b5-4847-8567-130b3785c8dd" positionType="Float" x="259" y="2" width="92" height="10" textAdjust="StretchHeight" pattern="¤ #,##0.00" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</element>
|
|
</band>
|
|
</detail>
|
|
<summary height="14">
|
|
<element kind="frame" uuid="88ac99e2-eb7a-4705-be18-6e8c724c02b1" mode="Opaque" x="0" y="2" width="356" height="10" forecolor="#33CCCC" backcolor="#33CCCC">
|
|
<element kind="staticText" uuid="256d6372-5c9b-4260-af95-3ee29b2f5740" mode="Opaque" x="160" y="0" width="67" height="10" backcolor="#33CCCC" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="de9ec45f-b4c7-48b4-bc2c-5f1f782c67a5" mode="Opaque" x="259" y="0" width="92" height="10" backcolor="#33CCCC" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{TotalFreight}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="623fe099-1d25-4731-9eab-6e4138357bbc" mode="Opaque" x="227" y="0" width="27" height="10" backcolor="#33CCCC" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{REPORT_COUNT}]]></expression>
|
|
</element>
|
|
</element>
|
|
</summary>
|
|
</jasperReport>
|