Search code examples
reporting-servicesnumber-formattingssrs-2012

Specify thousand separator in ssrs without specifying decimal


MY database have values like 3302540.8200 748712.9600 584879.2400 20787.5300 1338075.0000

I need the above values like below in my SSRS reports 3,302,540.82 748,712.96 584,879.24 20,787.53 1,338,075

I tried custom format for number on my text box #,0.######## but while exporting it in excel it is showing the value 1 as 1. (dot is not desirable)

help me with this. TIA


Solution

  • Using the following as the datasource:

    SELECT 3302540.8200 Number UNION
    SELECT 748712.9600 UNION
    SELECT 584879.2400 UNION
    SELECT 20787.5300 UNION
    SELECT 1338075.0000 UNION
    SELECT 1000 UNION
    SELECT 10123.20
    

    You could use the following expression in your output table/Textbox:

    =Format(Fields!Number.Value,"#,#.##")
    

    Excel Output:

    1,000
    10,123.2
    20,787.53
    584,879.24
    748,712.96
    1,338,075
    3,302,540.82