Jump to content
JGD

Jaspersoft Studio (novo iReport) / JasperFillManager.fillReport

Recommended Posts

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  

 

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By danillo.sdd
      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...
    • By gui_nastrini
      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á!
    • By dimas.malheiros
      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.
    • By gui_nastrini
      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.


    • By ricardofs2018
      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 
       
       
       
       
       
×

Important Information

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