dev_34 Posted February 25, 2019 Share Posted February 25, 2019 Hi there!What's that strange message?? It finds the titles, but it doesn't find the value in the sheet, what is that?Regards, Jan Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 removing the empty row below of the titles does also not help. (?) Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 trying it without a group files does also not solve that issue!! Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 "trying it without a group files does also not solve that issue!!" I MEANT:"trying it without a group field does also not solve that issue!!" Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 After removing the empty row below of titles, now i got same error for field "Strasse Nr.", before it was "Namen Firmenkunde". Your app seems to have problems with a simple "hello world" application, can't really believe that... Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 forum-related question: why i got confirmations mails on my OWN mailbox for my OWN conmments? does also not make sense in my opinnion... Link to comment Share on other sites More sharing options...
dev_34 Posted February 25, 2019 Author Share Posted February 25, 2019 Similar problem?-> https://community.jaspersoft.com/questions/541824/error-unable-get-field-value Link to comment Share on other sites More sharing options...
hozawa Posted February 25, 2019 Share Posted February 25, 2019 This happens when the value in the Excel sheet that you're trying to use as the datasource does not match with the data type you've specified. Link to comment Share on other sites More sharing options...
dev_34 Posted February 27, 2019 Author Share Posted February 27, 2019 In Jaspersoft Studio, all columns are defined as java.lang.String -> that should not matter which values are in excel sheet! Values in excel sheet my be "0" or "my text" - that should not matter.* (But it's NOT a number, it's a string in that problematic row)* But not vice versa - int datatype in Jaspersoft Studio does not match with string in excel sheet, or genereally, the datasource. (whatever it is..)Jaspersoft Studio seems to have serious problems with a simple hello world app - that's a lil bit strange in my opinion...Maybe the problem is that the file was exported from LibreOffice Calc to .xlsx format...? Link to comment Share on other sites More sharing options...
dev_34 Posted February 28, 2019 Author Share Posted February 28, 2019 ...can't believe that there is no solution for such a simple problem! Link to comment Share on other sites More sharing options...
dev_34 Posted March 15, 2019 Author Share Posted March 15, 2019 Problem still exists... Link to comment Share on other sites More sharing options...
dev_34 Posted September 23, 2019 Author Share Posted September 23, 2019 Now i will test it with the new version 6.9.0, i will not wonder if the problem still persists...;-)Best regards, Jan...yes, i was right. Problem still persists.How to set the data type for a column? Can't see any options related it it. I can only see "Stretch Type" and "Position Type", which are layout things.Where is the "datatype" setting for a field/column??? Link to comment Share on other sites More sharing options...
r.ritzal Posted September 27, 2019 Share Posted September 27, 2019 Same Problem here.I just tried to see if Jasper might be useful to me, but on my first report i got the same error. I tried to change the data type of the field, but it doesnt work. It also seems that this problem exists with every field from the Excel, as it doesnt work if i just remove the field that had the error.However, i just tried to build a report that based on a .CSV and it did work. Is it possible that Jasper has a Problem with Excel? Link to comment Share on other sites More sharing options...
wilson3838 Posted April 15, 2021 Share Posted April 15, 2021 I'm getting the same error when attempting use a .csv file as a data source - "net.sf.jasperreports.engine.JRException: Unable to get value for CSV "weight" of class java.lang.Integer". The weight column contains nothing more than integers. The .csv file was exported from DBeaver. Does anyone have ideas on what causes the error? Link to comment Share on other sites More sharing options...
beatrice.guardini Posted March 10, 2023 Share Posted March 10, 2023 I'm getting type number as format of excel cell and i modified type of colum as java.math.BigDecimal in jasper, after read fileds.It's working. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now