68 lines
4.5 KiB
Plaintext
68 lines
4.5 KiB
Plaintext
<jasperReport name="JsonOrdersReport" language="java" pageWidth="500" pageHeight="842" columnWidth="500" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="5a62986f-c97c-4e2f-b4ed-d9f38960dab4">
|
|
<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="json"><![CDATA[Northwind.Orders(CustomerID == $P{CustomerID})]]></query>
|
|
<field name="Id" class="java.lang.String">
|
|
<property name="net.sf.jasperreports.json.field.expression" value="OrderID"/>
|
|
</field>
|
|
<field name="OrderDate" class="java.util.Date">
|
|
<property name="net.sf.jasperreports.json.field.expression" value="OrderDate"/>
|
|
</field>
|
|
<field name="ShipCity" class="java.lang.String">
|
|
<property name="net.sf.jasperreports.json.field.expression" value="ShipCity"/>
|
|
</field>
|
|
<field name="Freight" class="java.lang.Float">
|
|
<property name="net.sf.jasperreports.json.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="e9af134f-31eb-48be-bd9b-292188f2554f" mode="Opaque" x="0" y="2" width="356" height="10" forecolor="#CCFFFF" backcolor="#CCFFFF">
|
|
<element kind="staticText" uuid="62e5e770-7b05-4ecd-a254-ab0c7f643a37" 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="c472f825-47f4-4e16-a782-cc4b02572cb0" 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="89b5edba-1606-4f5d-89cb-144042c1fcdd" 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="e7c6fbe3-ecb2-4c65-83d6-7c813448cec6" 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="ec54687d-3c95-4647-9db5-fa71a6e81009" x="0" y="2" width="51" height="10" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Id}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="a112ba7b-c321-467c-91ec-ffb513c23338" 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="6a61edb3-239e-4791-a046-a6459343ac07" positionType="Float" x="146" y="2" width="108" height="10" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipCity}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="61a8a117-6a43-46a7-9b96-10c5beb578ab" 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="084cfbb4-f390-4302-8bf5-2e65b34829b8" mode="Opaque" x="0" y="2" width="356" height="10" forecolor="#33CCCC" backcolor="#33CCCC">
|
|
<element kind="staticText" uuid="06753d49-aed5-46c8-be06-b107f81d7c2f" 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="a713b487-68a2-4391-a231-9bf9aa740090" 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="d8edf4da-1e47-45ec-bbf3-f63b3bf0b93b" 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>
|