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!
Posted on February 23, 2022 at 8:42am
Have you tried to change the Class Type (i.e. dollar amounts - to java.lang.Double) in JasperStudio Dataset and Query Dialog window?
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!