Crystal Report From SQL Not Pulling Decimal

[zigstick]

Hello, I'm running Crystal Reports 2000 and reporting against a SQL database view via an ODBC connection.
I've been running reports against SQL for years, no issues. Today when trying to pull data from a SQL view, a number field if failing to bring in decimals. It shows 100.00 instead of 99.5. Checked my Crystal Report options and there no truncating turned on there.

If I use a Command and paste the SQL statement, it brings in the number correctly. Also checked the field type and the number is "tinyint". Could that be an issue?
As I said, I have a workaround, using SQL, but worry about existing reports that me be returning incorrect data when using a Crystal query.

Thank you for any insight!

Mark

 

[kray4660]

It is interesting that you say the number is tinyint. Tinyint would not have any decimal places, just a whole number.