Search code examples
reporting-servicesssrs-2012ssrs-tablix

Disabled footer SSRS with No Row Message


I am working on a SSRS report where I am displaying a NO Row message on a Tablix but I can still see the footer of this report.

Please let me know if there is any way to hide the report footer when there is no rows in the dataset for a given condition.

Thanks

Yogesh


Solution

    • Aside from changing all the fields to blank in the footer when your dataset returns empty.
    • Another way is to use Visibility. Hide all the fields in the footer when the dataset returns empty.

    I can only think of these solutions from now based from your scenario.