0

My SSRS report has multiple Tablix elements. Their visibility is conditional to the content of the datasets they use. It works as intended when first displayed. When the dataset is empty, the Tablix is hidden. It's done by using "Show or hide based on an expression" option on the properties of the Tablix. One of the Tablix elements is setup with a Group where the Detail is only visible when the a group field is toggled, which works as a "collapse" or "drill down. Example As soon as the the group is toggled, the screen refreshes (not the report) and all previously hidden Tablix elements incorrectly appear (empty).

I have tried in different browsers (chrome, edge, explorer) and they all do the same.

2
  • What is your expression in the "Show or hide" property of the tablix? I am able to reproduce this behavior with some expressions but not others, so it seems to have something to do with that expression. For example, if I do =IsNothing(Fields!ID.Value), I get the behavior you are experiencing where the empty tablix is initially hidden but then appears when I interact with the other tablix. If I instead do =Count(Fields!ID.Value) < 1, I get the intended/correct behavior. I'd try refactoring that expression if possible and see if that works.
    – C Black
    Commented Mar 2, 2023 at 16:27
  • I was using "IsNothing". I just now changed to the alternative you mentioned above and it worked. Very peculiar... Thank you!
    – ETS333
    Commented Mar 2, 2023 at 22:37

0