SeparateHeaders: Boolean;
The SeparateHeaders property determines whether filtering settings are used separately for rows and columns.
Available values:
True. Filtering settings are used separately for rows and columns.
False. Default value. Filtering settings are used for the entire table.
Executing the example requires that the repository contains an express report with the EXPRESS_FILTER identifier. The report contains a table.
Add links to the Express, Metabase and Pivot system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Pivot: IPivot;
LeftHeader: IPivotHeader;
LeftFilter: IPivotHeaderFilterSettings;
TopHeader: IPivotHeader;
TopFilter: IPivotHeaderFilterSettings;
Filter: IPivotFilter;
Begin
MB := MetabaseClass.Active;
Express := MB.ItemById("EXPRESS_FILTER").Edit As IEaxAnalyzer;
Pivot := Express.Pivot;
//Filtering parameters in table
Filter := Pivot.Filter;
Filter.SeparateHeaders := True;
// Dimensions located by rows
LeftHeader := Pivot.LeftHeader;
LeftFilter := LeftHeader.Settings.Filter;
LeftFilter.Enabled := True;
LeftFilter.SuppressZeros := True;
// Dimensions located by columns
TopHeader := Pivot.TopHeader;
TopFilter := TopHeader.Settings.Filter;
LeftFilter.Enabled := True;
TopFilter.SuppressEmpty := True;
// Save changes
(Express As IMetabaseObject).Save;
End Sub UserProc;
After executing the example the rows, containing cells with zero values and columns containing cells with empty values, are filtered.
See also: