Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » bigint problem
bigint problem [message #891846] Tue, 26 June 2012 09:27 Go to next message
smith link is currently offline smith linkFriend
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 09:38]

Report message to a moderator

Re: bigint problem [message #892042 is a reply to message #891846] Wed, 27 June 2012 00:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
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

Report message to a moderator

Re: bigint problem [message #892052 is a reply to message #892042] Wed, 27 June 2012 01:40 Go to previous messageGo to next message
smith link is currently offline smith linkFriend
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] Wed, 27 June 2012 02:01 Go to previous message
smith link is currently offline smith linkFriend
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:39:13 GMT 2024

Powered by FUDForum. Page generated in 0.02701 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly