SSRS Expression

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?


1 Like

I believe you change the properties of the text box/placeholder field to be numeric with no separator


Thanks for the info, it worked.


1 Like

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)
you’re right.
gary specifically stated in the first post - that he already tried the properties
my bad :frowning: pardon my useless info

luckily Ben had the right answer