Decimal Place on Pick List

[MStott (Martyn Stott)]

Hi,
Bit of a novice with SSRS so here goes.
The Sales Order pick list report uses the following formula for its quantity
=FormatNumber(Fields!Calc_RelQty.Value, First(Fields!DecimalsQuantity.Value, “RptParameter”))
This only displays to 2 decimal points, how can I make the formula return 3 decimal points.

[dcamlin (David Camlin)]

Try:

=FormatNumber(Fields!Calc_RelQty.Value, 3)

[MStott (Martyn Stott)]

Hi David,
thanks for responding. I tried your suggestion and it only works if you select no filter in the parameters report. The second half of the expression is looking for the parameter.

[dcamlin (David Camlin)]

@MStott

if you select no filter in the parameters report.

What do you mean by that?

@MStott

The second half of the expression is looking for the parameter.

Not sure I understand. Its only looking for the parameter because the expression is telling it to. By putting a number in there, it should be using that to determine the number of decimal places instead of a “parameter”.

[MStott (Martyn Stott)]

If I replace the expression with the one suggested the parameter part does not work on the report.

[bruce6s (Bruce Crile)]

You can try this. I use this in my SSRS reports. For the Expression, just use ‘=Fields!Calc_RelQty.Value’. I then update the Number Properties to what I desire via the Text Box Properties for the field.

[MStott (Martyn Stott)]

Thanks guys that has worked.