Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » bigint problem
bigint problem [message #891846] Tue, 26 June 2012 05: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 05:38]

Report message to a moderator

Re: bigint problem [message #892042 is a reply to message #891846] Tue, 26 June 2012 20: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] Tue, 26 June 2012 21: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] Tue, 26 June 2012 22: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 Aug 27 11:21:26 EDT 2014

Powered by FUDForum. Page generated in 0.02073 seconds