Eclipse Community Forums: BIRT

Home » Archived » BIRT » bigint problem

Tue, 26 June 2012 05:27

Eclipse User

birt 2.3.x

Database data type is bigint, birt data type is Decimal, There are some code in org.eclipse.birt.report.data.oda.jdbc_2.3.1.v20080827/plugin.xml

<dataTypeMapping
               nativeDataType="BIGINT"
               nativeDataTypeCode="-5"
               odaScalarDataType="Decimal"/>

sometimes I get a negative number at the cross table summary fields .

for example>>>>
SQL result: 130265097291150
birt result: -1260796530

[Updated on: Tue, 26 June 2012 05:38] by Moderator

Re: bigint problem [message #892042 is a reply to message #891846]

Tue, 26 June 2012 20:28

Eclipse User

Do you get this issue when use just a table or is it only in the crosstab?

Jason

On 6/26/2012 5:27 AM, smith link wrote:
> birt 2.3.x
>
> Database data type is bigint, birt data type is Decimal, There are some
> code in org.eclipse.birt.report.data.oda.jdbc_2.3.1.v20080827/plugin.xml
>
>
> <dataTypeMapping
> nativeDataType="BIGINT"
> nativeDataTypeCode="-5"
> odaScalarDataType="Decimal"/>
>
>
>
> sometimes I get a negative number at report.
>
> SQL result: 130265097291150
> birt result: -1260796530

Re: bigint problem [message #892052 is a reply to message #892042]

Tue, 26 June 2012 21:40

Eclipse User

only in the crosstab

Re: bigint problem [message #892055 is a reply to message #892042]

Tue, 26 June 2012 22:01

Eclipse User

I'm very sorry, it's my fault! Both summary fields and binding data fields need to be Decimal. Very Happy

Thanks Jason.

Jason Weathersby wrote on Tue, 26 June 2012 20:28

Do you get this issue when use just a table or is it only in the crosstab?

Jason

On 6/26/2012 5:27 AM, smith link wrote:
> birt 2.3.x
>
> Database data type is bigint, birt data type is Decimal, There are some
> code in org.eclipse.birt.report.data.oda.jdbc_2.3.1.v20080827/plugin.xml
>
>
> <dataTypeMapping
> nativeDataType="BIGINT"
> nativeDataTypeCode="-5"
> odaScalarDataType="Decimal"/>
>
>
>
> sometimes I get a negative number at report.
>
> SQL result: 130265097291150
> birt result: -1260796530

Previous Topic:	How to override the function for the "Finish" button on a Data Source Wizard Page?
Next Topic:	Adobe live cycle & POI comparison

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 12:10:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter