215 lines
14 KiB
Plaintext
215 lines
14 KiB
Plaintext
<jasperReport name="HighLowChartReport" language="java" columnCount="2" pageWidth="595" pageHeight="842" columnWidth="270" columnSpacing="15" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" uuid="d4d8c726-06f5-4908-b5b8-59365e1d3e7f">
|
|
<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["High Low 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="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="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="66163e26-2049-455a-99dc-93b30cc16621" x="0" y="14" width="270" height="11" forecolor="#FFDDDD" backcolor="#FFDDDD"/>
|
|
<element kind="staticText" uuid="5a9168ac-4956-4828-bc96-6cf5b0d9dbf4" 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="2b1137de-108f-4214-ad0a-a2783255f465" 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="a9f4af20-e1c5-49eb-b8d9-20a636f026f4" x="0" y="0" width="270" height="1" forecolor="#FF0000"/>
|
|
<element kind="staticText" uuid="ff69a052-9ed2-4347-970b-7d5e47ff4e32" x="0" y="1" width="45" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="e92190c7-7265-4a3e-bb79-1466bc9fabbe" 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="da5b03b9-a50e-4a49-ac54-25695c522d6d" x="70" y="1" width="140" height="11" forecolor="#FF0000" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="a7ec0c52-21fb-4493-816d-5d5cf666af3c" 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="200">
|
|
<element kind="line" uuid="aa95e48b-9def-4e88-9cd1-a426eaaf2425" x="0" y="14" width="270" height="1"/>
|
|
<element kind="textField" uuid="4b7180d3-ef4d-4b3e-9a0c-ca11176c26d9" x="10" y="2" width="150" height="11" style="Sans_Bold">
|
|
<expression><![CDATA[$F{ShipCountry}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="168fbfcd-ce15-43ae-a56c-039323f90356" 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="highLow" uuid="cb81eafd-1e98-433b-9c11-78b08cee37a4" positionType="Float" x="0" y="25" width="270" height="175" evaluationTime="Group" evaluationGroup="CountryGroup">
|
|
<dataset kind="highLow" resetGroup="CountryGroup" resetType="Group">
|
|
<seriesExpression><![CDATA[$F{ShipCountry}]]></seriesExpression>
|
|
<dateExpression><![CDATA[$F{OrderDate}]]></dateExpression>
|
|
<highExpression><![CDATA[$F{Freight} + $F{Freight} * 0.6d]]></highExpression>
|
|
<lowExpression><![CDATA[$F{Freight} - $F{Freight} * 0.6d]]></lowExpression>
|
|
<openExpression><![CDATA[$F{Freight} - $F{Freight} * 0.3d]]></openExpression>
|
|
<closeExpression><![CDATA[$F{Freight} + $F{Freight} * 0.4d]]></closeExpression>
|
|
<volumeExpression><![CDATA[$F{Freight} / 2]]></volumeExpression>
|
|
</dataset>
|
|
<plot/>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="15">
|
|
<element kind="rectangle" uuid="eccc7ff1-d4de-4f9e-bed3-0a72ad1eb176" x="0" y="0" width="270" height="11" forecolor="#C0C0C0" backcolor="#C0C0C0"/>
|
|
<element kind="staticText" uuid="6c8bc9d3-38fd-4096-9e39-c3f3aa2b4800" 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="76d24a73-f287-4353-af6f-72ae2b1d27bd" 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="0f93804f-74bb-44d7-9172-e2ab4d395b1e" 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="0b37485c-38d7-4412-9ca4-1c59f0c0f2c9" 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="86b9a3ee-4876-43c5-a1bc-aad01029a21c" x="0" y="0" width="555" height="35" fontSize="22.0" hTextAlign="Center" style="Serif_Bold">
|
|
<text><![CDATA[High Low Chart Report]]></text>
|
|
<box style="Serif_Bold">
|
|
<topPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
</title>
|
|
<columnHeader height="11">
|
|
<element kind="rectangle" uuid="e0e484d7-7359-4ca4-9b54-620d59147e9f" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="b33301d4-7fe1-4d7e-a4ca-f6c13cbaacca" 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="54ead39d-fd76-449d-912b-f05ddeba0be9" 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="2eca54eb-bc0b-424a-bd41-bfadb6675e04" 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="67727d3d-6951-4c1e-9fd2-da277fd15e47" 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="c1cb578f-79ee-4875-9a32-cb232e1dc21a" x="1" y="0" width="35" height="11" hTextAlign="Right">
|
|
<expression><![CDATA[$F{OrderID}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="64b852c3-f01a-4086-8341-05a0254cfc99" positionType="Float" x="40" y="0" width="110" height="11" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{ShipName} + ", " + $F{ShipCity}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="9aacb745-8382-40fc-8ebb-4964d72dc5f0" x="155" y="0" width="25" height="11" blankWhenNull="true">
|
|
<expression><![CDATA[$F{ShipRegion}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="7002a9ae-75d9-47c2-bbad-2a98863eb212" x="185" y="0" width="50" height="11" pattern="dd/MM/yyyy">
|
|
<expression><![CDATA[$F{OrderDate}]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="f98f6c30-f2bc-4a37-8f80-04a7b3731fb6" x="235" y="0" width="35" height="11" pattern="0.00" hTextAlign="Right">
|
|
<expression><![CDATA[$F{Freight}]]></expression>
|
|
</element>
|
|
<element kind="line" uuid="799b9bd3-dc3a-44d7-bab7-4f70da4857dd" 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="3bb294d8-24ce-40fa-ab33-6ac57c02b264" x="0" y="0" width="270" height="11" backcolor="#333333"/>
|
|
<element kind="staticText" uuid="249fdd79-dce0-4009-9726-06413a593970" 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="a6b96e7f-9ed4-4bce-b9a0-5c2592ba1736" 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="2a150960-ba31-4520-9cca-1f21b4fea2c9" 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="fc9a0f8c-6587-4516-87ae-f160652f0e8d" 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="f1ad1a59-dfc2-4516-95fa-6f443a8beaa8" mode="Transparent" x="0" y="5" width="555" height="25"/>
|
|
<element kind="staticText" uuid="68200204-d7bd-4b4b-a4bd-79b7d3e0594e" x="5" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="96f3abb1-a4d5-49ce-a925-0e95cf5fd020" x="55" y="10" width="45" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_COUNT}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="c18e7a11-34b3-423c-862a-5551f870e391" x="430" y="10" width="50" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<text><![CDATA[Total :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="90924622-42a6-4768-88cd-ae6d5949fb23" 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="258018cf-36a2-478b-94c2-13db17c5d52e" x="200" y="10" width="75" height="20" fontSize="14.0" hTextAlign="Right">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
<element kind="staticText" uuid="e3e35c3e-84b8-49a2-9cf9-2f06945a08ce" x="275" y="10" width="5" height="20" fontSize="14.0" hTextAlign="Center">
|
|
<text><![CDATA[/]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="d1bc0b56-3bf0-4718-9335-af905fec2f39" x="280" y="10" width="75" height="20" fontSize="14.0" evaluationTime="Report">
|
|
<expression><![CDATA[$V{PAGE_NUMBER}]]></expression>
|
|
</element>
|
|
</pageFooter>
|
|
</jasperReport>
|