how to roundoff the currency.

• raghu-935218

  Newbie

  Points: 0

  More actions

  May 12, 2009 at 11:00 am

  #384568

  Hi how to roundoff a number in SSRS....I am using this expression to display the value in $

  Formatcurrency(Fields!P1T2P.Value)......But i want ot roundoff the number....

  for example....if the number is 567.28 i want to display as 567 and if it is 567.56 the it should display 568.......Please help me in writing this expression..

• Wesley Norton

  Newbie

  Points: 0

  More actions

  May 12, 2009 at 2:13 pm

  #993264

  Are you unable to use the ROUND() function in SQL?

  http://doc.ddart.net/mssql/sql70/ra-rz_20.htm

• Niraj-627298

  Newbie

  Points: 0

  More actions

  May 14, 2009 at 4:06 am

  #994350

  Hi Raghu,

  Many regards.

  Hey, did you try using Round function?

  Try once,

  =Round(Fields!Valuetoberounded.value)

  This should help.

  Thanks alot,

  Niraj

• MacDaddy

  Newbie

  Points: 0

  More actions

  June 3, 2009 at 4:50 am

  #1003889

  Apologies if I've missed the point but why not just apply code 'C0' to the textbox format property?

  Paul

  Keep the rubber side down and the shiny side up.