<?xml version="1.0" encoding="UTF-8"?>
<jasperReport
xmlns="http://jasperreports.sourceforge.net/jasperreports"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
name ="report name"
pageWidth = "595"
pageHeight = "845"
columnWidth = "595"
leftMargin = "0"
rightMargin = "0"
topMargin = "0"
bottomMargin = "0"
>
<!--
pageHeight
A4 is 842, but I chose 845 in order to have 65 lines on a page.
Also, the text file output seems not to be generated if pageHeight
is not a multiple of charHeight (sic!)
ctrl-L
a ctrl-L between the pages can be forced (within iReports) with
extras -> options -> export options > (text) -> Between Pages Text
-->
<queryString>
<![CDATA[
select 'some text 1' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, null col_2 from dual union all
select 'some text' col_1, ' *' col_2 from dual union all
select 'some text' col_1, ' ***' col_2 from dual union all
select 'some text' col_1, ' *****' col_2 from dual union all
select 'some text' col_1, ' ***' col_2 from dual union all
select 'some text' col_1, ' *' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 10' col_1, 'some_other_text' col_2 from dual union all
select 'some text 11' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 20' col_1, 'some_other_text' col_2 from dual union all
select 'some text 21' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 30' col_1, 'some_other_text' col_2 from dual union all
select 'some text 31' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 40' col_1, 'some_other_text' col_2 from dual union all
select 'some text 41' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 50' col_1, 'some_other_text' col_2 from dual union all
select 'some text 51' col_1, 'some_other_text' col_2 from dual union all
select 'some text 52' col_1, 'some_other_text' col_2 from dual union all
select 'some text 53' col_1, 'some_other_text' col_2 from dual union all
select 'some text 54' col_1, 'some_other_text' col_2 from dual union all
select 'some text 55' col_1, 'some_other_text' col_2 from dual union all
select 'some text 56' col_1, 'some_other_text' col_2 from dual union all
select 'some text 57' col_1, 'some_other_text' col_2 from dual union all
select 'some text 58' col_1, 'some_other_text' col_2 from dual union all
select 'some text 59' col_1, 'some_other_text' col_2 from dual union all
select 'some text 60' col_1, 'some_other_text' col_2 from dual union all
select 'some text 61' col_1, 'some_other_text' col_2 from dual union all
select 'some text 62' col_1, 'some_other_text' col_2 from dual union all
select 'some text 63' col_1, 'some_other_text' col_2 from dual union all
select 'some text 64' col_1, 'some_other_text' col_2 from dual union all
select 'some text 65' col_1, 'some_other_text' col_2 from dual union all
select 'some text 1' col_1, 'page 2' col_2 from dual union all
select 'some text' col_1, null col_2 from dual union all
select 'some text' col_1, ' *' col_2 from dual union all
select 'some text' col_1, ' ***' col_2 from dual union all
select 'some text' col_1, ' *****' col_2 from dual union all
select 'some text' col_1, ' ***' col_2 from dual union all
select 'some text' col_1, ' *' col_2 from dual union all
select 'some text' col_1, 'green' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 10' col_1, 'some_other_text' col_2 from dual union all
select 'some text 11' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 20' col_1, 'some_other_text' col_2 from dual union all
select 'some text 21' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'bla bla bla' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 30' col_1, 'some_other_text' col_2 from dual union all
select 'some text 31' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'Strawberry' col_2 from dual union all
select 'some text' col_1, 'fields' col_2 from dual union all
select 'some text' col_1, 'for' col_2 from dual union all
select 'some text' col_1, 'ever' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 40' col_1, 'some_other_text' col_2 from dual union all
select 'some text 41' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text' col_1, 'some_other_text' col_2 from dual union all
select 'some text 50' col_1, 'some_other_text' col_2 from dual union all
select 'some text 51' col_1, 'some_other_text' col_2 from dual union all
select 'some text 52' col_1, 'some_other_text' col_2 from dual union all
select 'some text 53' col_1, 'some_other_text' col_2 from dual union all
select 'some text 54' col_1, 'some_other_text' col_2 from dual union all
select 'some text 55' col_1, 'some_other_text' col_2 from dual union all
select 'some text 56' col_1, 'some_other_text' col_2 from dual union all
select 'some text 57' col_1, 'some_other_text' col_2 from dual union all
select 'some text 58' col_1, 'some_other_text' col_2 from dual union all
select 'some text 59' col_1, 'some_other_text' col_2 from dual union all
select 'some text 60' col_1, 'some_other_text' col_2 from dual union all
select 'some text 61' col_1, 'some_other_text' col_2 from dual union all
select 'some text 62' col_1, 'some_other_text' col_2 from dual union all
select 'some text 63' col_1, 'some_other_text' col_2 from dual union all
select 'some text 64' col_1, 'some_other_text' col_2 from dual union all
select 'some text 65' col_1, 'some_other_text' col_2 from dual union all
select '3rd page' col_1, 'some_other_text' col_2 from dual
--------------]]>
</queryString>
<field name="COL_1" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription></field>
<field name="COL_2" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription></field>
<background> <band splitType="Stretch"/> </background>
<title> <band height="0" splitType="Stretch"/> </title>
<pageHeader> <band height="0" splitType="Stretch"/> </pageHeader>
<columnHeader> <band height="0" splitType="Stretch"/> </columnHeader>
<detail>
<band height="13" splitType="Stretch">
<textField> <reportElement x= "0" y="0" width="100" height="13"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{COL_1}]]></textFieldExpression> </textField>
<textField> <reportElement x="400" y="0" width="100" height="13"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{COL_2}]]></textFieldExpression> </textField>
</band>
</detail>
<columnFooter> <band height="0" splitType="Stretch"/> </columnFooter>
<pageFooter> <band height="0" splitType="Stretch"/> </pageFooter>
<summary> <band height="0" splitType="Stretch"/> </summary>
<!-- lastPageFooter (?) -->
</jasperReport>