iReport: Numbers from Excel-Source are always 10x

0

I got an Excel-Source with a Simple Table:

Soda  Respondents

Coke   100

Pepsi  100

7-Up    33

 

On Import the Numbers appear as 10x theire expected value (Coke and Pepsi get the Respondents-Value 1000 and 7-Up gets 330)

I tried java.lang.Integer and java.lang.Number as Field Class for the field Respondents.

The Problem appears direktly when i do the Preview-Data in the Report-Query.

I tried formatting the Cells in Excel from standard to numeric

 

s.barzyk's picture
Joined: Mar 19 2013 - 10:21am
Last seen: 6 years 4 months ago

0 Answers:

No answers yet
Feedback
randomness