120 lines
7.6 KiB
Plaintext
120 lines
7.6 KiB
Plaintext
<jasperReport name="NoPageBreakReport" language="java" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="515" leftMargin="40" rightMargin="40" topMargin="50" bottomMargin="50" uuid="74e57349-acfc-4542-8996-125e5e3f9bf8">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/>
|
|
<style name="Sans_Normal" default="true" fontName="DejaVu Sans" fontSize="12.0" bold="false" italic="false" underline="false" strikeThrough="false"/>
|
|
<style name="Sans_Bold" fontName="DejaVu Sans" fontSize="12.0" bold="true" italic="false" underline="false" strikeThrough="false"/>
|
|
<style name="Sans_Italic" fontName="DejaVu Sans" fontSize="12.0" bold="false" italic="true" underline="false" strikeThrough="false"/>
|
|
<parameter name="ReportTitle" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["Orders Report"]]></defaultValueExpression>
|
|
</parameter>
|
|
<query language="sql"><![CDATA[SELECT * FROM Orders WHERE OrderID < 10500 ORDER BY ShipCountry]]></query>
|
|
<field name="OrderID" class="java.lang.Integer"/>
|
|
<field name="ShipName" class="java.lang.String"/>
|
|
<field name="ShipCity" class="java.lang.String"/>
|
|
<field name="ShipCountry" class="java.lang.String"/>
|
|
<variable name="HeadingsCollection" calculation="System" class="java.util.Collection">
|
|
<initialValueExpression><![CDATA[new java.util.ArrayList()]]></initialValueExpression>
|
|
</variable>
|
|
<variable name="FirstLetter" resetType="None" class="java.lang.String">
|
|
<expression><![CDATA[$F{ShipCountry}.substring(0, 1).toUpperCase()]]></expression>
|
|
</variable>
|
|
<variable name="ShipCountryNumber" resetType="Group" calculation="System" resetGroup="ShipCountryGroup" class="java.lang.Integer">
|
|
<initialValueExpression><![CDATA[$V{ShipCountryNumber} == null ? 1 : ($V{ShipCountryNumber} + 1)]]></initialValueExpression>
|
|
</variable>
|
|
<group name="FirstLetterGroup" minHeightToStartNewPage="60">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
<groupHeader>
|
|
<band height="25">
|
|
<element kind="rectangle" uuid="b2278a75-edd0-4826-9486-ab2ee2bdb5e4" mode="Transparent" x="0" y="0" width="10" height="10" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="rectangle" uuid="f151dbf3-bb32-4ad7-95ad-f67763e6bb0c" x="0" y="10" width="515" height="15" forecolor="#C0C0C0" backcolor="#C0C0C0"/>
|
|
<element kind="staticText" uuid="1b245b32-8929-4c1e-8d83-156680d5457e" mode="Opaque" x="0" y="10" width="190" height="15" backcolor="#C0C0C0" style="Sans_Italic">
|
|
<text><![CDATA[Countries Starting With Letter :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="fe1765ac-5674-4d54-8bb4-edfffddc428b" mode="Opaque" x="190" y="10" width="325" height="15" backcolor="#C0C0C0" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
<anchorNameExpression><![CDATA["FirstLetterGroup_" + $V{FirstLetter}]]></anchorNameExpression>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<group name="ShipCountryGroup" minHeightToStartNewPage="60">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
<groupHeader>
|
|
<band height="20">
|
|
<element kind="rectangle" uuid="fd0767c3-1921-47a6-8d22-7632d7edd911" mode="Transparent" x="0" y="0" width="10" height="4" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="line" uuid="a875f729-e9c7-407b-b851-c90053ea3688" x="0" y="19" width="515" height="1" direction="BottomUp"/>
|
|
<element kind="textField" uuid="6c179862-1c67-4072-b44a-f6abc23b6952" x="0" y="4" width="515" height="15" style="Sans_Bold">
|
|
<expression><![CDATA[" " + String.valueOf($V{ShipCountryNumber}) + ". " + String.valueOf($F{ShipCountry})]]></expression>
|
|
<anchorNameExpression><![CDATA["ShipCountryGroup_" + $V{ShipCountryNumber}]]></anchorNameExpression>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="20">
|
|
<element kind="rectangle" uuid="3856a7ea-8779-4929-b081-208e6a601e39" mode="Transparent" x="400" y="16" width="10" height="4" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="line" uuid="d1f96f9c-ea96-4db1-a860-a1201c16b940" x="0" y="0" width="515" height="1"/>
|
|
<element kind="staticText" uuid="e6045212-42a2-4281-9fed-0ed4c0d5fcda" x="400" y="1" width="60" height="15" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="26ae61a0-61c3-4ce0-86a6-bc1a1bed2529" x="460" y="1" width="30" height="15" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{ShipCountryGroup_COUNT}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<title height="65">
|
|
<element kind="rectangle" uuid="5b0cb22d-8d28-4cdf-97ef-0032c0f4b1eb" mode="Transparent" x="0" y="0" width="10" height="10" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="staticText" uuid="5fdd2991-40e1-424c-bce5-5e054d9141ee" x="0" y="10" width="515" height="30" fontSize="22.0" hTextAlign="Center" style="Sans_Normal">
|
|
<text><![CDATA[Order List]]></text>
|
|
</element>
|
|
<element kind="rectangle" uuid="ec356000-c533-42a6-ae2b-fb3c63c5fa06" mode="Transparent" x="0" y="40" width="10" height="10" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="staticText" uuid="023bf636-b642-411e-83df-ca82d93f803a" mode="Opaque" x="0" y="50" width="55" height="15" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Center" style="Sans_Bold">
|
|
<text><![CDATA[ID]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="e6798f4a-d6b9-461e-8ec7-fb4278b5bfd6" mode="Opaque" x="55" y="50" width="205" height="15" forecolor="#FFFFFF" backcolor="#333333" style="Sans_Bold">
|
|
<text><![CDATA[Name]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="5093da7c-622f-4b97-8965-da9b3edfd792" mode="Opaque" x="260" y="50" width="255" height="15" forecolor="#FFFFFF" backcolor="#333333" style="Sans_Bold">
|
|
<text><![CDATA[City]]></text>
|
|
</element>
|
|
</title>
|
|
<detail>
|
|
<band height="20">
|
|
<element kind="rectangle" uuid="80f01721-e407-4063-8e70-637f874e5967" mode="Transparent" x="0" y="0" width="10" height="5" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="textField" uuid="f2663acc-6d85-4620-96fa-cb4ed6e3714c" x="0" y="5" width="50" height="15" hTextAlign="Right">
|
|
<expression><![CDATA[$F{OrderID}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="162a1369-80f1-4a94-9e0b-910a37df995a" positionType="Float" x="55" y="5" width="200" height="15" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipName}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="7d815d02-8ea8-4cc0-9614-12d0450cc121" positionType="Float" x="260" y="5" width="255" height="15" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipCity}]]></expression>
|
|
</element>
|
|
</band>
|
|
</detail>
|
|
<summary height="60">
|
|
<element kind="rectangle" uuid="5411de0b-fe61-4891-bde2-11d3f8271e0a" mode="Transparent" x="175" y="0" width="10" height="20" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
<element kind="textField" uuid="83cf22b0-44d2-4b4f-ad03-116966b71836" x="175" y="20" width="165" height="15" textAdjust="StretchHeight" hTextAlign="Center" style="Sans_Italic">
|
|
<expression><![CDATA["There were " +
|
|
String.valueOf($V{REPORT_COUNT}) +
|
|
" orders on this report."]]></expression>
|
|
</element>
|
|
<element kind="rectangle" uuid="b2805ef7-ca87-43a3-9907-b9e08548d912" positionType="Float" mode="Transparent" x="175" y="35" width="10" height="25" forecolor="#FF0000" backcolor="#FFAFAF">
|
|
<pen lineWidth="0.0"/>
|
|
</element>
|
|
</summary>
|
|
</jasperReport>
|