Query preview shows incorrect data?

[doktor_j]

In building a report, a coworker came to me with an issue with the preview of data from the stored procedure he was invoking. I tested this in 3.7.4 (the current version of iReport we are using) and 3.7.6; the report itself generates fine, but the data preview for the query shows incorrect data.

Reading the fields, the stored procedure is identified as return:  1 Integer, 7 Strings, 2 Timestamp, 4 BigDecimal, and 3 Double

The problem seems to exist in one of the BigDecimal fields, and a Double field.

The BigDecimal field in question should have returned 9.338541, but instead returned -370.

The Double field in question should have returned ;0, but instead returned -0.012500.

Has anybody else seen this? This really through us for a loop for a while until we realized that the report was actually showing correct data (our initial thought was that the stored procedure was not returning correct values, but the sql programmer who built the stored procedure assured us ... and we verified this through SQL Server Management Studio Express ... that the data was, indeed, being returned correctly.

 

Thanks,

 

john