Truncation of decimals in a crystal reports report

  • We have made a Crystal report report with an ODBC connection to an SQL server database. We see that the decimals are truncated depending on the country settings. Does anybody know how we can avoid the truncation of decimals independend of the country setting?

  • Try formatting it in your select as a varchar/string, either leave it as a string or convert it back to a number having only the # of decimal places you need.

    Might want to take a look at their site, see if they have anything that would help:

    http://support.crystaldecisions.com/fix/

    Andy

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply