254 lines
16 KiB
Plaintext
254 lines
16 KiB
Plaintext
<jasperReport name="LineChartReport" language="java" columnCount="2" pageWidth="595" pageHeight="842" columnWidth="270" columnSpacing="15" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" uuid="135363b5-d9ff-4262-9eed-657530c6832c">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/>
|
|
<property name="net.sf.jasperreports.chart.render.type" value="svg"/>
|
|
<property name="net.sf.jasperreports.image.dpi" value="150"/>
|
|
<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"/>
|
|
<style name="Serif_Normal" fontName="DejaVu Serif" fontSize="10.0" bold="false" italic="false" underline="false" strikeThrough="false"/>
|
|
<style name="Serif_Bold" fontName="DejaVu Serif" fontSize="10.0" bold="true" italic="false" underline="false" strikeThrough="false"/>
|
|
<parameter name="ReportTitle" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["Line Chart Report"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="MaxOrderID" class="java.lang.Integer">
|
|
<defaultValueExpression><![CDATA[12500]]></defaultValueExpression>
|
|
</parameter>
|
|
<query language="sql"><![CDATA[SELECT * FROM Orders WHERE OrderID <= $P{MaxOrderID} ORDER BY ShipCountry]]></query>
|
|
<field name="ShippedDate" class="java.sql.Timestamp"/>
|
|
<field name="ShipCountry" class="java.lang.String"/>
|
|
<field name="RequiredDate" class="java.sql.Timestamp"/>
|
|
<field name="CustomerID" class="java.lang.String"/>
|
|
<field name="OrderID" class="java.lang.Integer"/>
|
|
<field name="ShipName" class="java.lang.String"/>
|
|
<field name="ShipVia" class="java.lang.Integer"/>
|
|
<field name="ShipPostalCode" class="java.lang.String"/>
|
|
<field name="OrderDate" class="java.sql.Timestamp"/>
|
|
<field name="ShipCity" class="java.lang.String"/>
|
|
<field name="ShipAddress" class="java.lang.String"/>
|
|
<field name="EmployeeID" class="java.lang.Integer"/>
|
|
<field name="ShipRegion" class="java.lang.String"/>
|
|
<field name="Freight" class="java.lang.Double"/>
|
|
<variable name="FirstLetter" resetType="None" class="java.lang.String">
|
|
<expression><![CDATA[$F{ShipCountry}.substring(0, 1).toUpperCase()]]></expression>
|
|
</variable>
|
|
<variable name="FirstLetterCount" resetType="Group" incrementType="Group" calculation="Count" resetGroup="ChartGroup" incrementGroup="FirstLetterGroup" class="java.lang.Integer">
|
|
<expression><![CDATA[Boolean.TRUE]]></expression>
|
|
</variable>
|
|
<variable name="FirstLetterMin" resetType="Group" calculation="Lowest" resetGroup="ChartGroup" class="java.lang.String">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
</variable>
|
|
<variable name="FirstLetterMax" resetType="Group" calculation="Highest" resetGroup="ChartGroup" class="java.lang.String">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
</variable>
|
|
<variable name="FreightSumChartGroup" resetType="Group" calculation="Sum" resetGroup="ChartGroup" class="java.lang.Double">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<variable name="FreightSumCountryGroup" resetType="Group" calculation="Sum" resetGroup="CountryGroup" class="java.lang.Double">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<variable name="FreightSumColumn" resetType="Column" calculation="Sum" class="java.lang.Double">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<variable name="FreightSumPage" resetType="Page" calculation="Sum" class="java.lang.Double">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<variable name="FreightSumReport" calculation="Sum" class="java.lang.Double">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</variable>
|
|
<variable name="DateHighestCountryGroup" resetType="Group" calculation="Highest" resetGroup="CountryGroup" class="java.sql.Timestamp">
|
|
<expression><![CDATA[$F{OrderDate}]]></expression>
|
|
</variable>
|
|
<variable name="RegionCountCountryGroup" resetType="Group" calculation="Count" resetGroup="CountryGroup" class="java.lang.Integer">
|
|
<expression><![CDATA[$F{ShipRegion}]]></expression>
|
|
</variable>
|
|
<group name="ChartGroup" minHeightToStartNewPage="200" startNewColumn="true">
|
|
<expression><![CDATA[($V{FirstLetterCount} - 1) / 3]]></expression>
|
|
<groupHeader>
|
|
<band height="250">
|
|
<element kind="rectangle" uuid="1c6dde02-8775-4b2b-b560-1f3fa880d747" x="0" y="14" width="270" height="11" forecolor="#FFDDDD" backcolor="#FFDDDD"/>
|
|
<element kind="staticText" uuid="f12543d0-3b76-4ff0-a213-b0ee05d545f9" mode="Opaque" x="0" y="14" width="130" height="11" forecolor="#FF0000" backcolor="#FFDDDD" underline="true" style="Sans_Italic">
|
|
<text><![CDATA[Countries Starting With Letter :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="86d6a2c1-2fd0-49fa-80fd-2385ffea413d" mode="Opaque" x="130" y="14" width="20" height="11" forecolor="#FF0000" backcolor="#FFDDDD" evaluationTime="Group" evaluationGroup="ChartGroup" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FirstLetterMin}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="085e8b3f-ad6d-480e-8172-1a7fc13d6732" mode="Opaque" x="150" y="14" width="20" height="11" forecolor="#FF0000" backcolor="#FFDDDD" underline="true" hTextAlign="Center" style="Sans_Italic">
|
|
<text><![CDATA[to]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="424a734f-c46c-4f10-8aa5-1682c5063e43" mode="Opaque" x="170" y="14" width="20" height="11" forecolor="#FF0000" backcolor="#FFDDDD" evaluationTime="Group" evaluationGroup="ChartGroup" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FirstLetterMax}]]></expression>
|
|
</element>
|
|
<element kind="chart" chartType="line" uuid="ade339d6-ffae-4d47-8882-76cd4ec4e482" positionType="Float" x="0" y="50" width="270" height="175" evaluationTime="Group" evaluationGroup="ChartGroup">
|
|
<dataset kind="category" incrementType="Group" resetGroup="ChartGroup" incrementGroup="CountryGroup" resetType="Group">
|
|
<series>
|
|
<seriesExpression><![CDATA["Double Freight"]]></seriesExpression>
|
|
<categoryExpression><![CDATA[$F{ShipCountry}]]></categoryExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumCountryGroup} * 2d]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
<series>
|
|
<seriesExpression><![CDATA["Normal Freight"]]></seriesExpression>
|
|
<categoryExpression><![CDATA[$F{ShipCountry}]]></categoryExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumCountryGroup}]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
<series>
|
|
<seriesExpression><![CDATA["Half Freight"]]></seriesExpression>
|
|
<categoryExpression><![CDATA[$F{ShipCountry}]]></categoryExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumCountryGroup} / 2d]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
<series>
|
|
<seriesExpression><![CDATA["Double Freight"]]></seriesExpression>
|
|
<categoryExpression><![CDATA[$F{ShipCountry}]]></categoryExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumCountryGroup} * 2d]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
</dataset>
|
|
<plot showShapes="false" showLines="true">
|
|
<seriesColor order="0" color="#FF00FF"/>
|
|
<seriesColor order="1" color="#FFFF00"/>
|
|
<seriesColor order="2" color="#00FFFF"/>
|
|
</plot>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="25">
|
|
<element kind="line" uuid="9591ebbf-5ea3-4fc4-b6c1-a3089e34f5f8" x="0" y="0" width="270" height="1" forecolor="#FF0000"/>
|
|
<element kind="staticText" uuid="d35b231b-c463-4f53-bfab-cd59303d0e58" x="0" y="1" width="45" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="ee4fa3b5-9f10-4bc0-a92b-658f49a4f55a" x="45" y="1" width="25" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{ChartGroup_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="fed8861b-2200-4afe-9cbf-57ca37577ad6" x="70" y="1" width="140" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="280e8b13-3c5b-4bbc-9365-273351b530c2" x="210" y="1" width="60" height="11" forecolor="#FF0000" pattern="0.00" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FreightSumChartGroup}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<group name="FirstLetterGroup">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
</group>
|
|
<group name="CountryGroup">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
<groupHeader>
|
|
<band height="15">
|
|
<element kind="line" uuid="16c7fbc9-2d1a-4934-86e2-fbc66514db54" x="0" y="14" width="270" height="1"/>
|
|
<element kind="textField" uuid="68df59f6-9536-4002-8b9c-5cbc79081cd9" x="10" y="2" width="150" height="11" style="Sans_Bold">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="ed646d67-d867-4b3c-b62b-13247530c7d1" x="170" y="2" width="100" height="11" evaluationTime="Group" pattern="EEE, MMM d, yyyy" evaluationGroup="CountryGroup" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{DateHighestCountryGroup}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="15">
|
|
<element kind="rectangle" uuid="9e7a927e-1bef-4887-8210-30e3c67937d5" x="0" y="0" width="270" height="11" forecolor="#C0C0C0" backcolor="#C0C0C0"/>
|
|
<element kind="staticText" uuid="a63ebfdb-ca58-448e-9be6-02c6501131f3" mode="Opaque" x="0" y="0" width="45" height="11" backcolor="#C0C0C0" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="89f0bafe-6cf2-45a9-9125-69299719d12c" mode="Opaque" x="45" y="0" width="25" height="11" backcolor="#C0C0C0" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{CountryGroup_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="5d89637c-a49f-4b6b-8172-1138a2e01b2c" mode="Opaque" x="70" y="0" width="140" height="11" backcolor="#C0C0C0" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="dcc984f7-fcda-4a5c-95d6-04c65ca2b8d0" mode="Opaque" x="210" y="0" width="60" height="11" backcolor="#C0C0C0" pattern="0.00" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FreightSumCountryGroup}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<title height="50">
|
|
<element kind="elementGroup"/>
|
|
<element kind="staticText" uuid="d99201e7-eb45-4d55-90ee-40566fd74e2f" x="0" y="0" width="555" height="35" fontSize="22.0" hTextAlign="Center" style="Serif_Bold">
|
|
<text><![CDATA[Line Chart Report]]></text>
|
|
<box style="Serif_Bold">
|
|
<topPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
</title>
|
|
<columnHeader height="11">
|
|
<element kind="rectangle" uuid="0594992b-ce48-424c-9d94-58748d1c7c64" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="87b9e674-1af5-403f-a679-17e9c95d9c09" mode="Opaque" x="0" y="0" width="40" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Center" style="Sans_Bold">
|
|
<text><![CDATA[Order]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="d2d3adca-a4fd-40bf-bba8-33c471b869ff" mode="Opaque" x="40" y="0" width="145" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Center" style="Sans_Bold">
|
|
<text><![CDATA[Name, City]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="20c26404-0a80-4375-b5f1-7034ca9079ec" mode="Opaque" x="185" y="0" width="50" height="11" forecolor="#FFFFFF" backcolor="#333333" style="Sans_Bold">
|
|
<text><![CDATA[Date]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="4b096b18-231f-4e29-9a99-35f692e8d9eb" mode="Opaque" x="235" y="0" width="35" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Freight]]></text>
|
|
</element>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="13">
|
|
<element kind="textField" uuid="268a23d8-b26a-4aec-829d-e8d35339bd64" x="1" y="0" width="35" height="11" hTextAlign="Right">
|
|
<expression><![CDATA[$F{OrderID}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="9701332b-f225-4476-b3d6-a329e32f77ea" positionType="Float" x="40" y="0" width="110" height="11" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipName} + ", " + $F{ShipCity}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="33eb2173-6dcf-4eda-bab2-37861b7e3bce" x="155" y="0" width="25" height="11" blankWhenNull="true">
|
|
<expression><![CDATA[$F{ShipRegion}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="43095789-a625-4283-8a40-e1b39468e450" x="185" y="0" width="50" height="11" pattern="dd/MM/yyyy">
|
|
<expression><![CDATA[$F{OrderDate}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="500dc830-d96f-40a5-9053-40e0a57a1db8" x="235" y="0" width="35" height="11" pattern="0.00" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</element>
|
|
<element kind="line" uuid="d1ba29d2-5f3a-4a5d-bbb2-cd10cb54ab5d" positionType="Float" x="0" y="12" width="270" height="1" forecolor="#808080">
|
|
<pen lineWidth="0.5"/>
|
|
</element>
|
|
</band>
|
|
</detail>
|
|
<columnFooter height="11">
|
|
<element kind="rectangle" uuid="7afc1378-4d45-49f9-a31d-450a113d094e" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="3bc47023-01ec-4102-ba1e-2812f677b484" mode="Opaque" x="0" y="0" width="45" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="9d383d23-d846-4bbf-a654-d71a8cde98c8" mode="Opaque" x="45" y="0" width="25" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{COLUMN_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="03f7a674-77ae-431b-9790-74b9c7494b02" mode="Opaque" x="70" y="0" width="140" height="11" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="f50e0f8b-c747-449a-9bae-6ecdb57055d6" mode="Opaque" x="210" y="0" width="60" height="11" forecolor="#FFFFFF" backcolor="#333333" pattern="0.00" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FreightSumColumn}]]></expression>
|
|
</element>
|
|
</columnFooter>
|
|
<pageFooter height="30">
|
|
<element kind="rectangle" uuid="77189cab-52a9-46d1-a35c-003baeb03190" mode="Transparent" x="0" y="5" width="555" height="25"/>
|
|
<element kind="staticText" uuid="3ac9ed47-bb0d-46ca-a7c8-3fb9fd61d475" x="5" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="645649f8-bf95-4b14-a0a3-af0cc100b968" x="55" y="10" width="45" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="ed56c699-5eb9-448c-adb6-201866fb21e9" x="430" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="030c79d5-28fe-43c7-a005-11e248a7f7df" x="480" y="10" width="70" height="20" fontSize="14.0" pattern="0.00" hTextAlign="Right">
|
|
<expression><![CDATA[$V{FreightSumPage}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="c2cff93b-0820-46c0-a842-c41aa20e1ec7" x="200" y="10" width="75" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="3e8349a8-a9c0-455b-8160-69ecdb86c3d6" x="275" y="10" width="5" height="20" fontSize="14.0" hTextAlign="Center">
|
|
<text><![CDATA[/]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="08d076ae-9a95-4c8a-ab18-ccc64336b37e" x="280" y="10" width="75" height="20" fontSize="14.0" evaluationTime="Report">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
</pageFooter>
|
|
</jasperReport>
|