Post reply

how to roundoff the currency.

  • 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..

  • 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

  • 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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

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