SSRS how can I hide a tablix cell value without affecting the background

Question

SSRS: How can I hide a tablix cell value without affecting the background and the borders?
Notice in the image how when the tablix cell is conditionally hidden
that the background color and left border disappears.

Answer 1

I found a solution … to set the font color to the same color
as the background color instead of using the visibility attribute of the cell. This way the value is displayed but since it is the same color as the background color the value cannot be seen.

=iif(Fields!ColumnA.Value="XYZ","Silver","Black")

Answer 2

Hi @Tom Stone ,
The hiding conditions you set for the report items are set in the Text Box Properties, so you hide all the text boxes that meet the conditions, not just the data.
You can create Tablix in the rectangle, set the rectangle background to the color you need, and hide the report items on this basis. As shown below:

Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.