SSRS number formatting

Epicor ERP 10
1

This is probably a simple question for those who know how to program this stuff.

I need to change the display format of certain values on the BOM Resource Availability Report. They should have no decimal points. I changed the Total values (OH, Avail) by using the text properties in SSRS. However, this doesn’t work for the other three fields, presumably because the “Decimals” bit is in the expression. I have tried to change it based on the expression of other values, but the whatever I changed either had no effect or generated an error when trying to upload the report. Picture below with the three fields identified.

BOM%20Av%20rpt%20pic
BOM Av rpt pic.png1056×406 90.8 KB

The expression for the three fields are:
(a)
=FormatNumber(Fields!OnHandQty.Value,First(Fields!DecimalsQuantity.Value, “RptParameter”))

(b)
=FormatNumber(Fields!AvailableQty.Value,First(Fields!DecimalsQuantity.Value, “RptParameter”))

(c.)
=FormatNumber(Fields!RequiredQty.Value,First(Fields!DecimalsQuantity.Value, “RptParameter”))

Thanks for your help on this.

2

You can change each expression to remove the “FormatNumber” and “First(…)” parts, so you’re left with:
=Fields!OnHandQty.Value
=Fields!AvailableQty.Value
=Fields!RequiredQty.Value

Then using the textbox properties will format the numbers the same as the totals.

2 Likes
3

Worked like a charm. Thanks.