number import showing in exponential form

[jceereid]

I am simply trying to display a number from an Oracle table that is defined as qty (number). When I insert the column onto the report it is in exponential form. I checked the data in the table and it is a whole number. What am I missing here? I have tried a few things with formatting and it does nothing. Can someone offer a simple solution on the crystal side that I can't seem to find anywhere?

 

[kenhamady]

First do a verify of the database and see if that helps.
Is this the only numeric that causes a problem? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com