[runjva on as400 but no find class]

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

 

thanks for your time

Adriano 

[Jasper reports on as400]

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

[Jasper reports on as400]

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

[mode and parameter for call Jasper report on AS400]

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

[Alfanumeric cell in excel]

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 

[mix column alfa and numeric]

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

[Alfanumeric cell in excel]

[Alfanumeric cell in excel]

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

[mix column alfa and numeric]

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

[Cell input]

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

[Connectio to as400]

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

bye Adriano

[Connectio to as400]

The problem is error sql service and not connectio database db2

AS4000 release 7.1

 

thanks