Jump to content

sdnasir30

Members
  • Posts

    1
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by sdnasir30

  1. pls help me.i just downloaded version 5.0.0 and i need to present date field from mysql Db of type java.sql.Date.i have tried all the suggestions here but no result. but whenever i try i keep getting the error

     

     Compiling to file... C:UsersTrainning_02report1.jasper

    Compilation running time: 3,599!

     Filling report...

     Locale: English (United States)

     Time zone: Default

    Error filling print... Unable to get value for field 'trndate' of class 'java.sql.Date'

    net.sf.jasperreports.engine.JRException: Unable to get value for field 'trndate' of class 'java.sql.Date'      at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:319)      at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1330)      at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1231)      at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1207)      at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1554)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:149)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)      at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)      at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)      at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)      at com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:141)      at com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:238)      at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2210)      at com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2172)      at net.sf.jasperreports.engine.JRResultSetDataSource.readDate(JRResultSetDataSource.java:330)      at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:152)      ... 14 more 

    Print not filled. Try to use an EmptyDataSource...

     

     

×
×
  • Create New...