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!
Attachments:
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!