Relatório jasper(.xls) sem quebra-página[RESOLVIDO]

Assuntos Gerais
#1

Pessoal,

Sei que o assunto desse post é antigo, e tem muito aqui no fórum quanto em outros sites, porém estou tendo muita dificuldade pra resolve-lo.

Estou criando um layout no jasperReport para gerar relatórios no formato .xls sem quebra-página, porém ele esta saindo com quebra página.

O que eu fiz:
Fui em cada banda(title, detail 1) existe no relatório e desmarquei a opção: ‘split allowed’, e na propriedade ‘split type’ selecionei o ‘Prevent’.
No código do relatório e verifiquei que na tag <jasperReport> existe uma propriedade ‘pageHeight=“900”’, removi ela e ainda assim o relatório imprimi com quebra-página.

Segue abaixo o código do meu relatório e a imagem do meu relatóio com a quebra-página:

&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt; &lt;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="RelAnaliticoConsistModBacen" pageWidth="900" pageHeight="900" orientation="Landscape" columnWidth="900" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenResourceMissingType="Empty"&gt; &lt;property name="ireport.scriptlethandling" value="0"/&gt; &lt;property name="ireport.encoding" value="UTF-8"/&gt; &lt;property name="ireport.zoom" value="1.610510000000001"/&gt; &lt;property name="ireport.x" value="0"/&gt; &lt;property name="ireport.y" value="0"/&gt; &lt;import value="net.sf.jasperreports.engine.*"/&gt; &lt;import value="java.util.*"/&gt; &lt;import value="net.sf.jasperreports.engine.data.*"/&gt; &lt;style name="Estilo_Cores" isDefault="false"&gt; &lt;conditionalStyle&gt; &lt;conditionExpression&gt;&lt;![CDATA[new Boolean(($V{TotalProvisao}.intValue() % 2) == 0)]]&gt;&lt;/conditionExpression&gt; &lt;style isDefault="false" style="Estilo_Cores" mode="Opaque" backcolor="#F7F7F7"/&gt; &lt;/conditionalStyle&gt; &lt;/style&gt; &lt;parameter name="meusParametros" class="***" isForPrompting="**"/&gt; &lt;queryString language="SQL"&gt; &lt;![CDATA[]]&gt; &lt;/queryString&gt; &lt;field name="meusFields" class="***"/&gt; &lt;variable name="minhasVariaveis" class="***" calculation="***"&gt; &lt;variableExpression&gt;&lt;![CDATA[$F{***}]]&gt;&lt;/variableExpression&gt; &lt;/variable&gt; &lt;title&gt; &lt;band height="37" splitType="Prevent"&gt; &lt;staticText&gt; &lt;reportElement key="staticText-25" x="0" y="0" width="900" height="17"/&gt; &lt;box rightPadding="0"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="10" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo ]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-41" x="330" y="17" width="81" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-42" x="411" y="17" width="69" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-43" x="480" y="17" width="57" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-44" x="537" y="17" width="76" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-45" x="613" y="17" width="88" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[Saldo Devedor]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-46" x="701" y="17" width="87" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-47" x="788" y="17" width="112" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-52" x="167" y="17" width="163" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-51" x="0" y="17" width="167" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;/band&gt; &lt;/title&gt; &lt;detail&gt; &lt;band height="20" splitType="Prevent"&gt; &lt;textField pattern="" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-17" x="411" y="0" width="69" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="true"&gt; &lt;reportElement key="textField-20" x="480" y="0" width="57" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-21" x="537" y="0" width="76" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.Integer"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField pattern="#,##0.00" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-22" x="613" y="0" width="88" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.math.BigDecimal"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField pattern="#,##0.00" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-23" x="701" y="0" width="87" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.math.BigDecimal"&gt;&lt;![CDATA[( $F{conteudo} != null ? $F{conteudo} : new BigDecimal(0) )]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-24" x="788" y="0" width="112" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}+" - "+$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-25" x="330" y="0" width="81" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[br.com.conteudo.cro.negocio.util.CROUtils.formataCpfCnpj($F{cpfCnpj})]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-19" x="167" y="0" width="163" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-18" x="0" y="0" width="167" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;/band&gt; &lt;/detail&gt; &lt;/jasperReport&gt;

2011/9/15/ec5f0c986042e8b82aa50b3b9d3b6c90_115965.jpg_1127×596 125 KB

1 curtida
#2

Opa!
Cara, pra fazer ele sem quebra de página, não precisa mexer no Split não.
Vai nas propriedades do teu Report e marca a opção “Ignore Pagination”.
E era isso! hehe
Abraço!

PS: Se tu tens algo no PageHeader, talvez ele se repita onde haveria uma quebra de página. Ao menos tinha um bug na 3.4 que ele fazia isso, agora deve estar corrigido. Caso ele faça, coloca uma Print When Expression no PageHeader

1 curtida
#3

Obs: Quando eu gero no formato .pdf, o relatório sai sem nenhum espaço entre as linhas, sem nenhuma quebra-página.

#4

leoramos, muito obrigado pela dica. Realmente era muito óbvia a solução, fui na propriedade do relatório e marquei a opção ‘Ignore pagination’. Pronto funcionando perfeito.

Vlw

#5

[quote=lucasbemo]Pessoal,

Sei que o assunto desse post é antigo, e tem muito aqui no fórum quanto em outros sites, porém estou tendo muita dificuldade pra resolve-lo.

Estou criando um layout no jasperReport para gerar relatórios no formato .xls sem quebra-página, porém ele esta saindo com quebra página.

O que eu fiz:
Fui em cada banda(title, detail 1) existe no relatório e desmarquei a opção: ‘split allowed’, e na propriedade ‘split type’ selecionei o ‘Prevent’.
No código do relatório e verifiquei que na tag <jasperReport> existe uma propriedade ‘pageHeight=“900”’, removi ela e ainda assim o relatório imprimi com quebra-página.

Segue abaixo o código do meu relatório e a imagem do meu relatóio com a quebra-página:

&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt; &lt;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="RelAnaliticoConsistModBacen" pageWidth="900" pageHeight="900" orientation="Landscape" columnWidth="900" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenResourceMissingType="Empty"&gt; &lt;property name="ireport.scriptlethandling" value="0"/&gt; &lt;property name="ireport.encoding" value="UTF-8"/&gt; &lt;property name="ireport.zoom" value="1.610510000000001"/&gt; &lt;property name="ireport.x" value="0"/&gt; &lt;property name="ireport.y" value="0"/&gt; &lt;import value="net.sf.jasperreports.engine.*"/&gt; &lt;import value="java.util.*"/&gt; &lt;import value="net.sf.jasperreports.engine.data.*"/&gt; &lt;style name="Estilo_Cores" isDefault="false"&gt; &lt;conditionalStyle&gt; &lt;conditionExpression&gt;&lt;![CDATA[new Boolean(($V{TotalProvisao}.intValue() % 2) == 0)]]&gt;&lt;/conditionExpression&gt; &lt;style isDefault="false" style="Estilo_Cores" mode="Opaque" backcolor="#F7F7F7"/&gt; &lt;/conditionalStyle&gt; &lt;/style&gt; &lt;parameter name="meusParametros" class="***" isForPrompting="**"/&gt; &lt;queryString language="SQL"&gt; &lt;![CDATA[]]&gt; &lt;/queryString&gt; &lt;field name="meusFields" class="***"/&gt; &lt;variable name="minhasVariaveis" class="***" calculation="***"&gt; &lt;variableExpression&gt;&lt;![CDATA[$F{***}]]&gt;&lt;/variableExpression&gt; &lt;/variable&gt; &lt;title&gt; &lt;band height="37" splitType="Prevent"&gt; &lt;staticText&gt; &lt;reportElement key="staticText-25" x="0" y="0" width="900" height="17"/&gt; &lt;box rightPadding="0"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="10" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo ]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-41" x="330" y="17" width="81" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-42" x="411" y="17" width="69" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-43" x="480" y="17" width="57" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-44" x="537" y="17" width="76" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-45" x="613" y="17" width="88" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[Saldo Devedor]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-46" x="701" y="17" width="87" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-47" x="788" y="17" width="112" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-52" x="167" y="17" width="163" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;staticText&gt; &lt;reportElement key="staticText-51" x="0" y="17" width="167" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt; <font size="8" /> &lt;/textElement&gt; &lt;text&gt;&lt;![CDATA[conteudo]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;/band&gt; &lt;/title&gt; &lt;detail&gt; &lt;band height="20" splitType="Prevent"&gt; &lt;textField pattern="" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-17" x="411" y="0" width="69" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="true"&gt; &lt;reportElement key="textField-20" x="480" y="0" width="57" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-21" x="537" y="0" width="76" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.Integer"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField pattern="#,##0.00" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-22" x="613" y="0" width="88" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.math.BigDecimal"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField pattern="#,##0.00" isBlankWhenNull="false"&gt; &lt;reportElement key="textField-23" x="701" y="0" width="87" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.math.BigDecimal"&gt;&lt;![CDATA[( $F{conteudo} != null ? $F{conteudo} : new BigDecimal(0) )]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-24" x="788" y="0" width="112" height="20"/&gt; &lt;box rightPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}+" - "+$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-25" x="330" y="0" width="81" height="20"/&gt; &lt;box&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[br.com.conteudo.cro.negocio.util.CROUtils.formataCpfCnpj($F{cpfCnpj})]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-19" x="167" y="0" width="163" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;textField isBlankWhenNull="false"&gt; &lt;reportElement key="textField-18" x="0" y="0" width="167" height="20" isRemoveLineWhenBlank="true"/&gt; &lt;box leftPadding="2"&gt; &lt;pen lineWidth="0.5"/&gt; &lt;topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;bottomPen lineWidth="0.5" lineColor="#000000"/&gt; &lt;rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/&gt; &lt;/box&gt; &lt;textElement verticalAlignment="Middle"&gt; <font size="6"/> &lt;/textElement&gt; &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$F{conteudo}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;/band&gt; &lt;/detail&gt; &lt;/jasperReport&gt;

[/quote]

#6