Problemas com ireport

17 de março de 2009 7 respostas

Kaiser 17 de março de 2009

Oi pessoal,

Eu ja tentei de varias formas passar parametro para o ireport e nao consigo, ja procurei na internet, fiz igual varios exemplos e mesmo assim nao consegui.

private class ActionImprimirEmpresaEscolhida implements ActionListener {
		@Override
		public void actionPerformed(ActionEvent arg0) {

				conexao(); 
		    	String arq = DataBaseOperations.arquivos()+"EmpresaEscolhida.jrxml";   
		   	
				parametro = Integer.parseInt(empresaTextNumeroProc.getText());
					
				HashMap map = new HashMap();
				map.put("query", parametro);    
				
		    	InputStream input = null;
				try {
					input = new FileInputStream(new File(arq));
				} catch (FileNotFoundException e3) {
					// TODO Auto-generated catch block
					e3.printStackTrace();
				}   
		    	JasperDesign design = null;
				try {
					design = JRXmlLoader.load(input);
				} catch (JRException e2) {
					// TODO Auto-generated catch block
					e2.printStackTrace();
				}   
		    	JasperReport report = null;
				try {
					report = JasperCompileManager.compileReport(design);
				} catch (JRException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} 
		    	JasperPrint impressao = null;
				try {
					impressao = JasperFillManager.fillReport(report, map, con);
				} catch (JRException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}   
		    	JasperViewer viewer = new JasperViewer(impressao,false);   
		    	viewer.setVisible(true);  

							
			
		}
	}

se eu tirar as opcoes de paramtro impressao = JasperFillManager.fillReport(report, NULL, con); funciona perfeitamente mas eu preciso do parametro para poder escolher a empresa que sairá na impressao pelo ID.

na parte de consulta de relatorio do ireport falaram pra eu usar a sql SELECT * FROM empresa WHERE id=’$P{query}’, mas creio que as aspas sáo para verificar um modo de palavra.

Alguem pode me ajudar?

7 Respostas

Mero_Aprendiz 17 de mar. de 2009

Olá…
Bem, vamos por partes.
Quando você decide passar parâmetros para o Jasper, e necessário que você também crie uma referência a esse parâmetro no iReport (se você usa o iReport).
Exemplo:
Vamos passar um parâmetro como o ID para uma consulta no iReport

Map<String, Object> parametros = new HashMap<String, Object>()
parametros.put("id", valorDoId);

Feito isso, vamos no iReport e então criamos uma referência ao parametro que será passado:
No iReport, vá em Visualizar, Parâmetros do Relatório, então clique em Novo, no Nome do Parâmetro, informe o nome do parâmetro que você quer usar, usando o mesmo nome que passou para o Mapa (no nosso caso id).

Então, na query dentro do seu relatório você pode usar:

SELECT * FROM empresa WHERE id=$P{id}

Entendeu?

[]'s
JL

Kaiser 17 de mar. de 2009

Entedi sim,

Mero Aprendiz? não parece rsss,

muitissimo obrigado, funcionou certinho, so deu um erro mas logo saquei de cara que faltava mudar algo relacionado a variavel pois a minha variavel é uma int e quando cria o padrao é String, logo depois de “visualizar”, “parametros de relatorio”, “novo” ao criar a variavel precisei mudar para int.

Aproveitando a ocasiao, vc saberia me dizer como passar por parametro uma imagem?

Abs

Mero_Aprendiz 17 de mar. de 2009

Kaiser:
Entedi sim,

Mero Aprendiz? não parece rsss,

muitissimo obrigado, funcionou certinho, so deu um erro mas logo saquei de cara que faltava mudar algo relacionado a variavel pois a minha variavel é uma int e quando cria o padrao é String, logo depois de “visualizar”, “parametros de relatorio”, “novo” ao criar a variavel precisei mudar para int.

Aproveitando a ocasiao, vc saberia me dizer como passar por parametro uma imagem?

Abs

Bem, para passar uma imagem como parametro, você deve usar da mesma forma, passando para o mapa como chave e valor, e no iReport, criar uma referência ao parametro (como fizemos com o id, do mesmo tipo);
Para saber os tipo de objetos que você pode passar como imagem basta ir na aba Imagem e ver na combo Classe de Expressão de Imagem.
Lembrando apenas que os do tipo String deve ser o caminho completo da imagem (Ex.: c:\diretório\imagem.img).

[]'s
JL

Kaiser 19 de mar. de 2009

Tem como passar o valor de uma String pelo ireport.

Eu quero criar uma logica no java onde vai montar a query e passar a query pronta pro ireport.

Ex
No java eu faco assim

String query = “SELECT * FROM empresaFuncionario WHERE empresa=’”+customizadoEmpresaFuncionarioEmpresa+"’";

if (!customizadoEmpresaFuncionarioNome.equals("")){   
        query += "AND nome=\'"+customizadoEmpresaFuncionarioNome+"\'"; 
				
   	if (!customizadoEmpresaFuncionarioAno.equals("")){     
        query +=  "AND ano =\'"+customizadoEmpresaFuncionarioAno+"\'";

   	if (!customizadoEmpresaFuncionarioMes.equals("")){     
	    query +=  "AND ano =\'"+customizadoEmpresaFuncionarioMes+"\'";

Eu preciso fazer assim, porque se o cara nao preencher todos os campos, a tabela nao é gerada pelo ireport, se eu conseguisse passar so a variavel query formando a “Query na consulta de relatorio do irepot” ficaria certinho.

Alguem pode me ajudar?

Kaiser 19 de mar. de 2009

resolvido

basta passar a query por parametro no relatorio do ireport $P!{query}

Kleber-rr 12 de nov. de 2010

Mero_Aprendiz, dá uma ajudinha!!!

estou com problemas no meu subrelatorio. No iReports, ele aparece blz, mas no java, o relatorio principal aparece, mas o subrelatorio fica branco...
Com certeza é barberagem minha, mas ainda não encontrei o erro... provavelmente é de parametrização ou de query (apesar de funcionar direitinho no pgadmin).

Segue abaixo o codigo do método e do jasper do relatorio principal e do sub. Se puder ajudar, agradeço.

Vlws.

método no bean:

public String imprimirRelatorio(ActionEvent event) throws Exception {

        // pegar objeto com actionEvent
        UIComponent link = event.getComponent();
        UIParameter parametro = (UIParameter) link.findComponent("printCod");
        Long id = (Long) parametro.getValue();
        saida = null;
        System.out.println("metodo de impressao");
        String jasper = getDiretorioReal("/jasper");
        Connection conexao = null;

        FacesContext facesContext = FacesContext.getCurrentInstance();
        HttpServletResponse response = (HttpServletResponse) facesContext
                .getExternalContext().getResponse();
        ServletOutputStream servletOutputStream = response.getOutputStream();

        try {
            Connection con = new Conexao().getConexao();
            Statement stm = con.createStatement();
            String query = "SELECT pf.cod_funcionario AS cod_funcionario, es.descricao AS escolaridade_descricao, og.nome AS og_nome, cg.descricao AS cargo_descricao, chs.descricao AS cargahoraria_descricao, uf.uf AS uf, mn.municipios AS municipio, * FROM pforgaogestor pfog INNER JOIN orgaogestor og ON og.cod_orgaogestor = pfog.cod_orgaogestor INNER JOIN cargo cg ON cg.cod_cargo = pfog.cod_cargo INNER JOIN cargahorariasemanal chs ON chs.cod_chs = pfog.cod_chs INNER JOIN funcionario pf ON pf.cod_funcionario = pfog.cod_funcionario INNER JOIN escolaridade es ON es.cod_escolaridade = pf.escolaridade_cod_escolaridade INNER JOIN estados uf ON uf.cod_estado = pf.estados_cod_estados INNER JOIN municipiosrr mn ON mn.cod_municipiosrr = pf.municipiosrr_cod_municipiosrr WHERE pf.cod_funcionario="
                    + id;
            ResultSet rs = stm.executeQuery(query);
            JRResultSetDataSource jrRS = new JRResultSetDataSource(rs);

            // parametros
            Map parametros = new HashMap();
            parametros.put("QUERY", con);
       
            // PARAMETRO ADICIONADO PARA SUBREPORT
            parametros.put("pathPessoafisicaDCsubOG", jasper
                    + "/pessoafisicaDCsubOG.jasper");

            // Mando o jasper gerar o relatório
            JasperPrint rel = JasperFillManager.fillReport(jasper
                    + "/pessoafisicaDC.jasper", parametros, jrRS);

            // exibindo o pdf para impressao
            // JasperViewer.viewReport(rel, false);

            // exportando o pdf
            System.out.println("pdf gerado");
            ByteArrayOutputStream output = new ByteArrayOutputStream();
            JasperExportManager.exportReportToPdfStream(rel, output);
            response.setContentType("application/pdf");
            response.addHeader("Content-Disposition",
                    "attachment;filename=relatorio" + id + ".pdf");
            response.setContentLength(output.size());

            servletOutputStream.write(output.toByteArray(), 0, output.size());
            servletOutputStream.flush();
            servletOutputStream.close();
            facesContext.responseComplete();

        } catch (JRException e) {
            e.printStackTrace();

        } finally {
            try {
                if (conexao != null)
                    conexao.close();
            } catch (Exception e) {

            }
        }

        return "exibeRelatorio";

    }

xml do subrelatorio:

<?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="pathPessoafisicaDCsubOG" pageWidth="595" pageHeight="842" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
    <property name="ireport.scriptlethandling" value="0"/>
    <property name="ireport.encoding" value="UTF-8"/>
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <import value="net.sf.jasperreports.engine.*"/>
    <import value="java.util.*"/>
    <import value="net.sf.jasperreports.engine.data.*"/>
    <parameter name="codPF" class="java.lang.Long">
        <defaultValueExpression><![CDATA[$F{cod_funcionario}]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[SELECT

pf.cod_funcionario AS cod_funcionario,

es.descricao AS escolaridade_descricao,
og.nome AS og_nome,
cg.descricao AS cargo_descricao,
chs.descricao AS cargahoraria_descricao,
uf.uf AS uf,
mn.municipios AS municipio,


*

FROM pforgaogestor pfog
INNER JOIN orgaogestor og ON og.cod_orgaogestor = pfog.cod_orgaogestor
INNER JOIN cargo cg ON cg.cod_cargo = pfog.cod_cargo
INNER JOIN cargahorariasemanal chs ON chs.cod_chs = pfog.cod_chs
INNER JOIN funcionario pf ON pf.cod_funcionario = pfog.cod_funcionario
INNER JOIN escolaridade es ON es.cod_escolaridade = pf.escolaridade_cod_escolaridade
INNER JOIN estados uf ON uf.cod_estado = pf.estados_cod_estados
INNER JOIN municipiosrr mn ON mn.cod_municipiosrr = pf.municipiosrr_cod_municipiosrr

WHERE pf.cod_funcionario=$P{codPF}
]]>
    </queryString>
    <field name="cod_funcionario" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="escolaridade_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="og_nome" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cargo_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cargahoraria_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="uf" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipio" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="codpfog" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="funcao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="gestor" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_orgaogestor" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_chs" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_cargo" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="compartilhado" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="compartilhado_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="computador" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="computador_qtde" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="condicoesacessibilidade" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="email" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="endereco" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="endereco_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="estados_cod_estados" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fax" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="funcionamento" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="impressora" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="impressora_qtde" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="internet" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="internet_cod_internet" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="mobiliario_adequado" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipiosrr_cod_municipiosrr" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nivelgestao_cod_nivelgestao" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nome" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="predioexclusivo" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="telefone" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="telefone_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="transporte_proprio" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bairro" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="celular" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cep" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cpf" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="escolaridade_cod_escolaridade" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone_comercial" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone_residencial" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nascimento" class="java.sql.Timestamp">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="numero" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="rg" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="rg_exp" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_escolaridade" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_estado" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_municipiosrr" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipios" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <group name="OrgaoGestor">
        <groupExpression><![CDATA[]]></groupExpression>
        <groupHeader>
            <band/>
        </groupHeader>
        <groupFooter>
            <band/>
        </groupFooter>
    </group>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="32" splitType="Stretch">
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="0" y="2" width="535" height="23" forecolor="#8080FF" backcolor="#60A3AE"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <line>
                <reportElement key="line" x="0" y="28" width="534" height="1"/>
            </line>
            <staticText>
                <reportElement key="staticText" x="0" y="3" width="535" height="24" forecolor="#FFFFFF" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center">
                    <font fontName="Arial" size="18" isBold="true"/>
                </textElement>
                <text><![CDATA[Órgão Gestor]]></text>
            </staticText>
        </band>
    </title>
    <pageHeader>
        <band height="63" splitType="Stretch">
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="1" y="1" width="532" height="60" forecolor="#8080FF" backcolor="#A3A9A8"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <staticText>
                <reportElement key="staticText" x="5" y="22" width="52" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[CARGO:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="241" y="23" width="58" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[FUNÇÃO:]]></text>
            </staticText>
            <textField>
                <reportElement x="299" y="23" width="126" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{funcao}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="425" y="22" width="58" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[GESTOR:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="5" y="7" width="106" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[ÓRGÃO GESTOR:]]></text>
            </staticText>
            <textField>
                <reportElement x="485" y="22" width="44" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{gestor}.booleanValue() == false ? "Não" : "Sim"]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="111" y="8" width="418" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{og_nome}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="5" y="38" width="106" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[CARGA HORÁRIA:]]></text>
            </staticText>
            <textField>
                <reportElement x="113" y="38" width="100" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{cargahoraria_descricao}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="59" y="23" width="172" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{cargo_descricao}]]></textFieldExpression>
            </textField>
        </band>
    </pageHeader>
    <columnHeader>
        <band splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band splitType="Stretch">
            <elementGroup/>
        </band>
    </detail>
    <columnFooter>
        <band splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band splitType="Stretch"/>
    </pageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

xml do relatorio principal:

<?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="pessoafisicaDC" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
    <property name="ireport.scriptlethandling" value="0"/>
    <property name="ireport.encoding" value="UTF-8"/>
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="225"/>
    <import value="net.sf.jasperreports.engine.*"/>
    <import value="java.util.*"/>
    <import value="net.sf.jasperreports.engine.data.*"/>
    <parameter name="codPF" class="java.lang.Long">
        <defaultValueExpression><![CDATA[$F{cod_funcionario}]]></defaultValueExpression>
    </parameter>
    <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
        <defaultValueExpression><![CDATA["/"]]></defaultValueExpression>
    </parameter>
    <parameter name="pathPessoafisicaDCsubOG" class="java.lang.String">
        <defaultValueExpression><![CDATA["/"]]></defaultValueExpression>
    </parameter>
    <parameter name="pathPessoafisicaDCsubUN" class="java.lang.String"/>
    <parameter name="pathPessoafisicaDCsubCS" class="java.lang.String"/>
    <queryString>
        <![CDATA[SELECT

pf.cod_funcionario AS cod_funcionario,

es.descricao AS escolaridade_descricao,
og.nome AS og_nome,
cg.descricao AS cargo_descricao,
chs.descricao AS cargahoraria_descricao,
uf.uf AS uf,
mn.municipios AS municipio,

*

FROM pforgaogestor pfog
INNER JOIN orgaogestor og ON og.cod_orgaogestor = pfog.cod_orgaogestor
INNER JOIN cargo cg ON cg.cod_cargo = pfog.cod_cargo
INNER JOIN cargahorariasemanal chs ON chs.cod_chs = pfog.cod_chs
INNER JOIN funcionario pf ON pf.cod_funcionario = pfog.cod_funcionario
INNER JOIN escolaridade es ON es.cod_escolaridade = pf.escolaridade_cod_escolaridade
INNER JOIN estados uf ON uf.cod_estado = pf.estados_cod_estados
INNER JOIN municipiosrr mn ON mn.cod_municipiosrr = pf.municipiosrr_cod_municipiosrr

WHERE pf.cod_funcionario=$P{codPF}
]]>
    </queryString>
    <field name="cod_funcionario" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="escolaridade_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="og_nome" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cargo_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cargahoraria_descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="uf" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipio" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="codpfog" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="funcao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="gestor" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_orgaogestor" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_chs" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_cargo" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="compartilhado" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="compartilhado_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="computador" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="computador_qtde" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="condicoesacessibilidade" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="email" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="endereco" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="endereco_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="estados_cod_estados" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fax" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="funcionamento" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="impressora" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="impressora_qtde" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="internet" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="internet_cod_internet" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="mobiliario_adequado" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipiosrr_cod_municipiosrr" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nivelgestao_cod_nivelgestao" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nome" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="predioexclusivo" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="telefone" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="telefone_complemento" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="transporte_proprio" class="java.lang.Boolean">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="descricao" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bairro" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="celular" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cep" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cpf" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="escolaridade_cod_escolaridade" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone_comercial" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="fone_residencial" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="nascimento" class="java.sql.Timestamp">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="numero" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="rg" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="rg_exp" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_escolaridade" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_estado" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="cod_municipiosrr" class="java.lang.Long">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="municipios" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <group name="OrgaoGestor">
        <groupExpression><![CDATA[]]></groupExpression>
        <groupHeader>
            <band height="7"/>
        </groupHeader>
        <groupFooter>
            <band/>
        </groupFooter>
    </group>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="32" splitType="Stretch">
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="0" y="2" width="535" height="23" forecolor="#8080FF" backcolor="#000000"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <line>
                <reportElement key="line" x="0" y="28" width="534" height="1"/>
            </line>
            <staticText>
                <reportElement key="staticText" x="0" y="4" width="535" height="24" forecolor="#FFFFFF" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Center">
                    <font fontName="Arial" size="18" isBold="true"/>
                </textElement>
                <text><![CDATA[Relatório Pessoa Física]]></text>
            </staticText>
        </band>
    </title>
    <pageHeader>
        <band height="702" splitType="Stretch">
            <staticText>
                <reportElement key="staticText" x="3" y="30" width="96" height="23" forecolor="#000000" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Nome:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="0" y="3" width="210" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="16" isBold="true"/>
                </textElement>
                <text><![CDATA[DADOS CADASTRAIS]]></text>
            </staticText>
            <textField>
                <reportElement x="124" y="31" width="412" height="20" forecolor="#000000"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{nome}]]></textFieldExpression>
            </textField>
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="0" y="23" width="535" height="3" forecolor="#8080FF" backcolor="#000000"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <textField>
                <reportElement x="125" y="100" width="400" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{rg_exp}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="123" y="297" width="164" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{celular}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="437" y="321" width="31" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[UF:]]></text>
            </staticText>
            <textField>
                <reportElement x="468" y="321" width="49" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{uf}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="2" y="251" width="110" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Fone Residencial:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="2" y="297" width="96" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Celular:]]></text>
            </staticText>
            <textField>
                <reportElement x="124" y="206" width="413" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{endereco}]]></textFieldExpression>
            </textField>
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="2" y="194" width="535" height="3" forecolor="#8080FF" backcolor="#000000"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <textField>
                <reportElement x="124" y="251" width="164" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{fone_residencial}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="3" y="174" width="176" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="16" isBold="true"/>
                </textElement>
                <text><![CDATA[ENDEREÇO]]></text>
            </staticText>
            <rectangle>
                <reportElement key="rectangle" mode="Opaque" x="2" y="372" width="535" height="3" forecolor="#8080FF" backcolor="#000000"/>
                <graphicElement>
                    <pen lineWidth="0.0" lineStyle="Solid"/>
                </graphicElement>
            </rectangle>
            <staticText>
                <reportElement key="staticText" x="3" y="99" width="109" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Órgão Expedidor:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="3" y="321" width="96" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Município:]]></text>
            </staticText>
            <textField isBlankWhenNull="true">
                <reportElement x="124" y="228" width="412" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{endereco_complemento}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="125" y="321" width="200" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{municipios}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="3" y="53" width="96" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[CPF:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="3" y="352" width="284" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="16" isBold="true"/>
                </textElement>
                <text><![CDATA[INFORMAÇÕES PROFISSIONAIS]]></text>
            </staticText>
            <textField>
                <reportElement x="124" y="54" width="413" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{cpf}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="3" y="274" width="109" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Fone Comercial:]]></text>
            </staticText>
            <textField isBlankWhenNull="false">
                <reportElement x="125" y="123" width="371" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.util.Date"><![CDATA[$F{nascimento}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="124" y="274" width="164" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{fone_comercial}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="124" y="146" width="413" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{escolaridade_descricao}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="2" y="228" width="110" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Complemento:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="3" y="145" width="109" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Escolaridade:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="3" y="122" width="122" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Data de Nascimento:]]></text>
            </staticText>
            <staticText>
                <reportElement key="staticText" x="3" y="205" width="96" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Endereço:]]></text>
            </staticText>
            <textField>
                <reportElement x="124" y="77" width="413" height="20"/>
                <textElement>
                    <font fontName="Arial" size="12"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[$F{rg}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement key="staticText" x="3" y="76" width="96" height="23" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font fontName="Arial" size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[RG:]]></text>
            </staticText>
            <subreport>
                <reportElement x="0" y="381" width="534" height="92"/>
                <subreportParameter name="codPF">
                    <subreportParameterExpression><![CDATA[$F{cod_funcionario}]]></subreportParameterExpression>
                </subreportParameter>
                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                <subreportExpression class="java.lang.String"><![CDATA[$P{pathPessoafisicaDCsubOG}]]></subreportExpression>
            </subreport>
        </band>
    </pageHeader>
    <columnHeader>
        <band splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band height="3" splitType="Stretch">
            <elementGroup/>
        </band>
    </detail>
    <columnFooter>
        <band splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band height="27" splitType="Stretch">
            <textField pattern="" isBlankWhenNull="false">
                <reportElement key="textField" x="325" y="5" width="170" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement textAlignment="Right">
                    <font size="10"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
            </textField>
            <textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
                <reportElement key="textField" x="499" y="5" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font size="10"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
            <textField pattern="" isBlankWhenNull="false">
                <reportElement key="textField" x="1" y="7" width="209" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
                <box>
                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="0.0" lineColor="#000000"/>
                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textElement>
                    <font size="10"/>
                </textElement>
                <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
            </textField>
            <line>
                <reportElement key="line" x="0" y="4" width="535" height="1"/>
            </line>
        </band>
    </pageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

Aguardo contato. Vlws.

[quote=Mero_Aprendiz]

Kaiser:

Kleber-rr 16 de nov. de 2010

UP!

Criado 17 de março de 2009

Ultima resposta 16 de nov. de 2010

Respostas 7

Participantes 3

7 Respostas

Topicos relacionados