paulo.ferreira_2

That's rigth. It works fine now. Thanks.

Here is the source of the main report: (the subreport works if it runs separately) body { margin: 3px; height: 95%; } body { margin: 3px; height: 95%; } <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2016-12-19T09:07:06 --> <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="Blank_A4_1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fa8ae9e5-5443-4a11-aa58-1e42b579870e"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="351"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="638"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="GoldStar - Aceite"/> <parameter name="NOME_CLIENTE" class="java.lang.String"> <parameterDescription><![CDATA[Nome do Cliente]]></parameterDescription> </parameter> <parameter name="CODIGO_CONTRATO" class="java.lang.Integer"> <parameterDescription><![CDATA[Codigo do Contrato]]></parameterDescription> </parameter> <queryString language="SQL"> <![CDATA[sELECT * FROM LEC_CONTRATO INNER JOIN LEC_CLIENTE ON LEC_CLIENTE.ID_CLIENTE = LEC_CONTRATO.ID_CLIENTE WHERE LEC_CLIENTE.RAZAO_SOCIAL LIKE '%$P!{NOME_CLIENTE}%' AND LEC_CONTRATO.CODIGO_CONTRATO = $P{CODIGO_CONTRATO}]]> </queryString> <field name="id_contrato" class="java.lang.Integer"/> <field name="codigo_contrato" class="java.lang.Integer"/> <field name="segmento" class="java.lang.String"/> <field name="id_cliente" class="java.lang.Integer"/> <field name="previsao_implantacao" class="java.sql.Date"/> <field name="id_operadora" class="java.lang.Integer"/> <field name="n_Vidas_Estimado" class="java.lang.Integer"/> <field name="estimativa_fatura_Mes1" class="java.math.BigDecimal"/> <field name="regra_Contribuicao" class="java.lang.String"/> <field name="regra_Coparticipacao" class="java.lang.String"/> <field name="tipo_Produto" class="java.lang.String"/> <field name="tipo_Negociacao" class="java.lang.String"/> <field name="break_even" class="java.math.BigDecimal"/> <field name="agenciamento" class="java.math.BigDecimal"/> <field name="pagamento_Agenciamento" class="java.lang.Integer"/> <field name="comissao_Vitalicia" class="java.math.BigDecimal"/> <field name="inicio_Processo" class="java.sql.Date"/> <field name="periodo_implantacao" class="java.lang.Integer"/> <field name="vigencia_Inicial" class="java.sql.Date"/> <field name="vigencia_Final" class="java.sql.Date"/> <field name="check_List_Implantacao" class="java.math.BigDecimal"/> <field name="documentacao_Inclusao" class="java.lang.String"/> <field name="documentacao_Exclusao" class="java.lang.String"/> <field name="contatos_operadora" class="java.lang.String"/> <field name="projeto_especifico" class="java.lang.String"/> <field name="contatos_cliente" class="java.lang.String"/> <field name="faturamento_estipulante_Subs" class="java.lang.String"/> <field name="outras_informacoes" class="java.lang.String"/> <field name="qtde_meses_carencia" class="java.lang.Integer"/> <field name="data_final_implantacao" class="java.sql.Date"/> <field name="down_Upgrade" class="java.lang.String"/> <field name="qtde_Minima_Vidas" class="java.math.BigDecimal"/> <field name="cancelamento_Contrato" class="java.lang.Integer"/> <field name="periodo_aviso_previo" class="java.lang.Integer"/> <field name="Data_Corte_Cliente" class="java.lang.Integer"/> <field name="Data_Corte_Operadora" class="java.lang.Integer"/> <field name="local_input" class="java.lang.String"/> <field name="janela_inclusao_titular" class="java.lang.Integer"/> <field name="janela_inclusao_dependente" class="java.lang.Integer"/> <field name="tipo_inclusao" class="java.lang.String"/> <field name="tipo_exclusao" class="java.lang.String"/> <field name="login_sistema_operadora_m" class="java.lang.String"/> <field name="senha_sistema_operadora_m" class="java.lang.String"/> <field name="tipo" class="java.lang.String"/> <field name="disponivel" class="java.lang.Integer"/> <field name="envio_ao_cliente" class="java.lang.Integer"/> <field name="vencimento" class="java.lang.Integer"/> <field name="login_sistema_operadora_f" class="java.lang.String"/> <field name="senha_Sistema_operadora_f" class="java.lang.String"/> <field name="COLUMN_50" class="java.lang.Integer"/> <field name="razao_social" class="java.lang.String"/> <field name="cnpj" class="java.lang.String"/> <field name="endereco_completo" class="java.lang.String"/> <field name="COLUMN_54" class="java.lang.String"/> <field name="email" class="java.lang.String"/> <field name="telefone" class="java.lang.String"/> <field name="ativo" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="66" splitType="Stretch"> <staticText> <reportElement x="0" y="36" width="240" height="30" uuid="f4f5caed-218e-4210-ad26-50a43df2bb9e"/> <text><![CDATA[razao_social]]></text> </staticText> <staticText> <reportElement x="250" y="36" width="100" height="30" uuid="bbe6b0d9-c71d-4570-9893-53584b596691"/> <text><![CDATA[codigo_contrato]]></text> </staticText> </band> </columnHeader> <detail> <band height="283" splitType="Stretch"> <textField> <reportElement x="0" y="10" width="240" height="30" uuid="786a37e6-63c3-44cc-9103-b0a37a68b2c4"/> <textFieldExpression><![CDATA[$F{razao_social}]]></textFieldExpression> </textField> <textField> <reportElement x="250" y="10" width="100" height="30" uuid="1bb95ada-9a1e-4928-8f3a-bbe8e73bb72d"/> <textFieldExpression><![CDATA[$F{codigo_contrato}]]></textFieldExpression> </textField> <textField> <reportElement x="370" y="10" width="100" height="30" uuid="cce27732-aae0-4d35-aeac-b7ceafa27608"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{id_contrato}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="209" splitType="Stretch"> <subreport> <reportElement x="60" y="80" width="200" height="99" uuid="c3d91172-d54c-4abd-82b7-15aed4d45803"/> <subreportParameter name="ID_CONTRATO"> <subreportParameterExpression><![CDATA[$F{id_contrato}]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["subRep.jasper"]]></subreportExpression> </subreport> </band> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>body { margin: 3px; height: 95%; } <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2016-12-19T09:07:06 --> <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="Blank_A4_1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="fa8ae9e5-5443-4a11-aa58-1e42b579870e"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="351"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="638"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="GoldStar - Aceite"/> <parameter name="NOME_CLIENTE" class="java.lang.String"> <parameterDescription><![CDATA[Nome do Cliente]]></parameterDescription> </parameter> <parameter name="CODIGO_CONTRATO" class="java.lang.Integer"> <parameterDescription><![CDATA[Codigo do Contrato]]></parameterDescription> </parameter> <queryString language="SQL"> <![CDATA[sELECT * FROM LEC_CONTRATO INNER JOIN LEC_CLIENTE ON LEC_CLIENTE.ID_CLIENTE = LEC_CONTRATO.ID_CLIENTE WHERE LEC_CLIENTE.RAZAO_SOCIAL LIKE '%$P!{NOME_CLIENTE}%' AND LEC_CONTRATO.CODIGO_CONTRATO = $P{CODIGO_CONTRATO}]]> </queryString> <field name="id_contrato" class="java.lang.Integer"/> <field name="codigo_contrato" class="java.lang.Integer"/> <field name="segmento" class="java.lang.String"/> <field name="id_cliente" class="java.lang.Integer"/> <field name="previsao_implantacao" class="java.sql.Date"/> <field name="id_operadora" class="java.lang.Integer"/> <field name="n_Vidas_Estimado" class="java.lang.Integer"/> <field name="estimativa_fatura_Mes1" class="java.math.BigDecimal"/> <field name="regra_Contribuicao" class="java.lang.String"/> <field name="regra_Coparticipacao" class="java.lang.String"/> <field name="tipo_Produto" class="java.lang.String"/> <field name="tipo_Negociacao" class="java.lang.String"/> <field name="break_even" class="java.math.BigDecimal"/> <field name="agenciamento" class="java.math.BigDecimal"/> <field name="pagamento_Agenciamento" class="java.lang.Integer"/> <field name="comissao_Vitalicia" class="java.math.BigDecimal"/> <field name="inicio_Processo" class="java.sql.Date"/> <field name="periodo_implantacao" class="java.lang.Integer"/> <field name="vigencia_Inicial" class="java.sql.Date"/> <field name="vigencia_Final" class="java.sql.Date"/> <field name="check_List_Implantacao" class="java.math.BigDecimal"/> <field name="documentacao_Inclusao" class="java.lang.String"/> <field name="documentacao_Exclusao" class="java.lang.String"/> <field name="contatos_operadora" class="java.lang.String"/> <field name="projeto_especifico" class="java.lang.String"/> <field name="contatos_cliente" class="java.lang.String"/> <field name="faturamento_estipulante_Subs" class="java.lang.String"/> <field name="outras_informacoes" class="java.lang.String"/> <field name="qtde_meses_carencia" class="java.lang.Integer"/> <field name="data_final_implantacao" class="java.sql.Date"/> <field name="down_Upgrade" class="java.lang.String"/> <field name="qtde_Minima_Vidas" class="java.math.BigDecimal"/> <field name="cancelamento_Contrato" class="java.lang.Integer"/> <field name="periodo_aviso_previo" class="java.lang.Integer"/> <field name="Data_Corte_Cliente" class="java.lang.Integer"/> <field name="Data_Corte_Operadora" class="java.lang.Integer"/> <field name="local_input" class="java.lang.String"/> <field name="janela_inclusao_titular" class="java.lang.Integer"/> <field name="janela_inclusao_dependente" class="java.lang.Integer"/> <field name="tipo_inclusao" class="java.lang.String"/> <field name="tipo_exclusao" class="java.lang.String"/> <field name="login_sistema_operadora_m" class="java.lang.String"/> <field name="senha_sistema_operadora_m" class="java.lang.String"/> <field name="tipo" class="java.lang.String"/> <field name="disponivel" class="java.lang.Integer"/> <field name="envio_ao_cliente" class="java.lang.Integer"/> <field name="vencimento" class="java.lang.Integer"/> <field name="login_sistema_operadora_f" class="java.lang.String"/> <field name="senha_Sistema_operadora_f" class="java.lang.String"/> <field name="COLUMN_50" class="java.lang.Integer"/> <field name="razao_social" class="java.lang.String"/> <field name="cnpj" class="java.lang.String"/> <field name="endereco_completo" class="java.lang.String"/> <field name="COLUMN_54" class="java.lang.String"/> <field name="email" class="java.lang.String"/> <field name="telefone" class="java.lang.String"/> <field name="ativo" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="66" splitType="Stretch"> <staticText> <reportElement x="0" y="36" width="240" height="30" uuid="f4f5caed-218e-4210-ad26-50a43df2bb9e"/> <text><![CDATA[razao_social]]></text> </staticText> <staticText> <reportElement x="250" y="36" width="100" height="30" uuid="bbe6b0d9-c71d-4570-9893-53584b596691"/> <text><![CDATA[codigo_contrato]]></text> </staticText> </band> </columnHeader> <detail> <band height="283" splitType="Stretch"> <textField> <reportElement x="0" y="10" width="240" height="30" uuid="786a37e6-63c3-44cc-9103-b0a37a68b2c4"/> <textFieldExpression><![CDATA[$F{razao_social}]]></textFieldExpression> </textField> <textField> <reportElement x="250" y="10" width="100" height="30" uuid="1bb95ada-9a1e-4928-8f3a-bbe8e73bb72d"/> <textFieldExpression><![CDATA[$F{codigo_contrato}]]></textFieldExpression> </textField> <textField> <reportElement x="370" y="10" width="100" height="30" uuid="cce27732-aae0-4d35-aeac-b7ceafa27608"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression><![CDATA[$F{id_contrato}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="209" splitType="Stretch"> <subreport> <reportElement x="60" y="80" width="200" height="99" uuid="c3d91172-d54c-4abd-82b7-15aed4d45803"/> <subreportParameter name="ID_CONTRATO"> <subreportParameterExpression><![CDATA[$F{id_contrato}]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["subRep.jasper"]]></subreportExpression> </subreport> </band> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>