Report Viewer - Setting the decimal places for a textbox value

Question

I'm using Report Viewer Control (rdlc) to generate reports. One of my columns have the value

=AVG(Fields!Reading.Value, "CellReading_Reading")

I'm getting the value with 10 or more decimal places. But i want to round it off to 3 decimal places. What is the expression for doing this?

Thank you. NLV

score 15 · Accepted Answer · answered Feb 06 '10 at 08:28

15

FormatNumber(AVG(Fields!Reading.Value, "CellReading_Reading"),3)

answered Feb 06 '10 at 08:28

cdonner

37,019
22
105
153

What if i want a string 5500 as 5,500? – NLV Feb 06 '10 at 09:54
Okie, i found the answer. Need to set the group digits to "true" in the same FormatNumber(). – NLV Feb 06 '10 at 12:04
[Here](http://stackoverflow.com/a/39305134/2218697) is my answer to set 3 decimal places without rounding off , is that correct ? – Shaiju T Sep 03 '16 at 09:07
but, this changes the number to string – vaheeds Oct 12 '18 at 17:38

score 2 · Answer 2 · edited May 31 '14 at 04:15

2

Right-click the textbox
Click the number
Select number from the category
Set Decimal Places to 0

edited May 31 '14 at 04:15

Arman H

5,488
10
51
76

answered May 31 '14 at 03:42

user3563118

21
2

score 1 · Answer 3 · answered Apr 12 '16 at 11:00

cdonner's answer was great and I incorporated it myself. If you have a slightly more complicated case as I did and you want to concatenate more than 1 field from more than 1 dataset you can do it like this...

=FormatNumber(Sum(Fields!Actual_Measurement.Value, "Measured_Result"), 1) & " (" & FormatNumber(First(Fields!Allowed_Min.Value, "Measured_Result_Details"), 1) & " - " & FormatNumber(First(Fields!Allowed_Max.Value, "Measured_Result_Details"), 1) & ")"

An example of what is displayed here would be ...

15.3 (12 - 16)

... If Actual_Measurement = 15.3, Allowed_Min = 12 and Allowed_Max = 16

In this case 1 entry in the "Measured_Result_Details" table relates to 1 or many entries in the "Measured_Result" table. Right clicking on the box and selecting "Expression", then looking in "Datasets" my two "Items" are "Measured_Result_Details" and "Measured_Result". This may be useful to anyone who has more than 1 dataset with fields from each dataset to be displayed in 1 Text Box!

score 0 · Answer 4 · edited May 23 '17 at 10:33

0

If you want without rounding off use Math.Truncate:

=Math.Truncate(1000*(AVG(Fields!Reading.Value, "CellReading_Reading")))/1000

Reference this and this post .

Hope helps.

edited May 23 '17 at 10:33

Community

1
1

answered Sep 03 '16 at 09:00

Shaiju T

6,201
20
104
196

score 0 · Answer 5 · answered Oct 12 '18 at 17:34

0

The simplest approach should be to just enter N3 in the format property of the textbox.

N stands for the number and C stands for the currency

Examples:

N0 format 123456.12 as 123,456

C2 format 1234.562 as $1,234.56

and so on ...

answered Oct 12 '18 at 17:34

vaheeds

2,594
4
26
36

Report Viewer - Setting the decimal places for a textbox value

5 Answers5

Linked