Showing and Hiding Elements in SSRS Export

Question

SQL Server

Good afternoon, when exporting a report from the reporting service to xlsx, it became necessary to additionally (!) display a sheet with subtotals, which should not be available when exporting to other formats. Is there any built-in mechanism to implement this?

Answer 1

This subtotal "Row visibility", "Show or hide depending on expression" has: = ( Globals!RenderFormat.Name <> "EXCELOPENXML" ).