reporting services - Round or change format for report for one column only -


i created report works great.

does know how format without changing rest of columns? see red box. answer should 0.01.

i changed format decimal changes columns , need other columns whole numbers , amount ob column able have decimals.

data

you can numerous ways rdl. 1 way set text box properties, on number tab. or in expression of value so:

=formatnumber(fields!weight.value,2) 

enter image description here

if need round number can in expression so:

=round(fields!weight.value,2) 

Comments