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

Found the answer, so I thought I'd post if anyone else came across the same problem.

The query that populated the Tablix was returning null and because of this the error was being thrown. I was able to handle the error by right clicking on the Tablix affected and going to its Tablix Properties and then adding the following expression under the hide field: =CountRows("MyDatasetNameHere") < 1

This evaluates to true which in turn hides the Tablix and the error is no longer thrown.