locked
Formating RRS feed

  • Question

  • Hi all,

    I have the following data

    23345
    435657
    2122

    how can i get this format


    23,345
    435,657
    2,122

    pleasee help me?
    Monday, November 30, 2009 12:17 PM

Answers

  • Hi,

    Try this


    = FORMAT(Fields!Number.Value, "N0")


    Rajesh Jonnalagadda http://www.ggktech.com
    Monday, November 30, 2009 1:12 PM
    Answerer
  • Hello,

    You can get this as suggested by Rajesh.

    The same in a different manner is as follows:

    1. Go to the cell and right click and go to the properties window.
    2. In the properties window go to the Format Tab.
    3. In the format tab select the Custom Format radio button.
    4. In that place N0 as the format code.

    Hope its clear...


    Pavan http://www.ggktech.com
    Monday, November 30, 2009 3:12 PM

All replies

  • if you want to show in Reporting services then there is a format tab on text box....is it in T-SQL?
    Monday, November 30, 2009 12:24 PM
  • Hi,

    Try this


    = FORMAT(Fields!Number.Value, "N0")


    Rajesh Jonnalagadda http://www.ggktech.com
    Monday, November 30, 2009 1:12 PM
    Answerer
  • Try writting in the expression Fields!X.value where X is the name of the field.

    Selecting the cell clic the right button of the mouse and select properties. In the format tab and in the format code field write N3

    good luck!

    Monday, November 30, 2009 3:09 PM
  • Hello,

    You can get this as suggested by Rajesh.

    The same in a different manner is as follows:

    1. Go to the cell and right click and go to the properties window.
    2. In the properties window go to the Format Tab.
    3. In the format tab select the Custom Format radio button.
    4. In that place N0 as the format code.

    Hope its clear...


    Pavan http://www.ggktech.com
    Monday, November 30, 2009 3:12 PM
  • I think Rajesh and Pavan are right, I misunderstood the question.
    Monday, November 30, 2009 3:37 PM