139 lines
7.8 KiB
Plaintext
139 lines
7.8 KiB
Plaintext
<jasperReport name="CsvDataSourceReport" language="java" pageWidth="595" pageHeight="842" columnWidth="515" leftMargin="40" rightMargin="40" topMargin="50" bottomMargin="50" uuid="cf9695b1-22d1-4645-b4bf-df690d992591">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="csvdatasource/SampleCsvDataSource.xml"/>
|
|
<property name="net.sf.jasperreports.data.adapter" value="SampleCsvDataSource.jrdax"/>
|
|
<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">
|
|
<description><![CDATA[]]></description>
|
|
<defaultValueExpression><![CDATA["Address Report"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="DataFile" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["CsvDataSource.txt - CSV data source"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="IncludedStates" class="java.util.Set">
|
|
<defaultValueExpression><![CDATA[new HashSet(Arrays.asList(new String[] { "Trial", "Active", "Suspended", "Deleted", }))]]></defaultValueExpression>
|
|
</parameter>
|
|
<field name="id" class="java.lang.Integer">
|
|
<description><![CDATA[id]]></description>
|
|
</field>
|
|
<field name="name" class="java.lang.String">
|
|
<description><![CDATA[name]]></description>
|
|
</field>
|
|
<field name="address" class="java.lang.String">
|
|
<description><![CDATA[street address]]></description>
|
|
</field>
|
|
<field name="city" class="java.lang.String">
|
|
<description><![CDATA[city]]></description>
|
|
</field>
|
|
<field name="state" class="java.lang.String">
|
|
<description><![CDATA[state]]></description>
|
|
</field>
|
|
<sortField name="city" order="Descending"/>
|
|
<sortField name="name"/>
|
|
<variable name="CityNumber" incrementType="Group" calculation="Count" incrementGroup="CityGroup" class="java.lang.Integer">
|
|
<expression><![CDATA[Boolean.TRUE]]></expression>
|
|
</variable>
|
|
<filterExpression><![CDATA[$P{IncludedStates}.contains($F{state})]]></filterExpression>
|
|
<group name="CityGroup" minHeightToStartNewPage="60">
|
|
<expression><![CDATA[$F{city}]]></expression>
|
|
<groupHeader>
|
|
<band height="20">
|
|
<element kind="textField" uuid="3ba60404-f3fd-4ed7-a6b2-c9498e15ff84" mode="Opaque" x="0" y="5" width="515" height="15" backcolor="#C0C0C0" evaluationTime="Group" evaluationGroup="CityGroup" style="Sans_Bold">
|
|
<expression><![CDATA[" " + String.valueOf($V{CityNumber}) + ". " + String.valueOf($F{city})]]></expression>
|
|
<anchorNameExpression><![CDATA[String.valueOf($F{city})]]></anchorNameExpression>
|
|
<bookmarkLevelExpression><![CDATA[1]]></bookmarkLevelExpression>
|
|
<box leftPadding="10" style="Sans_Bold">
|
|
<bottomPen lineWidth="1.0"/>
|
|
</box>
|
|
</element>
|
|
</band>
|
|
</groupHeader>
|
|
<groupFooter>
|
|
<band height="20">
|
|
<element kind="staticText" uuid="d6fb40b3-4c46-43c0-a9db-930019e795c6" x="400" y="1" width="60" height="15" hTextAlign="Right" style="Sans_Bold">
|
|
<text><![CDATA[Count :]]></text>
|
|
</element>
|
|
<element kind="textField" uuid="d72cd6df-8b5f-4707-a9af-ef8db36a3372" x="460" y="1" width="30" height="15" hTextAlign="Right" style="Sans_Bold">
|
|
<expression><![CDATA[$V{CityGroup_COUNT}]]></expression>
|
|
</element>
|
|
</band>
|
|
</groupFooter>
|
|
</group>
|
|
<title height="70">
|
|
<element kind="line" uuid="f6007cc5-20a4-4dc4-9913-91bee5e2d9ef" x="0" y="0" width="515" height="1"/>
|
|
<element kind="textField" uuid="9d3b99d4-d14d-457b-ab2f-35da1dccad2e" x="0" y="10" width="515" height="30" fontSize="22.0" blankWhenNull="true" hTextAlign="Center" style="Sans_Normal">
|
|
<expression><![CDATA[$P{ReportTitle}]]></expression>
|
|
<anchorNameExpression><![CDATA["Title"]]></anchorNameExpression>
|
|
<bookmarkLevelExpression><![CDATA[1]]></bookmarkLevelExpression>
|
|
</element>
|
|
<element kind="textField" uuid="3c9d0ef5-a586-4cc2-b102-5df461e51201" x="0" y="40" width="515" height="20" fontSize="14.0" blankWhenNull="true" hTextAlign="Center" style="Sans_Normal">
|
|
<expression><![CDATA[$P{DataFile}]]></expression>
|
|
</element>
|
|
</title>
|
|
<pageHeader height="20">
|
|
<element kind="staticText" uuid="4bdf5f73-7f67-4e19-9057-7e37b4b30c38" mode="Opaque" x="0" y="5" width="55" height="15" forecolor="#FFFFFF" backcolor="#333333" hTextAlign="Center" style="Sans_Bold">
|
|
<text><![CDATA[ID]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="f1355688-eab9-4248-af46-67e7135b0d95" mode="Opaque" x="55" y="5" width="205" height="15" forecolor="#FFFFFF" backcolor="#333333" style="Sans_Bold">
|
|
<text><![CDATA[Name]]></text>
|
|
</element>
|
|
<element kind="staticText" uuid="c2ff2c7b-5558-4654-9f4e-0aa7c8c4c252" mode="Opaque" x="260" y="5" width="255" height="15" forecolor="#FFFFFF" backcolor="#333333" style="Sans_Bold">
|
|
<text><![CDATA[Street]]></text>
|
|
</element>
|
|
</pageHeader>
|
|
<detail>
|
|
<band height="15">
|
|
<element kind="textField" uuid="ce60da72-86be-4049-8cae-bedb9ad62746" x="0" y="0" width="50" height="15" hTextAlign="Right">
|
|
<expression><![CDATA[$F{id}]]></expression>
|
|
<anchorNameExpression><![CDATA[$F{name} + " (" + $F{id} + ")"]]></anchorNameExpression>
|
|
<bookmarkLevelExpression><![CDATA[2]]></bookmarkLevelExpression>
|
|
<box leftPadding="10" rightPadding="10">
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
<element kind="textField" uuid="056f29cf-86bf-4f0c-87e5-fdfa70054e35" positionType="Float" x="50" y="0" width="200" height="15" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{name}]]></expression>
|
|
<box leftPadding="10" rightPadding="10">
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
<element kind="textField" uuid="6b549474-9387-4739-a059-dca2e6809910" positionType="Float" x="250" y="0" width="265" height="15" textAdjust="StretchHeight">
|
|
<expression><![CDATA[$F{address}]]></expression>
|
|
<box leftPadding="10" rightPadding="10">
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
</element>
|
|
</band>
|
|
</detail>
|
|
<pageFooter height="40">
|
|
<element kind="line" uuid="9731e4e0-b9e0-4cf2-aaac-cbb56109ec54" x="0" y="10" width="515" height="1"/>
|
|
<element kind="textField" uuid="f9cfa9ed-8709-413f-9e14-50876f98ab51" x="200" y="20" width="80" height="15" hTextAlign="Right">
|
|
<expression><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of"]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="5848a301-296f-4e89-8469-046531a6eea2" x="280" y="20" width="75" height="15" evaluationTime="Report">
|
|
<expression><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></expression>
|
|
</element>
|
|
</pageFooter>
|
|
<lastPageFooter height="60">
|
|
<element kind="textField" uuid="8aacdf2b-4aad-40a4-a0b7-adaa73bcd938" x="0" y="10" width="515" height="15" bookmarkLevel="2" hTextAlign="Center">
|
|
<expression><![CDATA["There were " +
|
|
String.valueOf($V{REPORT_COUNT}) +
|
|
" address records on this report."]]></expression>
|
|
<anchorNameExpression><![CDATA["Summary"]]></anchorNameExpression>
|
|
<bookmarkLevelExpression><![CDATA[1]]></bookmarkLevelExpression>
|
|
</element>
|
|
<element kind="line" uuid="ade1242b-914a-4ceb-bc11-66ecc903cdab" x="0" y="30" width="515" height="1"/>
|
|
<element kind="textField" uuid="789d70a3-9146-4f84-9fff-90e40ad784e1" x="200" y="40" width="80" height="15" hTextAlign="Right">
|
|
<expression><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of"]]></expression>
|
|
</element>
|
|
<element kind="textField" uuid="3aea4311-bd09-4c69-ba36-c5f3dec0ec7f" x="280" y="40" width="75" height="15" evaluationTime="Report">
|
|
<expression><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></expression>
|
|
</element>
|
|
</lastPageFooter>
|
|
</jasperReport>
|