Friday, March 23, 2012

Making a matrix display zeroes and not blank cells

My matrix cell will only display blanks when the variable evaluates to a
zero. I need to zero to display.
I confirmed the problem is a display issue by forcing all the output to zero
as follows:
iif(1 = 1,0,Fields!MyField.Value)
In case it might be applicable, I am also using a formating string on the
cell as follows:
=iif(Fields!Category.Value <> "NoShow%","###","P")
Thanks in advance for any pointers.
--
John ShahanI solved it by modifying the formatting as follows:
=iif(Fields!Category.Value <> "NoShow%","##0","P")
John Shahan
"jp" wrote:
> My matrix cell will only display blanks when the variable evaluates to a
> zero. I need to zero to display.
> I confirmed the problem is a display issue by forcing all the output to zero
> as follows:
> iif(1 = 1,0,Fields!MyField.Value)
> In case it might be applicable, I am also using a formating string on the
> cell as follows:
> =iif(Fields!Category.Value <> "NoShow%","###","P")
> Thanks in advance for any pointers.
> --
> John Shahansql

No comments:

Post a Comment