232 lines
15 KiB
Plaintext
232 lines
15 KiB
Plaintext
<jasperReport name="TimeSeriesChartReport" language="java" columnCount="2" pageWidth="595" pageHeight="842" columnWidth="270" columnSpacing="15" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" uuid="510cc0e1-0766-4332-b563-4cf8bf862f76">
|
|
<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["Time Series 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} AND OrderDate IS NOT NULL ORDER BY ShipCountry, OrderDate]]></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="FreightSumFirstLetterGroup" resetType="Group" calculation="Sum" resetGroup="FirstLetterGroup" 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="FreightSumMonthGroup" resetType="Group" calculation="Sum" resetGroup="MonthGroup" 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="FirstLetterGroup" minHeightToStartNewPage="200" startNewColumn="true">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
<groupHeader>
|
|
<band height="25">
|
|
<element kind="rectangle" uuid="cdef64c1-5885-4ec6-b0c9-748cf033cdb5" x="0" y="14" width="270" height="11" forecolor="#FFDDDD" backcolor="#FFDDDD"/>
|
|
<element kind="staticText" uuid="8418fd60-bb86-4a0a-8b92-523871ed5665" 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="5f1bc352-288a-4c51-9cc0-b2957a3e6891" mode="Opaque" x="130" y="14" width="140" height="11" forecolor="#FF0000" backcolor="#FFDDDD" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FirstLetter}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="25">
|
|
<element kind="line" uuid="f5513154-a34e-4c6c-9f38-483523e63d65" x="0" y="0" width="270" height="1" forecolor="#FF0000"/>
|
|
<element kind="staticText" uuid="6c74bded-f36c-4e7b-a476-b4805d52ae64" x="0" y="1" width="45" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="097c5f41-6a3d-4833-a11f-217e8f443ba8" x="45" y="1" width="25" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FirstLetterGroup_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="db14c30d-bee9-4a6d-adff-df9a6516d959" x="70" y="1" width="140" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="c0883e4b-4232-4484-8232-fc528deb2b4f" x="210" y="1" width="60" height="11" forecolor="#FF0000" pattern="0.00" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{FreightSumFirstLetterGroup}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<group name="CountryGroup">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
<groupHeader>
|
|
<band height="225">
|
|
<element kind="line" uuid="d254cdea-c858-487c-b941-2e8152a76648" x="0" y="14" width="270" height="1"/>
|
|
<element kind="textField" uuid="6e10b23d-e3fb-4516-b1a0-b4e466af9a62" x="10" y="2" width="150" height="11" style="Sans_Bold">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="46825cac-8de0-4435-857f-080aaecb4928" 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>
|
|
<element kind="chart" chartType="timeSeries" uuid="6ea1a5fe-762c-461d-8ace-3997f25ef8b7" positionType="Float" x="0" y="25" width="270" height="175" evaluationTime="Group" evaluationGroup="CountryGroup">
|
|
<dataset kind="timeSeries" incrementType="Group" resetGroup="CountryGroup" incrementGroup="MonthGroup" timePeriod="Month" resetType="Group">
|
|
<series>
|
|
<seriesExpression><![CDATA["Double Freight"]]></seriesExpression>
|
|
<timePeriodExpression><![CDATA[$F{OrderDate}]]></timePeriodExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumMonthGroup} * 2d]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
<series>
|
|
<seriesExpression><![CDATA["Normal Freight"]]></seriesExpression>
|
|
<timePeriodExpression><![CDATA[$F{OrderDate}]]></timePeriodExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumMonthGroup}]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
<series>
|
|
<seriesExpression><![CDATA["Half-Freight"]]></seriesExpression>
|
|
<timePeriodExpression><![CDATA[$F{OrderDate}]]></timePeriodExpression>
|
|
<valueExpression><![CDATA[$V{FreightSumMonthGroup} / 2d]]></valueExpression>
|
|
<labelExpression><![CDATA[]]></labelExpression>
|
|
</series>
|
|
</dataset>
|
|
<plot showShapes="true" showLines="true"/>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="15">
|
|
<element kind="rectangle" uuid="1033919e-4f82-4a6a-999c-63d6f23ee011" x="0" y="0" width="270" height="11" forecolor="#C0C0C0" backcolor="#C0C0C0"/>
|
|
<element kind="staticText" uuid="706bc5d4-9597-4a1a-a3c1-74498b9d7372" 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="81cef1a7-ab59-49ee-9f87-94b875150d7b" 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="57233335-a18f-45ab-b940-9cfbe4f30bb6" 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="f8715763-ec7a-4c85-b563-55ca03f916d7" 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>
|
|
<group name="MonthGroup">
|
|
<expression><![CDATA[$F{OrderDate}.getMonth()]]></expression>
|
|
</group>
|
|
<title height="50">
|
|
<element kind="elementGroup"/>
|
|
<element kind="staticText" uuid="95f319c6-d661-4c60-845d-ba347c5f28fb" x="0" y="0" width="555" height="35" fontSize="22.0" hTextAlign="Center" style="Serif_Bold">
|
|
<text><![CDATA[Time Series Chart Report]]></text>
|
|
<box style="Serif_Bold">
|
|
<topPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
</title>
|
|
<columnHeader height="11">
|
|
<element kind="rectangle" uuid="df6b2af6-4f41-4d28-aedd-411a268addb7" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="abaca3c1-25fb-4e51-9a07-801b11f10dd3" 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="69cc167d-f681-40f9-ae92-24eeb7cf7198" 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="ca891b55-882b-43a5-9aae-6d394397015b" 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="c3821fc5-7319-45bc-ac38-0cc642bd6588" 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="dad45304-4474-467e-b10b-7e9608d46850" x="1" y="0" width="35" height="11" hTextAlign="Right">
|
|
<expression><![CDATA[$F{OrderID}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="0b92e515-745b-4333-9961-a93a605aeced" positionType="Float" x="40" y="0" width="110" height="11" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipName} + ", " + $F{ShipCity}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="08068c13-c3b0-4617-a0a8-4991a1714c31" x="155" y="0" width="25" height="11" blankWhenNull="true">
|
|
<expression><![CDATA[$F{ShipRegion}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="c3b14dec-8860-4c5e-a2fc-6ea94a76914a" x="185" y="0" width="50" height="11" pattern="dd/MM/yyyy">
|
|
<expression><![CDATA[$F{OrderDate}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="86751e45-8bc2-47bc-b85f-93d19f48d698" x="235" y="0" width="35" height="11" pattern="0.00" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</element>
|
|
<element kind="line" uuid="a0e07ce0-726f-4f9e-92ea-a7d625aa2c63" 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="ad7b3831-66fd-44de-8476-91b9b915eeb3" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="56699c09-db1a-437d-9413-a461e690e3c0" 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="e85794d2-8bab-4db3-bebe-63151951196e" 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="ab28bf8d-3ed8-4dc2-84c8-a09310911906" 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="7d994693-9e60-4c71-b024-acbd00b820f6" 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="549a96a9-62b3-48ae-87c6-7a82846b8cbc" mode="Transparent" x="0" y="5" width="555" height="25"/>
|
|
<element kind="staticText" uuid="4a36de1f-a19c-49d0-b7a3-ffb32e12281e" x="5" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="16b53cb6-f46a-403b-a946-d114e7d90286" x="55" y="10" width="45" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="380670a9-c665-4cd2-bba7-000f9809abe2" x="430" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="dca24cca-70c4-4e9c-94ba-68943d9e8d92" 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="0244a4d2-0e07-466a-a592-00472ed5e29c" x="200" y="10" width="75" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="a7ad6da6-6a40-4820-8a8d-27b5bb0f583b" x="275" y="10" width="5" height="20" fontSize="14.0" hTextAlign="Center">
|
|
<text><![CDATA[/]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="887bdbf3-6c31-457a-8eb4-30e5515fc956" x="280" y="10" width="75" height="20" fontSize="14.0" evaluationTime="Report">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
</pageFooter>
|
|
</jasperReport>
|