RDLC format number function

Question

I have values ​​in db:

10.4 33 42.87 1.01 22.1 8 

I know that I can format numbers in my RDLC reports, however, how can I make sure that the output will always be:

 10.40 33.00 42.87 1.01 22.10 8.00 

you will notice that I need to show two decimal points, even if the number does not have them,

Answer 1

Argh .... google helped, it's pretty simple:

 =FormatNumber(Fields!SomeField.Value,2) 

Answer 2

You can also use the Format property of your TextBox ; eg:

 Format = "f2" 

Using the format, you can use "c" to format the currency (i.e., "c2" ).

Answer 3

 FormatCurrency(Expression as object, NumDigitsAfterZero as tristate, IncludingLeadingDigit as tristate, UwseParenseForNegativeNumbers as tristate, GroupDigits as tristate) as string 

I tried using the Number tab settings for the placeholder and did nothing. The above work.

Answer 4

Right-click the [TextBox] control in the RDLC, TextBox, SelectNumber, CAtegory-Number, See Decimal Places - 2 properties, click Ok.