Specify thousand separator in ssrs without specifying decimal

Question

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

can't you just use a normal number format with , separators and 2 deecimal places? — tomdemaine
I can't specify 2 decimal places. If the value in db is 12345.12300 then my report should show 12,345.123. Appending 0 after decimal and applying thousand separator on the value is what i require. — Novice_Techie

Louie Louie · Accepted Answer · 2016-09-30T01:30:49

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

Specify thousand separator in ssrs without specifying decimal

2 Answers