Chart does not display decimal place

Scriptcase 9 General
#1

Hi,

I have written a sql statement with some join to combine tables. There is a column that has 2 decimal place (eg. 3.67).

But when I create a chart and then put this sql statement, the chart display for the number will be a whole number (eg. 3) even I have set the decimal precision to 2.

Can anyone kindly advise how to display 2 decimal place?

#2

Post your Sql… may be something up with that

#3

Also, the Database source for this data field, what is its data type?