Cezar Apulchro

Ranch Hand

+ Follow

127 Posts 28 Threads 1 Cows

since Feb 13, 2013

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Cezar Apulchro

JasperSoft Studio - JasperReport are printing only last record.

I have a servlet that generate a report created by JasperSoft Studio IDE, the problem is that the JasperReport are printing only the last record of my HashMap.
Below follows my servelet

protected void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       processRequest(request, response);
     
       conectar = new Conectar_Banco_W00().getConnection();
       
       Map<String, Object> parametros = new HashMap<>();
       
       dataexame = request.getParameter("dtaexame");
       
       diaexame = dataexame.substring(0, 2);
       mesexame = dataexame.substring(3, 5);
       anoexame = dataexame.substring(6, 10);
       
       dataexameFMT = anoexame + "-" + mesexame + "-" + diaexame;
       
       
       String ListarEletroDia = "SELECT Nome, Data_Nascimento, Sexo, Telefone_Residencial " +
                                " FROM Tabela_Pacientes_Eletro WHERE Data_Exame = ?";
       Connection conectar = null;
       PreparedStatement pstm = null;
       ResultSet rs = null;
       Bean_Agenda_Exames listpac;
       
       String pathJasper =  getServletContext().getRealPath("/WEB-INF/LstAgendaEletro_A1.jrxml");
       
       InputStream inputStr = new FileInputStream( new File(pathJasper));
       
               conectar = new Conectar_Banco_W00().getConnection();
           try
               {
               pstm = conectar.prepareStatement(ListarEletroDia);
               pstm.setString(1, dataexameFMT);
               rs = pstm.executeQuery();
               while (rs.next())                
               {
                   nome = rs.getString("Nome");
                   sexo = rs.getString("Sexo");
                   telefone = rs.getString("Telefone_Residencial");
                   dtanascimento = rs.getString("Data_Nascimento");
                   dianascimento = dtanascimento.substring(8, 10);
                   mesnascimento = dtanascimento.substring(5, 7);
                   anonascimento = dtanascimento.substring(0, 4);
                   dtanascimento = dianascimento + "/" + mesnascimento + "/" + anonascimento;
                   
                   listpac = new Bean_Agenda_Exames(nome, sexo, dtanascimento, telefone);
                   parametros.put(nome, listpac);
                   parametros.put("paramDtaAgenda", dataexame);
                   parametros.put("paramNome", nome);
                   parametros.put("paramDtaNascimento", dtanascimento);
                   parametros.put("paramSexo", sexo);
                   parametros.put("paramTelefone", telefone);
               }
                   Conectar_Banco_W00.fecharConexao(conectar, pstm, rs);
               }
               catch(SQLException e)
               {
                   e.printStackTrace();
               }
           System.out.println("Prametros: " + parametros);
       try
       {
           JasperReport jReport = JasperCompileManager.compileReport(inputStr);
           JasperPrint  jPrint  = JasperFillManager.fillReport(jReport, parametros, new JREmptyDataSource());
           
           JasperExportManager.exportReportToPdfStream(jPrint,
                   response.getOutputStream());
           
           response.getOutputStream().flush();
           response.getOutputStream().close();
           
       } catch (JRException ex) {
           Logger.getLogger(ListAgenda_Eletro_S001.class.getName()).log(Level.SEVERE, null, ex);
       }

Thanks in advace.

1 month ago

Java in General

Seting SimpleDateFormat in JasperSoft Studio - JRXML

This contact are closed without solution.

1 month ago

Java in General

Error in JRXML bean

This contact are closed without solution.

1 month ago

Java in General

Error in JRXML bean

I can't understand, my original problem was mask to format date of my mysql table "yyyy-mm-dd" to "dd/mm/yyyy". If I return to use the original servlet my report is generated fine without problemas.

1 month ago

Java in General

Error in JRXML bean

Hi,
after read the articles in MIME types (IANA media types) and
after change my jsp putting the enctype to use the MIME type for PDF the problem still the same.

1 month ago

Java in General

Error in JRXML bean

how I do that?

1 month ago

Java in General

Error in JRXML bean

Hi Paul,
after remove

I'm receiving a page blank.

1 month ago

Java in General

Error in JRXML bean

Hi,
I have changed my servlet that generate the report. I put into the servlet the mysql select to load to hashmap.
The servlet:

package com.itcsystems.itc_systems_web_mv00;
import com.itcsystems.beans.Bean_Agenda_Exames;
import com.itcsystems.beans.Conectar_Banco_W00;
import com.itcsystems.beans.DadosPaciente;
import com.itcsystems.beans.PacientesDAO_W01;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.util.JRLoader;
import java.util.HashMap;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import net.sf.jasperreports.engine.util.JRLoader;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.util.stream.Collectors;
import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
/**
*
* @author Administrador
*/
public class ListAgenda_Eletro_S02 extends HttpServlet
{
   private String      nome = null,
                       dataexameFMT = null,
                       dataexame = null,
                       diaexame = null,
                       mesexame = null,
                       anoexame = null,
                       sexo = null,
                       dtanascimento,
                       telefone = null;
   public  Connection  conectar;
           
   /**
    * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
    * methods.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   protected void processRequest(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       response.setContentType("text/html;charset=UTF-8");
   }
   // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
   /**
    * Handles the HTTP <code>GET</code> method.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doGet(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       processRequest(request, response);
   }
   /**
    * Handles the HTTP <code>POST</code> method.
    *
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
           throws ServletException, IOException
   {
       processRequest(request, response);
       
       conectar = new Conectar_Banco_W00().getConnection();
       
       /*Bean_Agenda_Exames dpaciente = new Bean_Agenda_Exames();
       PacientesDAO_W01 pcdao = new PacientesDAO_W01();*/
       HashMap<String, Object> parameters = new HashMap<>();
       
       
       dataexame = request.getParameter("dtaexame");
       
       diaexame = dataexame.substring(0, 2);
       mesexame = dataexame.substring(3, 5);
       anoexame = dataexame.substring(6, 10);
       
       dataexameFMT = anoexame + "-" + mesexame + "-" + diaexame;
       
       
       String ListarEletroDia = "SELECT Nome, Data_Nascimento, Sexo, Telefone_Residencial " +
                                " FROM Tabela_Pacientes_Eletro WHERE Data_Exame = ?";
       Connection conectar = null;
       PreparedStatement pstm = null;
       ResultSet rs = null;
       
     
       try
       {
       conectar = new Conectar_Banco_W00().getConnection();
       
       pstm = conectar.prepareStatement(ListarEletroDia);
       pstm.setString(1, dataexameFMT);
       rs = pstm.executeQuery();
       
       while (rs.next())                
       {
           nome = rs.getString("Nome");
           dtanascimento = rs.getString("Data_Nascimento");
           sexo = rs.getString("Sexo");
           telefone = rs.getString("Telefone_Residencial");
           
           parameters.put("paramNome", nome);
           parameters.put("paramSexo", sexo);
           parameters.put("paramDtaNascimento", dtanascimento);
           parameters.put("paramTelefone", telefone);
           System.out.println("Nome: " + nome);
       }
           Conectar_Banco_W00.fecharConexao(conectar, pstm, rs);
       }
       catch(SQLException e)
       {
           e.printStackTrace();
       }
       
       
       String pathJasper =  getServletContext().getRealPath("/WEB-INF/LstAgendaEletro_A1.jrxml");
       
       InputStream inputStr = new FileInputStream( new File(pathJasper));
       
       try
       {
           JasperReport jReport = JasperCompileManager.compileReport(inputStr);
           JasperPrint  jPrint  = JasperFillManager.fillReport(jReport, parameters, new JREmptyDataSource());
           
           JasperExportManager.exportReportToPdfStream(jPrint,
                   response.getOutputStream());
           
           response.getOutputStream().flush();
           response.getOutputStream().close();
           
       } catch (JRException ex) {
           Logger.getLogger(ListAgenda_Eletro_S001.class.getName()).log(Level.SEVERE, null, ex);
       }
   }
   /**
    * Returns a short description of the servlet.
    *
    * @return a String containing servlet description
    */
   @Override
   public String getServletInfo() {
       return "Short description";
   }// </editor-fold>
}

I don't receive more error but the result is:

1 month ago

Java in General

Error in JRXML bean

Hi Paul,
no news?

1 month ago

Java in General

Error in JRXML bean

After make changes the problem still the same

/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.itcsystems.beans;
/**
*
* @author Cezar Apulchro
*/
public class Bean_Agenda_Exames
{
   private String  Nome,
                   Sexo,
                   Data_Nascimento,
                   Telefone_Residencial;
   /**
    * @return the Nome
    */
   public String getNome() {
       return Nome;
   }
   /**
    * @param Nome the Nome to set
    */
   public void setNome(String Nome) {
       this.Nome = Nome;
   }
   /**
    * @return the Sexo
    */
   public String getSexo() {
       return Sexo;
   }
   /**
    * @param Sexo the Sexo to set
    */
   public void setSexo(String Sexo) {
       this.Sexo = Sexo;
   }
   /**
    * @return the Data_Exame
    */
   public String getData_Nascimento() {
       return Data_Nascimento;
   }
   /**
    * @param Data_Exame the Data_Exame to set
    */
   public void setData_Nascimento(String Data_Nascimento) {
       this.Data_Nascimento = Data_Nascimento;
   }
   /**
    * @return the Telefone_Residencial
    */
   public String getTelefone_Residencial() {
       return Telefone_Residencial;
   }
   /**
    * @param Telefone_Residencial the Telefone_Residencial to set
    */
   public void setTelefone_Residencial(String Telefone_Residencial) {
       this.Telefone_Residencial = Telefone_Residencial;
   }
   
   public String toString()
   {
       return "Bean_Lst_Agenda_Exames{" +
               "Nome=" + Nome +
               ", Sexo=" + Sexo +
               ", Data_Nascimento=" + Data_Nascimento +
               ", Telefone_Residencial=" + Telefone_Residencial + '}';
   }
}

1 month ago

Java in General

Error in JRXML bean

After make changes in my jrxml I am receiving the following error:

Grave:   net.sf.jasperreports.engine.JRException: Error retrieving field value from bean: Nome.
at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:205)
at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:170)
at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1501)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1402)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1378)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1194)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:108)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615)
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:432)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:162)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:145)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:689)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:1005)
at com.itcsystems.itc_systems_web_mv00.ListAgenda_Eletro_S02.doPost(ListAgenda_Eletro_S02.java:131)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:416)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:283)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoSuchMethodException: Unknown property 'Nome' on class 'class com.itcsystems.beans.Bean_Lst_Agenda_Exames'
at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1269)
at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:808)
at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:884)
at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:464)
at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:185)
... 44 more

This is my BEAN:

public class Bean_Lst_Agenda_Exames extends HttpServlet
{
   private String  Nome,
                   Sexo,
                   Data_Nascimento,
                   Telefone_Residencial;
   /**
    * @return the Nome
    */
   public String getNome() {
       return Nome;
   }
   /**
    * @param Nome the Nome to set
    */
   public void setNome(String Nome) {
       this.Nome = Nome;
   }
   /**
    * @return the Sexo
    */
   public String getSexo() {
       return Sexo;
   }
   /**
    * @param Sexo the Sexo to set
    */
   public void setSexo(String Sexo) {
       this.Sexo = Sexo;
   }
   /**
    * @return the Data_Nascimento
    */
   public String getData_Nascimento() {
       return Data_Nascimento;
   }
   /**
    * @param Data_Nascimento the Data_Nascimento to set
    */
   public void setData_Nascimento(String Data_Nascimento) {
       this.Data_Nascimento = Data_Nascimento;
   }
   /**
    * @return the Telefone_Residencial
    */
   public String getTelefone_Residencial() {
       return Telefone_Residencial;
   }
   /**
    * @param Telefone_Residencial the Telefone_Residencial to set
    */
   public void setTelefone_Residencial(String Telefone_Residencial) {
       this.Telefone_Residencial = Telefone_Residencial;
   }
   
   public String toString()
   {
       return "Bean_Lst_Agenda_Exames{" +
               "Nome=" + Nome +
               ", Sexo=" + Sexo +
               ", Data_Nascimento=" + Data_Nascimento +
               ", Telefone_Residencial=" + Telefone_Residencial + '}';
   }

This is my jrxml:

<?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="LstAgendaEletro" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5676a452-be9f-48f1-a46d-31876895dcc9">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="ITC Systems P63 DA "/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="paramDtaEletro" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT Nome,
Data_Nascimento,
Sexo,
Telefone_Residencial
FROM Tabela_Pacientes_Eletro
WHERE Data_Exame = $P{paramDtaEletro}]]>
</queryString>
<field name="Nome" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Nome"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Data_Nascimento" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Data_Nascimento"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Sexo" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Sexo"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<field name="Telefone_Residencial" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Telefone_Residencial"/>
<property name="com.jaspersoft.studio.field.tree.path" value="tabela_pacientes_eletro"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="43" splitType="Stretch">
<staticText>
<reportElement x="143" y="6" width="205" height="18" uuid="4208c3ce-a5f6-4de0-847e-630b04443cc9">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>

</textElement>
<text><![CDATA[Agenda Pacientes Eletro - Dia:]]></text>
</staticText>
<textField>
<reportElement x="348" y="7" width="80" height="18" uuid="86f6925e-eed2-4bde-8a6e-f6df0edd2e54">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>

</textElement>
<textFieldExpression><![CDATA[$P{paramDtaEletro}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="20" splitType="Stretch">
<staticText>
<reportElement x="80" y="2" width="34" height="16" uuid="e37d77f9-3d59-400b-bf01-ef99c30e2afd">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>

</textElement>
<text><![CDATA[Nome]]></text>
</staticText>
<staticText>
<reportElement x="240" y="2" width="28" height="16" uuid="f669244d-b327-4958-a2af-ab04410eb8cd">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
</reportElement>
<textElement>

</textElement>
<text><![CDATA[Sexo]]></text>
</staticText>
<staticText>
<reportElement x="320" y="2" width="80" height="16" uuid="933b83f3-1c17-422d-8b45-04766b73263c">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
</reportElement>
<textElement>

</textElement>
<text><![CDATA[D. Nascimento]]></text>
</staticText>
<staticText>
<reportElement x="450" y="2" width="50" height="16" uuid="b2af4af5-bdb0-4228-8cf1-c825eb1c3e41">
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement>

</textElement>
<text><![CDATA[Telefone]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement x="3" y="1" width="200" height="14" uuid="8b6c5281-1eaa-4087-9fed-133117a24511">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="083dcb10-7d57-4384-a1b0-d4aaccb94d2a"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Nome}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="250" y="1" width="10" height="14" uuid="69da0b65-9350-45d7-bf87-f3d99ee8c5c5">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5ddb6e73-805c-4c4f-9361-db02eacf5f13"/>
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Sexo}]]></textFieldExpression>
</textField>
<textField pattern="dd/mm/yyyy">
<reportElement x="330" y="1" width="60" height="14" isPrintWhenDetailOverflows="true" uuid="40416ea4-21ef-440b-945c-095c44ead21e">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="210e800f-09df-4d07-99eb-df1ca6d61d43"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="net.sf.jasperreports.export.xls.use.timezone" value="true"/>
<property name="net.sf.jasperreports.style.isBlankWhenNull" value="true"/>
<property name="net.sf.jasperreports.export.json.date.{path}" value=""/>
</reportElement>
<textFieldExpression class="java.util.Date">
                                       <![CDATA[$F{Data_Nascimento}]]>
                               </textFieldExpression>
</textField>
<textField>
<reportElement x="450" y="1" width="80" height="14" uuid="ae8c2ea3-514d-4acb-bdd8-9de6f05ec279">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e1ca290f-5449-4d46-9b1f-7bf2e0f79139"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$F{Telefone_Residencial}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="24" splitType="Stretch">
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<textField>
<reportElement x="272" y="5" width="10" height="15" uuid="16d38ac8-1ee0-4efc-b4ba-702193f3e169">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
</jasperReport>

Thanks.

1 month ago

Java in General

Seting SimpleDateFormat in JasperSoft Studio - JRXML

Hi,
I saw in the internet many examples that use the SimpleDateFormat for JasperSoft Reports but all example that I use in my jrxml I receiving errors. How realy I must do to set date in the format 'dd/mm/yyyy' in my report.
This is part of my jrxml.

Thanks in advance.

1 month ago

Java in General

Formatting date in Jaspersoft report

I will close this contact because I don't know what is happening

1 month ago

Java in General

Formatting date in Jaspersoft report

I am needing of someone to help me.
Thanks.

1 month ago

Java in General