Eclipse Community Forums: BIRT

Help

Home

Home » Eclipse Projects » BIRT » bigint problem

Show: Today's Messages :: Show Polls :: Message Navigator

bigint problem [message #891846]

Tue, 26 June 2012 05:27

smith link
Messages: 14
Registered: May 2012

Junior Member

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]

Report message to a moderator

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

Tue, 26 June 2012 20:28

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Tue, 26 June 2012 21:40

smith link
Messages: 14
Registered: May 2012

Junior Member

only in the crosstab

Report message to a moderator

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

Tue, 26 June 2012 22:01

smith link
Messages: 14
Registered: May 2012

Junior Member

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

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 03:05:25 EDT 2013