bassi

I imported in directory as400 my file .jar and .jasper but when call runjva the class int find ??? thanks for your time Adriano

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

I create a file jar on my pc and transfert on dir to as400 but my problem is call on as400 the report thanks for help By Adriano

My target is in automatic create a csv file for import on AS400 but I see it is not possible. I find other method By 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

Thanks , but with jasperreport I can connection to as400 because this problem ? bye Adriano

The problem is error sql service and not connectio database db2 AS4000 release 7.1 thanks