• In Reporting Services, when you preview the report, the report itself is already completely processed. So when we export/print the report after preview, it's not possible to make anything "dynamic" because the view of the report is done. For your requirement, the best work around is add a parameter in your report, then control the visibility of chart and table based on the parameter selection.

    Please refer to:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d67280f3-451e-4ce0-a735-98a13a5b42f6/hide-table-based-on-report-parameters?forum=sqlreportingservices