| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Jasper - Ascii Exports | ||
|
Trying to figure out the breaking y-coordinate value in order for a (text-)element to appear on a different line. I suggest to set the
export options in iReport under Extra->Options->Export options. The interesting options to set are Character Width and Character Height (found under Text)
<?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 = "Figuring out how exporting to Ascii REALLY works"
pageWidth = "415"
pageHeight = "798"
columnWidth = "415"
leftMargin = "0"
rightMargin = "0"
topMargin = "0"
bottomMargin = "0"
>
<queryString> <![CDATA[select null from dual]]> </queryString>
<detail>
<band height="798">
<staticText>
<reportElement x='0' y='0' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[0]]></text>
</staticText>
<staticText>
<reportElement x='1' y='14' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[1]]></text>
</staticText>
<staticText>
<reportElement x='2' y='28' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[2]]></text>
</staticText>
<staticText>
<reportElement x='3' y='42' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[3]]></text>
</staticText>
<staticText>
<reportElement x='4' y='56' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[4]]></text>
</staticText>
<staticText>
<reportElement x='5' y='70' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[5]]></text>
</staticText>
<staticText>
<reportElement x='6' y='84' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[6]]></text>
</staticText>
<staticText>
<reportElement x='7' y='98' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[7]]></text>
</staticText>
<staticText>
<reportElement x='8' y='112' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[8]]></text>
</staticText>
<staticText>
<reportElement x='9' y='126' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[9]]></text>
</staticText>
<staticText>
<reportElement x='10' y='140' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[10]]></text>
</staticText>
<staticText>
<reportElement x='11' y='154' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[11]]></text>
</staticText>
<staticText>
<reportElement x='12' y='168' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[12]]></text>
</staticText>
<staticText>
<reportElement x='13' y='182' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[13]]></text>
</staticText>
<staticText>
<reportElement x='14' y='196' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[14]]></text>
</staticText>
<staticText>
<reportElement x='15' y='210' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[15]]></text>
</staticText>
<staticText>
<reportElement x='16' y='224' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[16]]></text>
</staticText>
<staticText>
<reportElement x='17' y='238' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[17]]></text>
</staticText>
<staticText>
<reportElement x='18' y='252' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[18]]></text>
</staticText>
<staticText>
<reportElement x='19' y='266' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[19]]></text>
</staticText>
<staticText>
<reportElement x='20' y='280' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[20]]></text>
</staticText>
<staticText>
<reportElement x='21' y='294' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[21]]></text>
</staticText>
<staticText>
<reportElement x='22' y='308' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[22]]></text>
</staticText>
<staticText>
<reportElement x='23' y='322' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[23]]></text>
</staticText>
<staticText>
<reportElement x='24' y='336' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[24]]></text>
</staticText>
<staticText>
<reportElement x='25' y='350' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[25]]></text>
</staticText>
<staticText>
<reportElement x='26' y='364' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[26]]></text>
</staticText>
<staticText>
<reportElement x='27' y='378' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[27]]></text>
</staticText>
<staticText>
<reportElement x='28' y='392' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[28]]></text>
</staticText>
<staticText>
<reportElement x='29' y='406' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[29]]></text>
</staticText>
<staticText>
<reportElement x='30' y='420' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[30]]></text>
</staticText>
<staticText>
<reportElement x='31' y='434' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[31]]></text>
</staticText>
<staticText>
<reportElement x='32' y='448' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[32]]></text>
</staticText>
<staticText>
<reportElement x='33' y='462' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[33]]></text>
</staticText>
<staticText>
<reportElement x='34' y='476' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[34]]></text>
</staticText>
<staticText>
<reportElement x='35' y='490' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[35]]></text>
</staticText>
<staticText>
<reportElement x='36' y='504' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[36]]></text>
</staticText>
<staticText>
<reportElement x='37' y='518' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[37]]></text>
</staticText>
<staticText>
<reportElement x='38' y='532' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[38]]></text>
</staticText>
<staticText>
<reportElement x='39' y='546' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[39]]></text>
</staticText>
<staticText>
<reportElement x='40' y='560' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[40]]></text>
</staticText>
<staticText>
<reportElement x='41' y='574' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[41]]></text>
</staticText>
<staticText>
<reportElement x='42' y='588' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[42]]></text>
</staticText>
<staticText>
<reportElement x='43' y='602' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[43]]></text>
</staticText>
<staticText>
<reportElement x='44' y='616' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[44]]></text>
</staticText>
<staticText>
<reportElement x='45' y='630' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[45]]></text>
</staticText>
<staticText>
<reportElement x='46' y='644' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[46]]></text>
</staticText>
<staticText>
<reportElement x='47' y='658' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[47]]></text>
</staticText>
<staticText>
<reportElement x='48' y='672' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[48]]></text>
</staticText>
<staticText>
<reportElement x='49' y='686' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[49]]></text>
</staticText>
<staticText>
<reportElement x='50' y='700' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[50]]></text>
</staticText>
<staticText>
<reportElement x='51' y='714' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[51]]></text>
</staticText>
<staticText>
<reportElement x='52' y='728' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[52]]></text>
</staticText>
<staticText>
<reportElement x='53' y='742' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[53]]></text>
</staticText>
<staticText>
<reportElement x='54' y='756' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[54]]></text>
</staticText>
<staticText>
<reportElement x='55' y='770' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[55]]></text>
</staticText>
<staticText>
<reportElement x='56' y='784' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[56]]></text>
</staticText>
</band>
</detail>
</jasperReport>
<?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 = "Figuring out how exporting to Ascii REALLY works"
pageWidth = "581"
pageHeight = "798"
columnWidth = "581"
leftMargin = "0"
rightMargin = "0"
topMargin = "0"
bottomMargin = "0"
>
<queryString> <![CDATA[select null from dual]]> </queryString>
<title>
<band height="798">
<staticText>
<reportElement x='0' y='0' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\0]]></text>
</staticText>
<staticText>
<reportElement x='7' y='14' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\1]]></text>
</staticText>
<staticText>
<reportElement x='14' y='28' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\2]]></text>
</staticText>
<staticText>
<reportElement x='21' y='42' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\3]]></text>
</staticText>
<staticText>
<reportElement x='28' y='56' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\4]]></text>
</staticText>
<staticText>
<reportElement x='35' y='70' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\5]]></text>
</staticText>
<staticText>
<reportElement x='42' y='84' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\6]]></text>
</staticText>
<staticText>
<reportElement x='49' y='98' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\7]]></text>
</staticText>
<staticText>
<reportElement x='56' y='112' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\8]]></text>
</staticText>
<staticText>
<reportElement x='63' y='126' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\9]]></text>
</staticText>
<staticText>
<reportElement x='70' y='140' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\10]]></text>
</staticText>
<staticText>
<reportElement x='77' y='154' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\11]]></text>
</staticText>
<staticText>
<reportElement x='84' y='168' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\12]]></text>
</staticText>
<staticText>
<reportElement x='91' y='182' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\13]]></text>
</staticText>
<staticText>
<reportElement x='98' y='196' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\14]]></text>
</staticText>
<staticText>
<reportElement x='105' y='210' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\15]]></text>
</staticText>
<staticText>
<reportElement x='112' y='224' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\16]]></text>
</staticText>
<staticText>
<reportElement x='119' y='238' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\17]]></text>
</staticText>
<staticText>
<reportElement x='126' y='252' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\18]]></text>
</staticText>
<staticText>
<reportElement x='133' y='266' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\19]]></text>
</staticText>
<staticText>
<reportElement x='140' y='280' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\20]]></text>
</staticText>
<staticText>
<reportElement x='147' y='294' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\21]]></text>
</staticText>
<staticText>
<reportElement x='154' y='308' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\22]]></text>
</staticText>
<staticText>
<reportElement x='161' y='322' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\23]]></text>
</staticText>
<staticText>
<reportElement x='168' y='336' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\24]]></text>
</staticText>
<staticText>
<reportElement x='175' y='350' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\25]]></text>
</staticText>
<staticText>
<reportElement x='182' y='364' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\26]]></text>
</staticText>
<staticText>
<reportElement x='189' y='378' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\27]]></text>
</staticText>
<staticText>
<reportElement x='196' y='392' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\28]]></text>
</staticText>
<staticText>
<reportElement x='203' y='406' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\29]]></text>
</staticText>
<staticText>
<reportElement x='210' y='420' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\30]]></text>
</staticText>
<staticText>
<reportElement x='217' y='434' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\31]]></text>
</staticText>
<staticText>
<reportElement x='224' y='448' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\32]]></text>
</staticText>
<staticText>
<reportElement x='231' y='462' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\33]]></text>
</staticText>
<staticText>
<reportElement x='238' y='476' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\34]]></text>
</staticText>
<staticText>
<reportElement x='245' y='490' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\35]]></text>
</staticText>
<staticText>
<reportElement x='252' y='504' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\36]]></text>
</staticText>
<staticText>
<reportElement x='259' y='518' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\37]]></text>
</staticText>
<staticText>
<reportElement x='266' y='532' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\38]]></text>
</staticText>
<staticText>
<reportElement x='273' y='546' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\39]]></text>
</staticText>
<staticText>
<reportElement x='280' y='560' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\40]]></text>
</staticText>
<staticText>
<reportElement x='287' y='574' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\41]]></text>
</staticText>
<staticText>
<reportElement x='294' y='588' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\42]]></text>
</staticText>
<staticText>
<reportElement x='301' y='602' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\43]]></text>
</staticText>
<staticText>
<reportElement x='308' y='616' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\44]]></text>
</staticText>
<staticText>
<reportElement x='315' y='630' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\45]]></text>
</staticText>
<staticText>
<reportElement x='322' y='644' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\46]]></text>
</staticText>
<staticText>
<reportElement x='329' y='658' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\47]]></text>
</staticText>
<staticText>
<reportElement x='336' y='672' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\48]]></text>
</staticText>
<staticText>
<reportElement x='343' y='686' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\49]]></text>
</staticText>
<staticText>
<reportElement x='350' y='700' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\50]]></text>
</staticText>
<staticText>
<reportElement x='357' y='714' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\51]]></text>
</staticText>
<staticText>
<reportElement x='364' y='728' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\52]]></text>
</staticText>
<staticText>
<reportElement x='371' y='742' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\53]]></text>
</staticText>
<staticText>
<reportElement x='378' y='756' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\54]]></text>
</staticText>
<staticText>
<reportElement x='385' y='770' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\55]]></text>
</staticText>
<staticText>
<reportElement x='392' y='784' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\56]]></text>
</staticText>
</band>
</title>
<detail>
<band height="798">
<staticText>
<reportElement x='1' y='0' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\0]]></text>
</staticText>
<staticText>
<reportElement x='8' y='14' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\1]]></text>
</staticText>
<staticText>
<reportElement x='15' y='28' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\2]]></text>
</staticText>
<staticText>
<reportElement x='22' y='42' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\3]]></text>
</staticText>
<staticText>
<reportElement x='29' y='56' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\4]]></text>
</staticText>
<staticText>
<reportElement x='36' y='70' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\5]]></text>
</staticText>
<staticText>
<reportElement x='43' y='84' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\6]]></text>
</staticText>
<staticText>
<reportElement x='50' y='98' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\7]]></text>
</staticText>
<staticText>
<reportElement x='57' y='112' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\8]]></text>
</staticText>
<staticText>
<reportElement x='64' y='126' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\9]]></text>
</staticText>
<staticText>
<reportElement x='71' y='140' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\10]]></text>
</staticText>
<staticText>
<reportElement x='78' y='154' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\11]]></text>
</staticText>
<staticText>
<reportElement x='85' y='168' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\12]]></text>
</staticText>
<staticText>
<reportElement x='92' y='182' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\13]]></text>
</staticText>
<staticText>
<reportElement x='99' y='196' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\14]]></text>
</staticText>
<staticText>
<reportElement x='106' y='210' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\15]]></text>
</staticText>
<staticText>
<reportElement x='113' y='224' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\16]]></text>
</staticText>
<staticText>
<reportElement x='120' y='238' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\17]]></text>
</staticText>
<staticText>
<reportElement x='127' y='252' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\18]]></text>
</staticText>
<staticText>
<reportElement x='134' y='266' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\19]]></text>
</staticText>
<staticText>
<reportElement x='141' y='280' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\20]]></text>
</staticText>
<staticText>
<reportElement x='148' y='294' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\21]]></text>
</staticText>
<staticText>
<reportElement x='155' y='308' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\22]]></text>
</staticText>
<staticText>
<reportElement x='162' y='322' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\23]]></text>
</staticText>
<staticText>
<reportElement x='169' y='336' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\24]]></text>
</staticText>
<staticText>
<reportElement x='176' y='350' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\25]]></text>
</staticText>
<staticText>
<reportElement x='183' y='364' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\26]]></text>
</staticText>
<staticText>
<reportElement x='190' y='378' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\27]]></text>
</staticText>
<staticText>
<reportElement x='197' y='392' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\28]]></text>
</staticText>
<staticText>
<reportElement x='204' y='406' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\29]]></text>
</staticText>
<staticText>
<reportElement x='211' y='420' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\30]]></text>
</staticText>
<staticText>
<reportElement x='218' y='434' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\31]]></text>
</staticText>
<staticText>
<reportElement x='225' y='448' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\32]]></text>
</staticText>
<staticText>
<reportElement x='232' y='462' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\33]]></text>
</staticText>
<staticText>
<reportElement x='239' y='476' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\34]]></text>
</staticText>
<staticText>
<reportElement x='246' y='490' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\35]]></text>
</staticText>
<staticText>
<reportElement x='253' y='504' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\36]]></text>
</staticText>
<staticText>
<reportElement x='260' y='518' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\37]]></text>
</staticText>
<staticText>
<reportElement x='267' y='532' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\38]]></text>
</staticText>
<staticText>
<reportElement x='274' y='546' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\39]]></text>
</staticText>
<staticText>
<reportElement x='281' y='560' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\40]]></text>
</staticText>
<staticText>
<reportElement x='288' y='574' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\41]]></text>
</staticText>
<staticText>
<reportElement x='295' y='588' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\42]]></text>
</staticText>
<staticText>
<reportElement x='302' y='602' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\43]]></text>
</staticText>
<staticText>
<reportElement x='309' y='616' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\44]]></text>
</staticText>
<staticText>
<reportElement x='316' y='630' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\45]]></text>
</staticText>
<staticText>
<reportElement x='323' y='644' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\46]]></text>
</staticText>
<staticText>
<reportElement x='330' y='658' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\47]]></text>
</staticText>
<staticText>
<reportElement x='337' y='672' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\48]]></text>
</staticText>
<staticText>
<reportElement x='344' y='686' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\49]]></text>
</staticText>
<staticText>
<reportElement x='351' y='700' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\50]]></text>
</staticText>
<staticText>
<reportElement x='358' y='714' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\51]]></text>
</staticText>
<staticText>
<reportElement x='365' y='728' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\52]]></text>
</staticText>
<staticText>
<reportElement x='372' y='742' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\53]]></text>
</staticText>
<staticText>
<reportElement x='379' y='756' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\54]]></text>
</staticText>
<staticText>
<reportElement x='386' y='770' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\55]]></text>
</staticText>
<staticText>
<reportElement x='393' y='784' width='30' height='14'/>
<textElement><font fontName='Courier New' size='12'/></textElement>
<text><![CDATA[\56]]></text>
</staticText>
</band>
</detail>
</jasperReport>
<?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="AC0130" pageWidth="1000" pageHeight="924" columnWidth="1000" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isTitleNewPage="true" isSummaryNewPage="true">
<queryString>
<![CDATA[select dummy from dual]]>
</queryString>
<title>
<band height="924" splitType="Stretch">
<textField>
<reportElement x="329" y="252" width="84" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["exactly"]]></textFieldExpression>
</textField>
<textField>
<reportElement x="329" y="224" width="28" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[new java.math.BigDecimal(1.22)]]></textFieldExpression>
</textField>
<textField>
<reportElement x="329" y="280" width="35" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Cool ey"]]></textFieldExpression>
</textField>
<textField pattern="dd.MM.yyyy HH:mm:ss">
<reportElement x="329" y="154" width="266" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="190" y="224" width="105" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*--- 12 ---#]]></text>
</staticText>
<staticText>
<reportElement x="330" y="126" width="343" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*------------------- 47 ----------------------#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="252" width="98" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*--- 13 ----#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="126" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*---- 13 ---#]]></text>
</staticText>
<staticText>
<reportElement x="1" y="28" width="7" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[1]]></text>
</staticText>
<staticText>
<reportElement x="1" y="28" width="721" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*------------ 34 ----------------#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="98" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*--- 12 ---#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="280" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*-- 10 --#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="154" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*- 5-#]]></text>
</staticText>
<staticText>
<reportElement x="330" y="98" width="266" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*- 6-#]]></text>
</staticText>
<staticText>
<reportElement x="190" y="196" width="77" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*--- 11 --#]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="84">
<textField pattern="dd.MM.yyyy HH:mm:ss">
<reportElement x="749" y="14" width="140" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="92" y="14" width="112" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[AC0130]]></text>
</staticText>
<staticText>
<reportElement x="8" y="14" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Report Id: ]]></text>
</staticText>
<staticText>
<reportElement x="92" y="56" width="336" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[VERBUCHTE, NOCH NICHT AN VU VERGUETETE BETRAEGE-]]></text>
</staticText>
<staticText>
<reportElement x="1" y="14" width="7" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[!]]></text>
</staticText>
<staticText>
<reportElement x="1" y="28" width="8" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[?]]></text>
</staticText>
<staticText>
<reportElement x="8" y="28" width="7" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[/]]></text>
</staticText>
<staticText>
<reportElement x="673" y="14" width="42" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Date:]]></text>
</staticText>
<staticText>
<reportElement x="8" y="42" width="84" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Mandant Id:]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="42">
<staticText>
<reportElement x="435" y="0" width="49" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Blocked]]></text>
</staticText>
<staticText>
<reportElement x="757" y="0" width="126" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[BETRAG HABEN]]></text>
</staticText>
<staticText>
<reportElement x="92" y="0" width="84" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[PARTNER NAME]]></text>
</staticText>
<staticText>
<reportElement x="498" y="0" width="77" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Extvpno]]></text>
</staticText>
<staticText>
<reportElement x="8" y="0" width="126" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[KONTO]]></text>
</staticText>
<staticText>
<reportElement x="582" y="0" width="56" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[CURRENCY]]></text>
</staticText>
<staticText>
<reportElement x="631" y="0" width="119" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[BETRAG SOLL]]></text>
</staticText>
</band>
<band height="98">
<staticText>
<reportElement x="757" y="56" width="126" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[BETRAG HABEN TOTAL]]></text>
</staticText>
<staticText>
<reportElement x="8" y="56" width="140" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Total Pro Currency ]]></text>
</staticText>
<staticText>
<reportElement x="631" y="56" width="119" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[BETRAG SOLL TOTAL]]></text>
</staticText>
<staticText>
<reportElement x="582" y="56" width="56" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[CURRENCY]]></text>
</staticText>
</band>
</detail>
<pageFooter>
<band height="84" splitType="Stretch">
<textField>
<reportElement x="588" y="14" width="112" height="14"/>
<textElement textAlignment="Right">
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Seite "+$V{PAGE_NUMBER}+" von"]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="700" y="14" width="56" height="14"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="924" splitType="Stretch">
<staticText>
<reportElement x="358" y="98" width="259" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[AC0130]]></text>
</staticText>
<staticText>
<reportElement x="239" y="126" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Report Name: ]]></text>
</staticText>
<staticText>
<reportElement x="239" y="98" width="91" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[Report Id: ]]></text>
</staticText>
<staticText>
<reportElement x="1" y="98" width="7" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*]]></text>
</staticText>
<staticText>
<reportElement x="1" y="196" width="728" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*** E N D O F L I S T ***]]></text>
</staticText>
<staticText>
<reportElement x="358" y="126" width="336" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*99999999, 4444 55555 22 22 1010101010 99999999#]]></text>
</staticText>
<staticText>
<reportElement x="358" y="140" width="337" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*99999999, 4444 55555 22 22 1010101010 99999999#]]></text>
</staticText>
<staticText>
<reportElement x="357" y="154" width="336" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*99999999, 4444 55555 22 22 1010101010 99999999#]]></text>
</staticText>
<staticText>
<reportElement x="357" y="168" width="337" height="14"/>
<textElement textAlignment="Left">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[*99999999, 4444 55555 22 22 1010101010 99999999#]]></text>
</staticText>
</band>
</summary>
</jasperReport>
See also other Jasper examples.
|