[#3696] - Excel Datasource fileds cannot change java.lang.integer

Posted by yusu.arakawa on June 25, 2014 - 1:09am
Category:
Bug report
 Priority:
Low
 Status:
Assigned
Project:
iReport Designer
 Severity:
Minor
 Resolution:
Open
Component: Reproducibility:
Not Attempted
 Assigned to:
Subscribe

I tried crosstab (Pivot Table) to watch as follow the video by jaspersoft studio.
https://www.youtube.com/watch?v=goMekbmIG2Y&list=PL6370A684081DAE8F

Excel Datasource cannot sum.
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unable to get value for field 'Budget Amount' of class 'java.lang.Integer'

Both Excel2007-2013 type and Excel97-2003 type is same error.

But CSV Datasource is fine.

AttachmentSize
Package icon issueDetails.zip44.93 KB
yusu.arakawa's picture
yusu.arakawa
710
Joined: Sep 21 2012 - 12:38am
Last seen: 3 months 2 days ago

5 Comments:

#1Posted by hozawa on June 25, 2014 - 4:41pm
  • Assigned:nobody»

That's obvious because the video is applying formatting to numbers fields - this just converts numbers to Strings.

#2Posted by hozawa on June 25, 2014 - 4:41pm
  • Status:New» Feedback Requested
  • Assigned:» anonymous
#3Posted by yusu.arakawa on June 25, 2014 - 5:10pm

Of course,I changed String fields to Integer.
But,Excel data source occur this error.

#4Posted by teodord on April 21, 2015 - 7:32am
  • Status:Feedback Requested» Assigned
  • Assigned:anonymous» shertage
#5Posted by shertage on April 28, 2015 - 5:48am

I was unable to reproduce it in iReport v5.5.
The bug seems to be related to iReport v4.0.1

Feedback
randomness