Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » bigint problem
bigint problem [message #891846] Tue, 26 June 2012 09:27 Go to next message
smith link is currently offline 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 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 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
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 link
Messages: 14
Registered: May 2012
Junior Member
only in the crosstab
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 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

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:
  


Current Time: Wed Oct 22 03:19:29 GMT 2014

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

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