reporting-servicesssrs-2008trimssrs-2008-r2

SSRS trim trailing 0's from double


I have a calculated field that returns a double "2.000" how can I format this to get rid of unneeded 0's? So that the following occurs:


Solution

  • Cast it into a double like this:

    CDbl(value)