grenkas Posted February 22, 2022 Share Posted February 22, 2022 Hello,I created a data source via a .xlsx document with names, dollar amounts and dates. When I create a new report template and add in any field it gives an error not recognizing any fields that are number based. If I remove all the number fields from the data source then it will provide a preview. However I need those.I don't want to change all the fields in the .xlsx document to Text since I want to run sum formulas. Is there anything I can do to get these number fields to populate? Change the class?Thank you for you help! Link to comment Share on other sites More sharing options...
Solution bigalex Posted February 23, 2022 Solution Share Posted February 23, 2022 Have you tried to change the Class Type (i.e. dollar amounts - to java.lang.Double) in JasperStudio Dataset and Query Dialog window? Link to comment Share on other sites More sharing options...
grenkas Posted February 23, 2022 Author Share Posted February 23, 2022 I did set up a basic dataset to try and figure it out and that did work when I changed it to java.lang.Integer. I also check a box in the Dataset option to skip the first column. So I think I got it now, thanks! 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