Precision of Float settings in rdlc reports-decimal places

1. Round () function

The parameter of this function must be of the floating point type. Therefore, the format must be converted first. If it is null, the conversion will fail. When the column is empty, the value 0.00 is displayed. This is not easy to understand.

2. formatnumber () function

The format of this function is 123,456,567.00. "," Is added to the data. Not nice.

The above two functions are combined with expressions and bound to fields. For example:

= Formatnumber (sum (cdbl (Fields! Usage. Value )))

= Round (sum (cdbl (Fields! Usage. Value )))

3. Set attributes of the rdlc text box

The third method is that I recommend a good one.

For example, select the text box attribute --- format --- number

Select a format. By default, if F is displayed above, two decimal places are reserved. You can also write F3 to display three decimal places. F2 indicates two decimal places. You can use NotePad to open the rdlc file.CodeYou will be surprised to find that the formatting and field are written separately. <Format> F </format>. Therefore, you can exclude many exceptions, such as null.

Share from http://hi.baidu.com/ren_long _/