IPrxTableIslandGrouping.Format

Syntax

Format: IPrxTableIslandFormat;

Description

The Format property determines formatting parameters for a relational data area group.

Example

The following example assumes that there is the Report object with the IPrxReport type.

Sub User;

Var

Report : IPrxReport;

TabIs : IPrxTableIslands;

TI : IPrxTableIsland;

Grs : IPrxTableIslandGroupings;

Gr : IPrxTableIslandGrouping;

LayFormat : IPrxTableIslandFormat;

Format : IPrxFormatConditions;

TabFormat : ITabFormatCondition;

ValFormat : ITabFormatValues;

Begin

TabIs := Report.TableIslands;

TI := TabIs.Item(0);

TI := TI.Edit;

Grs := TI.Groupings;

Gr := Grs.Item(0);

LayFormat := Gr.Format;

Format := LayFormat.Conditions;

TabFormat := Format.Add;

TabFormat.Type := TabConditionType.Values;

ValFormat := TabFormat.Details As ITabFormatValues;

//two color gradient for cell formatting

ValFormat.Style := TabFormatValuesStyle.TwoColorScale;

//setting minimum value

ValFormat.MinValueType := TabFormatValueType.Lowest;

ValFormat.MinValueColor := GxColor.FromName("Red");

//setting maximum value

ValFormat.MaxValueType := TabFormatValueType.Highest;

ValFormat.MaxValueColor := GxColor.FromName("Blue");

TI.Save;

End Sub User;

After executing the example the following conditional formatting is set for the relational area group: style - two color gradient.

See also:

IPrxTableIslandGrouping