LAYOUT

Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. Let's take a look at the various options.

NAME	DESCRIPTION
LAYOUT.HIERARCHY	Sets the layout to hierarchy
LAYOUT.OUTLINE	Sets the layout to outline
LAYOUT.TABLE	Sets the layout to table
LAYOUT.STEPPED	Sets the layout to stepped
LAYOUT.DRILLDOWN	Sets the layout to drilldown
LAYOUT.LIGHTTHEME	Applies a light canvas
LAYOUT.DARKTHEME	Applies a dark canvas
LAYOUT.AUTOFIT	Fits the maximum possible data in the available space
LAYOUT.SETRULER	Enable or disable the ruler
LAYOUT.GOTOCOLUMNLEVEL	Expands the column hierarchy to the specified level
LAYOUT.GOTOROWLEVEL	Expands the row hierarchy to the specified level

1. LAYOUT.HIERARCHICAL

Sets the layout option to hierarchy and displays the data in a hierarchical format.

Syntax

LAYOUT.HIERARCHICAL

Layout hierarchical

2. LAYOUT.OUTLINE

Sets the layout option to outline.

Syntax

LAYOUT.OUTLINE

Setting the layout to outline

3. LAYOUT.TABLE

Sets the layout option to table.

Syntax

LAYOUT.TABLE

Setting the layout to table

4. LAYOUT.STEPPED

Sets the layout option to stepped.

Syntax

LAYOUT.STEPPED

Setting the layout to stepped

5. LAYOUT.DRILLDOWN

Sets the layout option to drilldown.

Syntax

LAYOUT.DRILLDOWN

Setting the layout to drilldown

6. LAYOUT.LIGHTTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.LIGHTTHEME

Setting a light canvas

7. LAYOUT.DARKTHEME

Sets a light background for the canvas.

Syntax

LAYOUT.DARKTHEME

Setting a dark background

8. LAYOUT.AUTOFIT

Fits the maximum possible data in the available space.

Syntax

LAYOUT.AUTOFIT

Autofit layout

9. LAYOUT.SETRULER

Fits the maximum possible data in the available space.

Syntax

LAYOUT.SETRULER(TRUE) #Enables the ruler
LAYOUT.SETRULER(FALSE) #Disables the ruler
LAYOUT.SETRULER(THIS) #Control the 'THIS' parameter using a toggle variable button

Ruler enabled using set ruler

10. LAYOUT.GOTOCOLUMNLEVEL

Expands the column hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOCOLUMNLEVEL(1) #Expands to the second level of the column hierarchy
LAYOUT.GOTOCOLUMNLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable

Expanding the column hierarchy

11. LAYOUT.GOTOROWLEVEL

Expands the row hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'.

Syntax

LAYOUT.GOTOROWLEVEL(2) #Expands to the third level of the column hierarchy
LAYOUT.GOTOROWLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable

Expanded row hierarchy