Decimal DataType

Hi,
I have a column ,Lines decimal(10,2).

The data in this column is not properly displayed in crystal reports.
Eg: the data in the column is 24.34, it's being displayed like 345234352

Why this is so? When the data type is int, there's no problem. Because of this I'm not able to display decimals in my report. Which data type in sql server is apt for my task.

Please help.

Thanks

M.L.Srinivas

You may just want to use the data type of float, which would give you what you need. Although it can store numbers much larger than what you declared in your decimal, it may fix your problem in the way that crystal reports is printing out your data.

May be i can share my experienced using crystal report. I have a problem using date time format. In SQL, i can execute my stored procedure correctly. The Date time format is 1900 -xx- xx 00:00. When i created in the crystal report. the data is in numeric value.
May be crystal report has a minimum datetime format. i guess that year 1900 doesn't really supported.



Reference to your problem, may be your datatype is overflow. Please check again.

Regards

Tonny