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...