>-----Original Message-----
>I have an entry in a database - sql-2000 that's defined
as decimal
>with a length of 22,0. I'm trying to retieve this field
and display it
>in crystal report. I'm currently doing this from crystal
report
>designer. It shows up as 2E21. I've tried formatting the
fields using
>format field from the format menu. But the best i can do
is display it
>still in terms of maybe 2.0029E+21.

>How can i display these values as say exactly how i view
them as in
>sql server - 298292829928291829989.

>Maybe the best way would be convert them into a string
value ...But
>how do i do that. I'v  tried also a formula field and
setting values
>using TOTEXT({field}) but it still truns up that way 2e+21
>??

>Right now i'm experienceing this problem from Crystal
designer. I
>tried it out in VB and i'm still getting the same problem
>In dire need of help

>Thank You
>.

> I have an entry in a database - sql-2000 that's defined as decimal
> with a length of 22,0. I'm trying to retieve this field and display it
> in crystal report. I'm currently doing this from crystal report
> designer. It shows up as 2E21. I've tried formatting the fields using
> format field from the format menu. But the best i can do is display it
> still in terms of maybe 2.0029E+21.

> How can i display these values as say exactly how i view them as in
> sql server - 298292829928291829989.

> Maybe the best way would be convert them into a string value ...But
> how do i do that. I'v  tried also a formula field and setting values
> using TOTEXT({field}) but it still truns up that way 2e+21
> ??

> Right now i'm experienceing this problem from Crystal designer. I
> tried it out in VB and i'm still getting the same problem
> In dire need of help

> Thank You