on as400 I do not know the java environment, I wanted to understand if I'm on the right track to get the result and parameterize the jasper report to get prints much better than what you can get with the overlay graphics excuse my English thank you Adriano
someone has experience with jasper reports and AS400 after creating the jar file and migrating on the system with the runjva command you are able to run the application but does not produce anything in what is wrong? Thanks in advance Adriano
Thanks for your response but my case is colum A1 = Adriano and colum A2 = 100 in this case iasper interrupt elaboration file because numeric field not in string. I have other answer in this case inside there is excel file demo Thank for your time By Adriano
I have this error in column C in this excel there is letter and number , i hope there is mode for bypass the problem Caused by: net.sf.jasperreports.engine.JRException: Unable to get value for Excel field "COLUMN_2" of class java.lang.String. at net.sf.jasperreports.engine.data.AbstractPoiXlsDataSource.getFieldValue(AbstractPoiXlsDataSource.java:392) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1489) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1390) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1366) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1085) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:582) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.IllegalStateException: Cannot get a text value from a numeric cell at org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:648) at org.apache.poi.hssf.usermodel.HSSFCell.getRichStringCellValue(HSSFCell.java:725) at org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:708) at net.sf.jasperreports.engine.data.AbstractPoiXlsDataSource.getFieldValue(AbstractPoiXlsDataSource.java:309 Thanks for help
I have excel file where column A in line 1 is alfanumeri ex Adriano and column A line 2 is 10 the filld is define string when i read the data have error the system non convert numeric fiel colum A for me is alfanumeric what can do for bypasse the problrm ???? thanks for help By Adriano
I read excel file , in column B there in line 3 there is alfanumeric text ex. CDS/XlM , in colum B in line 4 there is 1,546. when read the file have the error. There is method for imported the value some string ? Thanks Adriano