question

TomStone-8590 avatar image
0 Votes"
TomStone-8590 asked TomStone-8590 answered

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomStone-8590 avatar image
0 Votes"
TomStone-8590 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @TomStone-8590 ,
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.


01.jpg (18.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.