Monday, March 12, 2012

Matrix Conditional Formatting

I have a matrix and want to put a border on only one column. I have
this expression in the right and left borderstyle property:
=iif(First(Fields!desc.Value)="Sent Census","Solid","None")
So if the value column = "Sent Census" then I want the column to have a
left and right border. My problem is that if the data cell has a 0 in it, the
border doesn't appear. I know why, I'm just looking for a work around to
have the whole column bordered even if a 0 is placed in the data cell.
Thanks!Seems like as soon as I post a question, I figure out the answer:
=iif(ReportItems("desc").Value="Sent Census","Solid","None")
You reference the textbox, not the data. doh.
"Sharon" wrote:
> I have a matrix and want to put a border on only one column. I have
> this expression in the right and left borderstyle property:
> =iif(First(Fields!desc.Value)="Sent Census","Solid","None")
> So if the value column = "Sent Census" then I want the column to have a
> left and right border. My problem is that if the data cell has a 0 in it, the
> border doesn't appear. I know why, I'm just looking for a work around to
> have the whole column bordered even if a 0 is placed in the data cell.
> Thanks!
>

No comments:

Post a Comment