Long numbers in Crystal 2

[Alundil]

SQL 2000
CR XI

I have some very long numbers in SQL database (DBOID that are 21 digits long) however, each time I try and add to a report, they are converted into Scientific notation. I would like to display the entire number. Does anyone know how to do this?

Note, the data type in SQL is (Numeric, 21, 0)

Thanks,



-- Andy

 

[synapsevampire]

Create a SQL Expression formula of:

cast(table.field as varchar(21))

Now you can display them as strings.

-k

 

[Alundil]

THANKS SYNAPSE



-- Andy