Report Number Fields


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!


grenkas's picture
Joined: Feb 22 2022 - 12:18pm
Last seen: 1 year 1 month ago

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!

grenkas - 1 year 1 month ago

1 Answer:

Have you tried to change the Class Type (i.e. dollar amounts - to java.lang.Double)  in JasperStudio Dataset and Query Dialog window?

bigalex's picture
Joined: Apr 12 2019 - 9:15am
Last seen: 1 year 3 weeks ago