none
format numbers with no decimals

    Question

  • how do you fomat numbers with no decimals in SSRS...i have tried  d0 in the properties of the fielf and fomat(expression) in expression editor...no luck
    Tuesday, August 10, 2010 10:42 PM

Answers

  • Hello,

    Try it with N0 for numeric + 0 decimals


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, August 11, 2010 5:15 AM

All replies

  • Hi Kdwenze,

    try this in your expression

    Format((Fields!fieldname.Value),

    "#,###;(#,###)")

    so for example if the number is 3456.667

    then using the above expression it will display 3456

    is that what you are trying for??

    update me.

    all the best

     


    Dasari
    Tuesday, August 10, 2010 11:16 PM
  • Hello,

    Try it with N0 for numeric + 0 decimals


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, August 11, 2010 5:15 AM
  • Hello,

    Use N0 in the format propeties or use Format(Fields!FieldName.Value,"N0")

    Hope its helpful....


    Pavan Kokkula Infosys Technologies Limited.
    Wednesday, August 11, 2010 5:20 AM
  • kewenze,

    Have you solved the issue following Pavan's direction? besides this, you could also click the textbox of that datafield and press F4 button to open property grid window, then find out Format property in the property grid window, and type in N0

    If you have any question, please feel free to ask.

    Regards,

    Challen Fu

    Wednesday, August 11, 2010 5:52 AM