sql server reporting services: When I write an expression for the visability of a cell, I am finding that
the border disappears when Hide = True. I don't really want the cell to
disappear, just the text contained within it. And I want the border to always
show up.

Any ideas how I can make this happen?

Thanks,

I can think of two solutions;

It is probably easier to put the test on the contents, so in the value
property use a test something like this;
=IIf(Parameters!HideValues.Value, "", Fields!MyField.Value)
If you want to hide background colours too, use this method in the
backgroundcolor property. In fact use this method almost anywhere, I
use it heavily.

This next one is a bit of hack I'm afraid. Create a rectangle object
outside the table, inside the rectangle place a textbox. Rename it to
something more recognisable. Now cut and paste the rectangle into the
cell in the table you want. Now you can hide just the textbox inside
the rectangle without affecting the cell itself.

Chris


[quoted text, click to view]