Eclipse Community Forums: BIRT » Data in Mongo DB are not displaying correctly in BIRT tool.

Home » Archived » BIRT » Data in Mongo DB are not displaying correctly in BIRT tool.(Data in Mongo DB are not displaying correctly in BIRT tool.)

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

Data in Mongo DB are not displaying correctly in BIRT tool. [message #1060906]

Wed, 29 May 2013 06:11

Balveer singh

Messages: 1
Registered: May 2013

Junior Member

Data in Mongo DB are not displaying correctly in BIRT tool.

Kindly find screen shot in which we have NETVAL and QTY Column that display 0 on BIRT tool, but its not actually in MongoDB.

Attachment: Untitled.png
(Size: 99.14KB, Downloaded 746 times)

Report message to a moderator

Re: Data in Mongo DB are not displaying correctly in BIRT tool. [message #1061055 is a reply to message #1060906]

Wed, 29 May 2013 17:02

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Is this with the new MongoDB ODA in 4.3?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Data in Mongo DB are not displaying correctly in BIRT tool. [message #1101258 is a reply to message #1061055]

Wed, 04 September 2013 08:06

Ludovic PAQUET

Messages: 3
Registered: September 2013

Junior Member

Hello,

I have exactly the same issue with mongodb Number field and Birt 4.3.

The problem is that the field is stored sometimes as an Integer sometimes as a Float in mongo. Consequently Birt does not know how to parse the field.
Let say that the output column is in float in Birt, when we have for instance 53 birt renders 0, when we have 53.23 birt renders the correct value. If the output column is integer, 53 is rendered correctly and 53.23 is rendered by 0.

Someone knows how to avoid such a behaviour ?

Thanks,

Ludovic

Report message to a moderator