IPivot.EndUpdateEx

Syntax

EndUpdateEx(Recalc: Boolean);

Parameters

Recalc. Indicates whether table data should be recalculated taking into account made changes.

Description

The EndUpdateEx method resumes table rerendering with advanced settings.

Comments

Available values of the Recalc parameter:

True. Table data is recalculated taking into account made changes.
False. Table data is not recalculated taking into account made changes.

The method resumes table rerendering after the IPivot.BeginUpdate method paused it. When the method is used, all changes made in the table between calls of the IPivot.BeginUpdate and IPivot.EndUpdateEx methods will be applied.

Example

To execute the example, place on the form the Button component named Button1, the TabSheetBox component named TabSheetBox1, and the UiErAnalyzer component named UiErAnalyzer1. Specify UiErAnalyzer1 as a data source for TabSheetBox1. An express report is a data source for UiErAnalyzer1.

Add links to the Express, Forms, ExtCtrls, Forms, Pivot, and Tab system assemblies.

The example is a handler of the OnClick event for the Button1 component.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    OLAP: IEaxAnalyzer;
    Pivot: IPivot;
    Sorter: IPivotSorter;
    SortItem: IPivotSortItem;
Begin
    OLAP := UiErAnalyzer1.ErAnalyzer;
    Pivot := OLAP.Pivot;
    // Disable table rerendering
    Pivot.BeginUpdate;
    // Set sorting parameters
    Sorter := Pivot.Sorter;
    SortItem := Sorter.Add;
    SortItem.Kind := PivotSortKind.Column;
    SortItem.IndexInHeader := 0;
    SortItem.Direction := PivotSortDirection.Asc;
    Pivot.SortDiapason := PivotSortDiapason.Level;
    // Resume table rerendering with advanced settings
    Pivot.EndUpdateEx(True);
End Sub Button1OnClick;

Clicking the button recalculates table data with ascending sorting in the first column.