Truncation of decimals in a crystal reports report

• andre luijkx

  Newbie

  Points: 1

  More actions

  September 7, 2001 at 5:47 am

  #157992

  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?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 7, 2001 at 3:06 pm

  #418089

  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

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter