Caros,
Estou com um pequeno problema em gerar relatórios.
Fiz um relatório genérico onde coloco diversos sub-relatórios (por enquanto apenas 1 para ver como funciona!). O resultado é que o sub-relatório se repete pelo número de linhas na tabela (o primeiro subrelatório).
Alguém pode me dar uma idéia?
Obrigado desde já,
Gustavo
O relatório "pai" está assim:<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="SobreavisoDive"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<parameter name="nome_regional" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[Nome do Município Sede da Regional velha]]></parameterDescription>
<defaultValueExpression ><![CDATA["Nome_da_Regional"]]></defaultValueExpression>
</parameter>
<parameter name="mes_relatorio" isForPrompting="false" class="java.lang.String">
<parameterDescription><![CDATA[Mês do Relatório por Extenso]]></parameterDescription>
<defaultValueExpression ><![CDATA["Mes_Do_Relatorio"]]></defaultValueExpression>
</parameter>
<parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String">
<defaultValueExpression ><![CDATA["C:\\Performer\\FWWeb\\Tomcat 5.0\\webapps\\vigilantos_2x\\WEB-INF\\relatorios\\compiled\\"]]></defaultValueExpression>
</parameter>
<queryString><![CDATA[SELECT
*
FROM
`escala_sa`]]></queryString>
<field name="idsobreaviso" class="java.lang.Long"/>
<field name="dataInicio" class="java.sql.Date"/>
<field name="dataFim" class="java.sql.Date"/>
<field name="matricula" class="java.lang.Long"/>
<field name="nome" class="java.lang.String"/>
<field name="cargo" class="java.lang.String"/>
<field name="celular" class="java.lang.String"/>
<field name="telefone" class="java.lang.String"/>
<field name="idregionalvelho" class="java.lang.Integer"/>
<field name="isMotorista" class="java.lang.Boolean"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="19" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="172" isSplitAllowed="true" >
<image evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="7"
y="7"
width="69"
height="69"
key="image-1"/>
<box></box>
<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA["C:\\Performer\\FWWeb\\Tomcat 5.0\\webapps\\vigilantos_2x\\images\\brasaoSC.gif"]]></imageExpression>
</image>
<staticText>
<reportElement
x="23"
y="18"
width="0"
height="0"
key="staticText-13"/>
<box></box>
<textElement>
<font/>
</textElement>
<text><![CDATA[Texto Estático]]></text>
</staticText>
<staticText>
<reportElement
x="85"
y="11"
width="247"
height="66"
key="staticText-14"/>
<box></box>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="11" isBold="true"/>
</textElement>
<text><![CDATA[ESTADO DE SANTA CATARINA
SECRETARIA DE ESTADO DA SAÚDE
SISTEMA ÚNICO DE SAÚDE
SUPERINTENDÊNCIA DE SAÚDE PÚBLICA
DIRETORIA DE VIGILÂNCIA EPIDEMIOLÓGICA]]></text>
</staticText>
<image evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="445"
y="9"
width="83"
height="66"
key="image-2"/>
<box></box>
<graphicElement stretchType="NoStretch"/>
<imageExpression class="java.lang.String"><![CDATA["C:\\Performer\\FWWeb\\Tomcat 5.0\\webapps\\vigilantos_2x\\images\\miniDive.gif"]]></imageExpression>
</image>
<staticText>
<reportElement
x="88"
y="101"
width="29"
height="14"
key="staticText-15"/>
<box></box>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[Mês:]]></text>
</staticText>
<staticText>
<reportElement
x="355"
y="101"
width="29"
height="14"
key="staticText-16"/>
<box></box>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true" isUnderline="true"/>
</textElement>
<text><![CDATA[Ano:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="121"
y="101"
width="70"
height="14"
key="textField-11"/>
<box></box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{mes_relatorio}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="388"
y="101"
width="45"
height="14"
key="textField-12"/>
<box></box>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[new SimpleDateFormat("yyyy").format($F{dataInicio})]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="16"
y="140"
width="504"
height="18"
key="textField-13"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="12" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["ESCALA DE SOBREAVISO PARA A "+$P{nome_regional}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="24" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="22" isSplitAllowed="true" >
<subreport isUsingCache="true">
<reportElement
x="0"
y="0"
width="52"
height="22"
key="subreport-1"/>
<subreportParameter name="nome_regional">
<subreportParameterExpression><![CDATA[$P{nome_regional}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="mes_relatorio">
<subreportParameterExpression><![CDATA[$P{mes_relatorio}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="SUBREPORT_DIR">
<subreportParameterExpression><![CDATA["C:\\Performer\\FWWeb\\Tomcat 5.0\\webapps\\vigilantos_2x\\WEB-INF\\relatorios\\compiled"]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "sub_escala_tecnicos.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
<columnFooter>
<band height="20" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="50" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="4"
y="32"
width="217"
height="15"
key="textField-9"/>
<box></box>
<textElement textAlignment="Left">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Data de Impressão: "+new SimpleDateFormat("dd/MM/yyyy").format(new Date())]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<lastPageFooter>
<band height="49" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="4"
y="30"
width="217"
height="15"
key="textField-10"/>
<box></box>
<textElement textAlignment="Left">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Data de Impressão: "+new SimpleDateFormat("dd/MM/yyyy").format(new Date())]]></textFieldExpression>
</textField>
</band>
</lastPageFooter>
<summary>
<band height="30" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="sub_escala_tecnicos"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<queryString><![CDATA[SELECT
*
FROM
`escala_sa`
WHERE
`isMotorista`=false
]]></queryString>
<field name="idsobreaviso" class="java.lang.Long"/>
<field name="dataInicio" class="java.sql.Date"/>
<field name="dataFim" class="java.sql.Date"/>
<field name="matricula" class="java.lang.Long"/>
<field name="nome" class="java.lang.String"/>
<field name="cargo" class="java.lang.String"/>
<field name="celular" class="java.lang.String"/>
<field name="telefone" class="java.lang.String"/>
<field name="idregionalvelho" class="java.lang.Integer"/>
<field name="isMotorista" class="java.lang.Boolean"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="20" isSplitAllowed="true" >
<staticText>
<reportElement
x="200"
y="0"
width="135"
height="20"
key="staticText-6"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[ESCALA DE TÉCNICOS]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="30" isSplitAllowed="true" >
<rectangle>
<reportElement
x="5"
y="10"
width="525"
height="20"
backcolor="#CCCCFF"
key="rectangle-1"/>
<graphicElement stretchType="NoStretch"/>
</rectangle>
<staticText>
<reportElement
x="6"
y="11"
width="58"
height="18"
forecolor="#000000"
key="staticText-1"
isRemoveLineWhenBlank="true"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[Período]]></text>
</staticText>
<line direction="TopDown">
<reportElement
x="65"
y="10"
width="0"
height="20"
key="line-2"/>
<graphicElement stretchType="NoStretch"/>
</line>
<line direction="TopDown">
<reportElement
x="337"
y="10"
width="0"
height="20"
key="line-4"/>
<graphicElement stretchType="NoStretch"/>
</line>
<staticText>
<reportElement
x="66"
y="11"
width="160"
height="18"
forecolor="#000000"
key="staticText-2"
isRemoveLineWhenBlank="true"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[Nome do Servidor]]></text>
</staticText>
<staticText>
<reportElement
x="228"
y="11"
width="108"
height="18"
forecolor="#000000"
key="staticText-3"
isRemoveLineWhenBlank="true"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[Cargo]]></text>
</staticText>
<staticText>
<reportElement
x="338"
y="11"
width="93"
height="18"
forecolor="#000000"
key="staticText-4"
isRemoveLineWhenBlank="true"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[Celular]]></text>
</staticText>
<staticText>
<reportElement
x="433"
y="11"
width="96"
height="18"
forecolor="#000000"
key="staticText-5"
isRemoveLineWhenBlank="true"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font pdfFontName="Helvetica-Bold" isBold="true"/>
</textElement>
<text><![CDATA[Telefone]]></text>
</staticText>
<line direction="TopDown">
<reportElement
x="432"
y="10"
width="0"
height="20"
key="line-7"/>
<graphicElement stretchType="NoStretch"/>
</line>
<line direction="TopDown">
<reportElement
x="227"
y="11"
width="0"
height="19"
key="line-9"/>
<graphicElement stretchType="NoStretch"/>
</line>
</band>
</columnHeader>
<detail>
<band height="20" isSplitAllowed="true" >
<rectangle>
<reportElement
x="5"
y="0"
width="525"
height="20"
key="rectangle-2"/>
<graphicElement stretchType="NoStretch"/>
</rectangle>
<line direction="TopDown">
<reportElement
x="227"
y="1"
width="0"
height="19"
key="line-3"/>
<graphicElement stretchType="NoStretch"/>
</line>
<line direction="TopDown">
<reportElement
x="432"
y="0"
width="0"
height="20"
key="line-5"/>
<graphicElement stretchType="NoStretch"/>
</line>
<line direction="TopDown">
<reportElement
x="65"
y="0"
width="0"
height="20"
key="line-6"/>
<graphicElement stretchType="NoStretch"/>
</line>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="6"
y="1"
width="58"
height="18"
key="textField-1"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{dataInicio}.getDate()+" a "+$F{dataFim}.getDate()]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="70"
y="1"
width="156"
height="18"
key="textField-2"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nome}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="232"
y="1"
width="104"
height="18"
key="textField-3"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[br.gov.sc.dive.util.ReportClass.getFuncaoSobreaviso($F{isMotorista}.booleanValue(),$F{cargo})]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="342"
y="1"
width="89"
height="18"
key="textField-4"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[br.gov.sc.dive.util.ReportClass.getPhoneFormat($F{celular})]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="437"
y="1"
width="92"
height="18"
key="textField-5"/>
<box></box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[br.gov.sc.dive.util.ReportClass.getPhoneFormat($F{telefone})]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
x="337"
y="0"
width="0"
height="20"
key="line-8"/>
<graphicElement stretchType="NoStretch"/>
</line>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
