rashmitha

Hi.. Could anyone tell me, how to trim the whitespaces, while taking the input from an excel file?? If the input source is a DB, then we have a trim option. But for an excel file this option is not present. I am new to JaperETL. Any help regarding this would be great..! Thanks and Regards, Rashmitha

Hello, What are the steps to follow to access a Thai database and display it in the Report? I get the following error : Error filling print... Unable to get value for field 'date' of class 'java.lang.String' net.sf.jasperreports.engine.JRException: Unable to get value for field 'date' of class 'java.lang.String'     at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:313)     at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823)     at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787)     at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1474)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:938)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:841)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:858)     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: Unsupported character encoding 'TIS620'.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)     at com.mysql.jdbc.ResultSetRow.getString(ResultSetRow.java:793)     at com.mysql.jdbc.ByteArrayRow.getString(ByteArrayRow.java:67)     at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5571)     at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5448)     at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:235)     ... 12 more Print not filled. Try to use an EmptyDataSource... Please help. I am new to iReports. Thanks and Regards.