IPivot.BuildWithEmptyHeader

Syntax

BuildWithEmptyHeader: Boolean;

BuildWithEmptyHeader: boolean;

Description

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

Comments

Available values:

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;

Imports Prognoz.Platform.Interop.Dimensions;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Pivot;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    Dim: IDimSelectionSet;
Begin
    
// Get repository
    MB := Params.Metabase;
    
// 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;

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.

See also:

IPivot