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

Tom Stone 521 Reputation points
2021-09-20T19:32:07.96+00:00

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.
133630-ssrs-tablix-cell-hiding-issue.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tom Stone 521 Reputation points
    2021-09-21T12:32:49.303+00:00

    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")

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-09-21T03:04:30.407+00:00

    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:
    133688-01.jpg
    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.

    0 comments No comments