I am trying to make a change in the production detail report in E10.1.500.32
The expression that I am working with is this =IIF(Fields!PONum.Value=0,"",FormatNumber(Fields!PONum.Value,0))
it returns the PO number in the report, but the problem is that the PO number has a comma separator in it.
It should be a whole number EX: 12345 not 12,345
I have tried the properties of the box and set it to no comma separator but that doesn’t change it to a whole number.
is there something in this expression that can take the comma separator out of the number?
I believe you change the properties of the text box/placeholder field to be numeric with no separator
Thanks for the info, it worked.
Al - I don’t think that would work, as this calculation returns a text string.
It might be possible to not use the calculation at all (just use the Fields!PONum.Value), and set the Text Box Property’s Number type such that it displays a blank for the value 0.
I don’t know if this (vs Ben’s solution) result in different renderings - with respect to growing, height, etc…)
duh (forehead slap)
gary specifically stated in the first post - that he already tried the properties
my bad pardon my useless info
luckily Ben had the right answer