RDLC format number function

stoic picture stoic · Mar 14, 2014 · Viewed 37.9k times · Source

I have values in a db:

10.4
33
42.87
1.01
22.1
8

I know I can format numbers in my RDLC reports, however, how can I make sure that the output of the data 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 has none,

Answer

stoic picture stoic · Mar 14, 2014

Argh.... google helped, it is quite simple:

=FormatNumber(Fields!SomeField.Value,2)