Jump to content

Search the Community

Showing results for tags 'ireport'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Q&A Desenvolvimento
    • Perguntas e respostas rápidas
  • Desenvolvimento e Banco de Dados
    • HTML e CSS
    • Java
    • Javascript
    • .NET
    • PHP
    • Python
    • Ruby
    • Mobile
    • Ambientes de Desenvolvimento
    • Arquitetura e Métodos Ágeis
    • Banco de Dados
    • DevOps
    • Desenvolvimento de Games
    • E-Commerce e Pagamentos Online
    • SEO e Otimizações
    • WordPress
    • Algoritmos & Outras Tecnologias
  • Design e Produto
    • Fotografia
    • Photoshop
    • Design de interfaces e UX
    • Edição/Produção de Vídeos
    • Marketing Online
    • Desenho, Ilustração e 3D
  • Entretenimento e uso pessoal
    • Geral
    • Segurança & Malwares
    • Gadgets e wearable
    • Softwares e Apps
    • Entretenimento

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Google+


Hangouts


Skype


Twitter


deviantART


Github


Flickr


LinkedIn


Pinterest


Facebook


Site Pessoal


Localização


Interesses

Found 10 results

  1. danillo.sdd

    ireport + subreport + PHPJasperXML+ php

    Não consigo fazer funcionar o o ireport com subreport para execução no php, através do PHPJasperXML.... Só da erro de internal server error... (Quando o tiro o subreport funciona) Deve ser na configuração do subreport, mais ja tentei de tudo...
  2. No sistema gerencial que estou trabalhando, gero em PDF um comprovante não fiscal para impressora térmica, feito no iReport, utilizando a biblioteca PHPJasperXML. Neste comprovante, quando se tem apenas um produto (uma linha) na aba Detail, os campos do Summary vem em branco. Quando se tem dois produtos ou mais (duas linhas ou mais) na aba Detail, os campos são preenchidos normalmente. No preview do programa iReport funciona perfeitamente, com um ou dois produtos. Segue o jrxml do relatório (somente o detail e o summary): <detail> <band height="25" splitType="Stretch"> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="186" height="12" uuid="e06c4bc6-e0f7-4e0e-8a7b-ab5ce1fd5e62"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="false"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{descricao}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="52" y="12" width="67" height="12" uuid="1d928a34-4972-4204-9612-9f0e8a6749d3"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{valor}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="0" y="12" width="52" height="12" uuid="f6d30d04-d0fe-4dd3-a675-377ff6d2b473"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{quantidade}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="119" y="12" width="67" height="12" uuid="0603e3b7-801d-49af-9a06-5d33023c5277"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{subtotal}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="203"> <staticText> <reportElement mode="Opaque" x="0" y="82" width="85" height="16" backcolor="#CCCCCC" uuid="6b173bab-525a-4da5-a564-723a8cbb1fbc"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TROCO:]]></text> </staticText> <staticText> <reportElement x="0" y="3" width="53" height="12" uuid="c99a6844-ca28-47c7-a022-80d2717bf547"/> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[Emissão:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="66" width="85" height="16" backcolor="#CCCCCC" uuid="d0b8947e-8183-4a55-8b6d-f238bdac0404"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TOTAL REC.:]]></text> </staticText> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="82" width="101" height="16" uuid="a15e9cba-0f96-42be-8071-dbd7afecf73a"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{troco}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="34" width="101" height="16" uuid="47411e66-b385-427c-825c-3be4e4abe45e"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{desconto}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="34" width="85" height="16" backcolor="#CCCCCC" uuid="05f791f7-9e38-4ee2-b7db-8e1ec1d6275f"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ DESCONTO:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="18" width="85" height="16" backcolor="#CCCCCC" uuid="3c260ede-9083-41f2-aa35-b2e044fc645a"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ SUBTOTAL:]]></text> </staticText> <textField> <reportElement x="52" y="3" width="134" height="12" uuid="47291c92-c9d1-40ac-a8d8-82247f26f98b"/> <textElement verticalAlignment="Top"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{hoje}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="66" width="101" height="16" uuid="798cef8b-50c8-437b-af79-95526dbcd315"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_rec}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" mode="Transparent" x="85" y="18" width="101" height="16" uuid="ac0e949b-93f4-4ded-a654-97230a33cb20"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_prod}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="50" width="101" height="16" uuid="98a37383-f178-4e9b-817a-66c3ebe183a5"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_venda}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="102" width="186" height="98" isPrintWhenDetailOverflows="true" uuid="85f18504-1690-48ae-a11a-02a6b0ef4489"/> <box> <pen lineColor="#999999"/> <topPen lineColor="#999999"/> <leftPen lineColor="#999999"/> <bottomPen lineColor="#999999"/> <rightPen lineColor="#999999"/> </box> <textElement markup="none"> <font size="7" isPdfEmbedded="false"/> </textElement> <textFieldExpression><![CDATA[$F{pagamentos_venda}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="50" width="85" height="16" backcolor="#CCCCCC" uuid="1fc6ac4f-3090-4de5-8fd6-7562b4058ecf"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TOTAL:]]></text> </staticText> <line> <reportElement x="0" y="0" width="186" height="1" uuid="e3ab1d85-d813-4fe6-ba0d-70c9bf390b79"/> </line> </band> </summary> Veja os resultados em PDF: 1 - Com um produto: 2 - Com dois produtos: Os valores já vem prontos do banco de dados MySQL, nada é alterado ou incrementado dentro do Summary. Já tentei com parameter e variable mas não deu certo. Alguém tem alguma ideia? Seria um problema no relatório ou alguma configuração de servidor? Obrigado desde já!
  3. dimas.malheiros

    Ajuda com IReport

    Bom dia amigos, Gostaria de saber se algum dos colegas sabe me informar se existe uma maneira de escolher numa tabela os dados que preencherão meu relatorio IReport. ex: eu tenho uma tabela que é preenchida com valores do banco de dados, onde tenho varios clientes,cada cliente com nome, idade, endereço, e email. eu gostaria de escolher somente um cliente na tabela e imprimir o relatorio com os dados dele. pode ser clicando diretamente na linha escolhida da tabela, como escolhendo a linha e clicando em um botao gerar. se alguem puder ajudar com um exemplo, agradeço.
  4. gui_nastrini

    Summary do iReport não traz os fields

    No sistema gerencial que estou trabalhando, gero em PDF um comprovante não fiscal para impressora térmica feito no iReport utilizando a biblioteca PHPJasperXML. Neste comprovante, quando se tem apenas um produto na aba Detail, não aparecem os fields do Summary. No preview do iReport funciona perfeitamente. E quando se tem dois produtos ou mais, também funciona certinho. Segue o jrxml do relatório: <?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="Comprovante de Venda" language="groovy" pageWidth="226" pageHeight="1000" columnWidth="186" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7adaf37b-383e-4716-8dba-c60672258fa5"> <property name="ireport.zoom" value="2.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <queryString> <![CDATA[SELECT v.nrvenda AS nrvenda, v.data AS data, v.total_prod AS total_prod, v.desconto AS desconto, v.total_venda AS total_venda, v.total_rec AS total_rec, v.troco AS troco, v.endereco_e AS endereco, v.numero_e AS numero, v.complemento_e AS complemento, v.bairro_e AS bairro, v.cidade_e AS cidade, v.uf_e AS uf, i.quantidade AS quantidade, i.valor AS valor, ((i.valor * i.quantidade) - i.desconto) AS subtotal, ve.nomev AS nomev, c.nome AS nome, i.descricao AS descricao, pa.foto1 AS foto1, pa.fantasia AS fantasia, f.hoje AS hoje, f.pagamentos_venda AS pagamentos_venda FROM vendas v, ivendas i, produtos p, vendedor ve, clientes c, parametros pa, filtro_relats f WHERE v.vendas_id = f.consulta AND v.vendas_id = i.venda_id AND v.cliente = c.id AND v.vendedor = ve.id AND i.cod_prod = p.id_produto]]> </queryString> <field name="nrvenda" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="data" class="java.sql.Date"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="total_prod" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="desconto" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="total_venda" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="total_rec" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="troco" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="endereco" class="java.lang.String"/> <field name="numero" class="java.lang.Integer"/> <field name="complemento" class="java.lang.String"/> <field name="bairro" class="java.lang.String"/> <field name="cidade" class="java.lang.String"/> <field name="uf" class="java.lang.String"/> <field name="quantidade" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="valor" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="subtotal" class="java.math.BigDecimal"/> <field name="nomev" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="nome" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="descricao" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="foto1" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="fantasia" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="hoje" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="pagamentos_venda" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <title> <band height="187"> <textField pattern="dd/MM/yyyy"> <reportElement x="120" y="99" width="66" height="12" uuid="25d34e22-9598-4071-a564-30baf0f8d047"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> </textElement> <textFieldExpression><![CDATA[$F{data}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="99" width="55" height="12" backcolor="#CCCCCC" uuid="8b7388ce-c123-462b-bea7-0f93b3ddfb68"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[Nº DA VENDA:]]></text> </staticText> <textField> <reportElement x="55" y="99" width="55" height="12" uuid="193a1c6b-9e51-4778-9c01-4bd35f7ba684"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{nrvenda}]]></textFieldExpression> </textField> <line> <reportElement x="0" y="94" width="186" height="1" uuid="9ab7fd9c-500f-4eb2-bccf-4cdab7d7c03e"/> </line> <image> <reportElement x="0" y="0" width="186" height="56" uuid="ffabf6c5-f0b7-45c8-a208-0b33a2fafc9a"/> <imageExpression><![CDATA["../logo/"+$F{foto1}]]></imageExpression> </image> <staticText> <reportElement mode="Opaque" x="0" y="78" width="186" height="14" backcolor="#CCCCCC" uuid="676f6ab7-2ab4-4c6e-b9bb-672c6df618ea"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[COMPROVANTE NÃO FISCAL]]></text> </staticText> <line> <reportElement x="0" y="185" width="186" height="1" uuid="7a7509a4-2e82-4170-997c-13a6a44b9177"/> </line> <textField> <reportElement mode="Opaque" x="0" y="58" width="186" height="18" backcolor="#CCCCCC" uuid="448ff1c2-ec6a-444b-a30a-ba5e25f1692e"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="9" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{fantasia}]]></textFieldExpression> </textField> <textField> <reportElement x="55" y="111" width="131" height="12" uuid="7bf29b10-6585-45cd-b169-2e870129ca2d"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{nomev}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="123" width="55" height="12" backcolor="#CCCCCC" uuid="9b9ba722-7986-4b75-861b-35585fbd440e"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[CLIENTE:]]></text> </staticText> <textField> <reportElement x="55" y="123" width="131" height="12" uuid="95771752-df56-4745-b53e-09d07bc97efb"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{nome}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="111" width="55" height="12" backcolor="#CCCCCC" uuid="f425caaa-484f-45a4-aa51-66f1bb3693cb"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[VENDEDOR:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="135" width="55" height="12" backcolor="#CCCCCC" uuid="cc70adb1-3158-4cb3-92b5-f4c90449bf1c"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[ENDEREÇO:]]></text> </staticText> <textField> <reportElement x="55" y="135" width="131" height="12" uuid="fd98d079-e937-498d-93c9-512bc4d2f70d"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{endereco} + ', ' + $F{numero}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="147" width="55" height="12" backcolor="#CCCCCC" uuid="faef5472-b6b5-4219-965e-cf5c8279d25b"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[COMP.:]]></text> </staticText> <textField> <reportElement x="55" y="147" width="131" height="12" uuid="1acd940f-3f5f-44c6-8009-8c37fb41fdea"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{complemento}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="159" width="55" height="12" backcolor="#CCCCCC" uuid="983a2a9a-df4d-4bc5-a2f8-236b28c128f8"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[BAIRRO:]]></text> </staticText> <textField> <reportElement x="55" y="159" width="131" height="12" uuid="dcc222e1-a8a8-4a37-af69-692f3e482259"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{bairro}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="171" width="55" height="12" backcolor="#CCCCCC" uuid="48652fef-989f-41d7-a84d-d63153eeba24"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[CIDADE:]]></text> </staticText> <textField> <reportElement x="55" y="171" width="131" height="12" uuid="85297550-2f69-4120-93e9-30ef295af055"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{cidade} + ' / ' + $F{uf}]]></textFieldExpression> </textField> </band> </title> <columnHeader> <band height="12"> <staticText> <reportElement mode="Opaque" x="52" y="0" width="67" height="12" backcolor="#CCCCCC" uuid="f48675f7-1e42-45ac-a180-6002eeb777cc"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <font size="7" isBold="true"/> <paragraph rightIndent="5"/> </textElement> <text><![CDATA[R$ VALOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="0" width="52" height="12" backcolor="#CCCCCC" uuid="74c403aa-4d3e-4c21-a274-5c6e7eeb9745"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <font size="7" isBold="true"/> <paragraph rightIndent="5"/> </textElement> <text><![CDATA[QUANTIDADE]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="119" y="0" width="67" height="12" backcolor="#CCCCCC" uuid="3482c3c9-3373-479e-b458-d5327c3b4b09"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Top"> <font size="7" isBold="true"/> <paragraph rightIndent="5"/> </textElement> <text><![CDATA[R$ SUBTOTAL]]></text> </staticText> </band> </columnHeader> <detail> <band height="25" splitType="Stretch"> <textField isStretchWithOverflow="true"> <reportElement x="0" y="0" width="186" height="12" uuid="e06c4bc6-e0f7-4e0e-8a7b-ab5ce1fd5e62"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="false"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{descricao}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="53" y="12" width="67" height="12" uuid="1d928a34-4972-4204-9612-9f0e8a6749d3"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{valor}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="0" y="12" width="52" height="12" uuid="f6d30d04-d0fe-4dd3-a675-377ff6d2b473"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{quantidade}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement x="119" y="12" width="67" height="12" uuid="0603e3b7-801d-49af-9a06-5d33023c5277"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{subtotal}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="203"> <staticText> <reportElement mode="Opaque" x="0" y="82" width="85" height="16" backcolor="#CCCCCC" uuid="6b173bab-525a-4da5-a564-723a8cbb1fbc"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TROCO:]]></text> </staticText> <staticText> <reportElement x="0" y="3" width="53" height="12" uuid="c99a6844-ca28-47c7-a022-80d2717bf547"/> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[Emissão:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="66" width="85" height="16" backcolor="#CCCCCC" uuid="d0b8947e-8183-4a55-8b6d-f238bdac0404"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TOTAL REC.:]]></text> </staticText> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="82" width="101" height="16" uuid="a15e9cba-0f96-42be-8071-dbd7afecf73a"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{troco}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="34" width="101" height="16" uuid="47411e66-b385-427c-825c-3be4e4abe45e"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{desconto}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="34" width="85" height="16" backcolor="#CCCCCC" uuid="05f791f7-9e38-4ee2-b7db-8e1ec1d6275f"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ DESCONTO:]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="18" width="85" height="16" backcolor="#CCCCCC" uuid="3c260ede-9083-41f2-aa35-b2e044fc645a"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ SUBTOTAL:]]></text> </staticText> <textField> <reportElement x="53" y="3" width="133" height="12" uuid="47291c92-c9d1-40ac-a8d8-82247f26f98b"/> <textElement verticalAlignment="Top"> <font size="7"/> <paragraph leftIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{hoje}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="66" width="101" height="16" uuid="798cef8b-50c8-437b-af79-95526dbcd315"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_rec}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" mode="Transparent" x="85" y="18" width="101" height="16" uuid="ac0e949b-93f4-4ded-a654-97230a33cb20"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_prod}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;-#,##0.00"> <reportElement isPrintRepeatedValues="false" x="85" y="50" width="101" height="16" uuid="98a37383-f178-4e9b-817a-66c3ebe183a5"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="7"/> <paragraph rightIndent="5"/> </textElement> <textFieldExpression><![CDATA[$F{total_venda}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" stretchType="RelativeToBandHeight" x="0" y="102" width="186" height="98" isPrintWhenDetailOverflows="true" uuid="85f18504-1690-48ae-a11a-02a6b0ef4489"/> <box> <pen lineColor="#999999"/> <topPen lineColor="#999999"/> <leftPen lineColor="#999999"/> <bottomPen lineColor="#999999"/> <rightPen lineColor="#999999"/> </box> <textElement markup="none"> <font size="7" isPdfEmbedded="false"/> </textElement> <textFieldExpression><![CDATA[$F{pagamentos_venda}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="0" y="50" width="85" height="16" backcolor="#CCCCCC" uuid="1fc6ac4f-3090-4de5-8fd6-7562b4058ecf"/> <box> <pen lineWidth="0.25" lineColor="#999999"/> <topPen lineWidth="0.25" lineColor="#999999"/> <leftPen lineWidth="0.25" lineColor="#999999"/> <bottomPen lineWidth="0.25" lineColor="#999999"/> <rightPen lineWidth="0.25" lineColor="#999999"/> </box> <textElement verticalAlignment="Middle"> <font size="7" isBold="true"/> <paragraph leftIndent="5"/> </textElement> <text><![CDATA[R$ TOTAL:]]></text> </staticText> <line> <reportElement x="0" y="0" width="186" height="1" uuid="e3ab1d85-d813-4fe6-ba0d-70c9bf390b79"/> </line> </band> </summary> </jasperReport> É só o Summary que está com problema mesmo (da "emissão" pra baixo), o resto que não está aparecendo realmente foi omitido pois não cabe neste escopo.
  5. Bom dia pessoal! Estou com uma certa dificuldade em realizar a implementação de busca no MySql gerando relatório com o iReport. para gerar o relatório eu uso o seguinte código: try { JasperPrint print = JasperFillManager.fillReport("C:/DEPOSITO/JAVA/Controle/src/com/transire/hardware/telas/report1.jasper",null,conexao); JasperViewer.viewReport(print,false); } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } mas o problema é que, ele me retorna um relatório com todos registros na tabela pesquisada. sendo que no meu form tem um jTextField que tem o nome de txtId e que eu gostaria que fosse o parâmetro para a query. Bom esse é meu problema. preciso muito resolver isso desde ja grato pela ajuda
  6. Olá, Estou tentado gerar relatórios com o novo iReport (já que o java do projeto é java oito) Baixer Jaspersoft Studio (novo iReport) e JasperReports Library em Jaspersoft Community... no pacote notei ausência de alguns jar que existiam na versão antiga (como: common-beanutils, Commons-digester, itextpdf, etc) nas estutura do pacote na há a pasta "lib"... apenas pasta "dist" com os jar: jasperreports-6.5.1, jasperreports-fonts-6.5.1 e jasperreports-javaflow-6.5.1.. Voltado.. Gerei o relatório no inteface Jaspersoft Studio... Digo: fiz conexçao, testei e compilei (arquivos: .jasper e .jrxml) o relatório. Certinho! Funcionou o relatórios com layout e dados.. Daí tente implementar no projeto java: Botão: btnPrint1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { try { Connection connection4 = ConexaoUtil.getInstance().getConnection(); HashMap param = new HashMap(); JasperPrint jp = JasperFillManager.fillReport("src/MyiReport/MyReports/bin", param, connection4); // e tb assim: // JasperPrint jp = JasperFillManager.fillReport("C:\\pasta_1\\pasta_2\\src\\MyiReport\\relatorios\\lista_prod_1_A4.jasper", param, connection4); JasperViewer jw = new JasperViewer(jp); jw.setVisible(true); } catch (JRException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (ClassNotFoundException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } }); Dai deu erro: Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at net.sf.jasperreports.engine.util.JRLoader.<clinit>(JRLoader.java:81) at net.sf.jasperreports.engine.JRPropertiesUtil.loadProperties(JRPropertiesUtil.java:102) at net.sf.jasperreports.engine.DefaultJasperReportsContext.initProperties(DefaultJasperReportsContext.java:108) at net.sf.jasperreports.engine.DefaultJasperReportsContext.<init>(DefaultJasperReportsContext.java:85) at net.sf.jasperreports.engine.DefaultJasperReportsContext.<clinit>(DefaultJasperReportsContext.java:68) at net.sf.jasperreports.engine.JasperFillManager.getDefaultInstance(JasperFillManager.java:87) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:759) at br.com.montebranco.fiscal01.FrmPrincipal$12.actionPerformed(FrmPrincipal.java:1258) .... Então eu add os seguintes jar: commons-digester-2.0 commons-collections-3.2.1 commons-beanutils-1.8.3 commons-digester-2.0 commons-logging-1.1.1 groovy-all-1.5.5 iText-5.0.4 Considerando alguma eventual dependência da antiga versão. Mas o erro persiste. Sou grato por qualquer ajuda
  7. cleitonteixeira

    Relatório PHP usando Ireport

    Boa tarde! Estou com uma dúvida, é possível gerar arquivos pdf usando o ireport e o php? Já tentei usando algumas ferramentas mas nenhuma me deu um resultado, a tela ficou simplesmente branca sem nenhuma informação, alguém teria uma classe ou arquivos de exemplo para que eu posso implementar esse relatório ao meu sistema?
  8. como faço para chamar um relatório ireport passando os paramentos na aplicação ? estou utilizando o JPA para conexão com o banco. estou conseguindo chamar o relatório, mas não estou conseguindo passar os parâmetros. código chamar relatório String caminho = new File("./Relatorios/Relatorio_Funcionario/Relatorio_Funcionario_total.jrxml").getAbsolutePath(); JasperReport relatorio = JasperCompileManager.compileReport(caminho); JRBeanCollectionDataSource dados = new JRBeanCollectionDataSource(list, false); JasperPrint print = JasperFillManager.fillReport(relatorio, null, dados); JasperViewer viw = new JasperViewer(print, false); viw.setVisible(true);
  9. Estou tentando implementar relatórios em um sistema que estou criando em Flex/PHP/MySql e para o relatório estou utilizando o IReport salvando como jrxml. Com o PHP Jasper XML eu tive sucesso mas perco a formatação. Então, encontrei esse post: https://github.com/andersonsouzars/simple-report Parece bom e simples mas não consegui implementar, alguém já utilizou e pode me ajudar? Preciso saber quais são os arquivos que devo editar e como editar
  10. jallisson

    Sub relatório dentro TextField Ireport

    Tem como colocar um subrelatorio dentro de um textfield. Tentei mais somente aparece o caminho do sub-relatório "Área de: "+String.format("%.2f", $F{imovel_M_AREA})+"m² "+"(" +new ExtensoMetricoQuadrado(new BigDecimal($F{imovel_M_AREA}))+ "); frente para " +$F{logradouro_FRENTE_NOME}+" nº "+$F{imovel_NUMERO}+" "+"Bairro "+$F{bairro_IMOVEL_NOME}+", medindo " +String.format("%.2f", $F{imovel_M_FRENTE})+"m "+"("+new ExtensoMetrico(new BigDecimal($F{imovel_M_FRENTE})) + "); lateral direita confrontando-se com "+$F{imovel_VIZIN_DIR}+", "+"medindo " +String.format("%.2f", $F{imovel_M_DIREITA})+"m "+"(" +new ExtensoMetrico(new BigDecimal($F{imovel_M_DIREITA})) + "); lateral esquerda confrontando-se com "+$F{imovel_VIZIN_ESQ}+", " +"medindo "+String.format("%.2f", $F{imovel_M_ESQUERDA})+"m "+"(" +new ExtensoMetrico(new BigDecimal($F{imovel_M_ESQUERDA}))+ "); fundo confrontando-se com " +$F{imovel_VIZIN_FUN}+", "+"medindo "+String.format("%.2f", $F{imovel_M_FUNDO}) +"m "+"("+new ExtensoMetrico(new BigDecimal($F{imovel_M_FUNDO})) + "). O referido imóvel fica situado na quadra formada pela "+$F{logradouro_FRENTE_NOME}+", " +$F{logradouro_DIREITA_NOME}+", "+$F{logradouro_FUNDO_NOME}+" e " +$F{logradouro_ESQUERDA_NOME}+"." +$P{SUBREPORT_DIR} + "CadImobGetatSubLayout2.jasper" Ao colocar o subrelatorio no textfield aparece o caminho do relatorio no pc, e não os dados.
×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.