IPivot.BuildWithEmptyHeader

Syntax

BuildWithEmptyHeader: Boolean;

Description

The BuildWithEmptyHeader property returns whether heading or sidehead are built when selection is empty.

Comments

Available values:

True. Heading or sidehead are built when selection is empty.
False. Default value. Heading or sidehead are not built when selection is empty.

Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier. The express report contains a table, which data source is a cube containing a dictionary with the DIC_RF identifier. This dictionary is set as an express report table sidehead dimension. Heading and sidehead dimension elements are selected.

Add links to the Dimensions, Express, Metabase, Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    Dim: IDimSelectionSet;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
    // Get report data table display settings
    Pivot := Express.Pivot;
    // Set displaying of headers when selection is empty
    Pivot.BuildWithEmptyHeader := True;
    // Get selection of express report data source dimensions
    Dim := Pivot.Selection;
    // Remove sidehead dimension selection
    Dim.RemoveById("DIC_RF");
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, sidehead dimension selection is removed in the express report table, heading headers are displayed, the Always Show Headers checkbox is selected.