Hide a tab based on a condition

[#1]

I have a report with 8 tabs on it, the data is very large and a few of the tables run out of allocated memory unless you filter prior to going into the report, the problem is if you forget to filter it gives an error how can i hide this tab until a filter on another report is selected? I dont really want to add a button to open this report as they wont do it and it is a very important report I just dont wont it to initially display when you open the application.

[Miguel_Angel_Baeyens]

Hello,

You can set the chart and the tab, but set a condition to calculate, under properties of chart, General like

Len(GetCurrentSelections()) = 0

Unless they have some dimension selected, they will get an error you can customize in the same tab clicking on "Error messages".

[#3]

The Tab is a property of the Sheet. If you change the Show condition on the sheet, the tab will be shown or not shown with it.

1. Right Click on the Tab
2. Click on "Sheet Properties"
3. On the General tab of the Sheet Properties dialog, there is a Show Sheet box. Put a dot in "Conditional"
4. Create an expression that determines when the Sheet (Tab) should be shown

That's all there is to it 🙂