I have one table in a report and I'm attempting to put a top border on one cell based on the data in another cell in the same row. For example cell A has "Highlight" as a value, and I'm putting a top border on cell B in the same row. I have
an expression for the BorderStyle in cell B: =iif(Fields!CellA.Value="HIGHLIGHT","Solid","None") and the borderWidth default is set to 1pt. What's happening is some records have the top border and some don't, and it seems completely random.
When I change the BorderWidth property from 1 to 3 then I get the top border on every record is supposed to be, but the width varies from 1pt to 3pt randomly on each record. If I scrap the BorderStyle expression all together and set the BorderWidth
to 1pt then I get a 1pt top border on each record, so it seems to have something to do with my expression, but I haven't been able to figure it out.
Running SSRS 2005
View Complete Post