Use space for Thousand Separator Reporting Services

Question

I need to show a number with a space for thousands of Ex: 650 128.33 or 1 150.39

How to do this in reporting services?

Answer 1

In the Format property for your text box, you can simply enter the format with a space:

# ###,##

Answer 2

You can use an expression for the value:

 =replace(Format(650 128,33, "## ### ##0.##") ,".",",") 

Answer 3

If you have a negative number, you will have a minus so far from the number.

I use this formula:

 =switch(len(format(abs(me.value),"0"))<7,"## ##0",len(format(abs(me.value),"0"))<13 and len(format(abs(me.value),"0"))>=7,"## ### ### ##0")