Member Avatar for hallianonline

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

  • 3 Contributors
  • 2 Replies
  • 226 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Santanu.Das
Member Avatar for Mike Bishop

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

Member Avatar for Santanu.Das

check the field formatting property correctly.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.