SSRS Hidden Expression in a Tablix throws an error but Tablix does not have a hidden expression configured

Question

I have a report that is throwing the following error:

    Error   2   [rsRuntimeErrorInExpression] The Hidden expression for the tablix ‘Tablix27’ 
    contains an error: 
    The query returned no rows for the dataset. The expression therefore 
    evaluates to null.      

Tablix 27 has Visibility set to show so there's no hide expression. Any idea on how to get rid of the error or any pointers that can lead me in the right direction?

what could be causing the problem?

Answer 1

I have a feeling that you may need to check the settings in the Visibility tab of the Properties dialog box - it is confusing because there are two places that visibility can be set in. You may be looking at this location:

But try going here instead by right clicking on the upper left hand corner of your tablix:

Click on Tablix Properties, then take a look at the Visibility tab and see if there is anything entered in the expressions box:

EDIT: I can't actually replicate your problem, so I'm afraid my ability to help further won't be great. My only other advice is to make sure you are looking at the correct tablix and to try copy and pasting the tablix, then deleting the original.