IPrxTableIslandGroupingTotals.Caption

Syntax

Description

The Caption property determines a totals title.

Comments

To determine formatting of totals, use the IPrxTableIslandGroupingTotals.Style property.

Example

Executing the example requires that the repository contains a regular report with the Report identifier, which sheet contains a relational data area.

Add links to the Metabase, Report, Tab, Matrix and Drawing system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    Report: IPrxReport;
    TabIs: IPrxTableIslands;
    TI: IPrxTableIsland;
    Grs: IPrxTableIslandGroupings;
    Gr: IPrxTableIslandGrouping;
    GrT: IPrxTableIslandGroupingTotals;
    Style: IPrxCellStyle;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("Report").Edit;
    Report := MObj As IPrxReport;
    TabIs := Report.TableIslands;
    TI := TabIs.Item(0);
    TI := Ti.Edit;
    Grs := TI.Groupings;
    Gr := Grs.Item(0);
    GrT := Gr.Totals;
    GrT.Caption.AsString := "VALUE";
    GrT.Method(TI.Layout.Rows(0).Cells(0)).Method := BasicAggregatorOperation.Sum;
    Style := GrT.Style;
    Style.BackgroundColor := New GxColor.CreateRGB(0, 0, 250);
    Style.Font.Bold := TriState.OnOption;
    TI.Save;
    MObj.Save;
End Sub UserProc;

After executing the example parameters of totals are set up.