Post reply

Reporting Services: Format Count to include comma notation

  • October 29, 2007 at 1:02 pm

    #179665

    Currently this is what I have in Report Services Designer

    Code I currently have Current Result

    =Count(Fields!AccountId.Value, "Extract") 12000

    The Objective is to have my result like this (in bold below)

    What expression can I use? Desired Result

    12,000 formatted

  • October 30, 2007 at 1:18 am

    #746485

    You may try bold or font weight

  • October 30, 2007 at 2:40 am

    #746510

    In the Format property for the textbox that displays the number, use N0 (N - zero). That displays a number with thousands separator and no decimals.

    Hope this helps,

    Scott Thornburg

  • October 30, 2007 at 7:18 am

    #746622

    Scott,

    Thank you for your quick response and your suggestion did the trick.

    Mickiel

  • June 10, 2008 at 1:21 am

    #826476

    Thanks for your response..

    But suppose if the value is custom formatted how can we place comma separator .

    for example what i gave is "=Round(Sum(Fields!CashPrev.Value),0)".The result am getting is 12000.Now if i want to add comma in the result means what will i do.In reporting services only.

    Thanks

    Dimple

  • June 10, 2008 at 8:08 am

    #826668

    =Format(Round(Sum(Fields!CashPrev.Value),0),"#,##0")

  • June 12, 2008 at 2:58 am

    #827704

    Thank you !!!!!!!

    It works

  • June 17, 2009 at 3:50 pm

    #1011334

    How can I do the same but in a chart?

  • October 22, 2015 at 3:41 pm

    #1835037

    In SSRS, to format with commas, on the design tab, right click on field to be formatted, select either Placeholder Properties or Text Box Properties (whichever one shows up). In the Properties window that pops up, select Number. Now check Use 1000 separator (,). You can also specify the number of decimal places and the notation to use for negative numbers here.

Viewing 9 posts - 1 through 8 (of 8 total)

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