I have a problem that my crystal report shows the decimal values as 00 every thing is fine but it does not display proper value e.g.
If i have 0.235 it shows 0.000 If i have 2.356 it shows 2.000
Whats the matter behind it the database field is text based
Jump to Postcheck the field formatting property correctly.
convert the text to a number
If NumericText ({field}) then ToNumber ({field}) else 0
you may also have to do a calulation to make it into a decimal number
check the field formatting property correctly.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.