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

Category:
Bug report
Priority:
Low
Status:
Assigned
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Not Attempted
Assigned to:

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
Joined: Sep 21 2012 - 12:38am
Last seen: 3 months 2 days ago

5 Comments:

#1
  • Assigned:nobody»

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

#2
  • Status:New» Feedback Requested
  • Assigned:» anonymous
#3

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

#4
  • Status:Feedback Requested» Assigned
  • Assigned:anonymous» shertage
#5

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

Feedback
randomness