Sets hierarchy options for the selected item in the Design Layout window in Excel.
The list of attributes on this tab is controlled by the values set in the Attributes used for grouping grid on the Group tab of the Item Properties dialog box. If the Group tab is disabled, the Hierarchy tab is disabled also. You can enable both tabs by checking the Use Grouping box on the Group tab.
Enables the controls on this tab.
Lists all of the report attributes from the Group tab.
Specifies the hierarchy level for the attribute. The hierarchy levels are all set initially to Default.
Create a new sheet every time a Level 1 property value changes
Specifies that a new sheet is created in Excel whenever a Level 1 value is changed in the hierarchy.