CODEWITHSUNDEEP
reporting-servicesnumber-formattingssrs-2012
Novice_Techie
Novice_Techie

Reputation: 444

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

Upvotes: 5

Views: 24999

Answers (2)

vahid basirat
vahid basirat

Reputation: 455

in your designed report in SSRS , type below in format section of your textBox

#,0;(#,0)

it works exactly as what u want

Upvotes: 0

Louie
Louie

Reputation: 538

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

Upvotes: 9

Related Questions