How to show/hide sheets in Microsoft Excel reports conditionally

Modified on Thu, 19 Dec at 2:26 PM

FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho

It is possible to show/hide sheets in Microsoft Excel reports using the Condition property of Elements together with the Exception Behavior.

Follow the example to hide Sheets if the CY Sales = 0 and LY Sales = 0, that is, show only Sheets that contain tables that make sense to show.

Add a condition to the Table element:

[Datasource].[Executive Dashboard - Partners Workshop].[Expression].[ [CY Sales]>0 or [LY Sales]>0 ]

And set the Exception behavior to Exclude Worksheet.

For more information, see Mail & Deploy Advanced - Conditions are Everywhere in Mail & Deploy.

Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.