IPrxDataIslandHeaderFilter.Condition

Syntax

Condition: IExpression;

Description

The Condition property returns an object containing filtering condition.

Example

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Report: IPrxReport;

DIs: IPrxDataIslands;

DI: IPrxDataIsland;

Prop: IPrxDataIslandProperties;

THead: IPrxDataIslandHeader;

Filter: IPrxDataIslandHeaderFilter;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("Report").Edit;

Report := MObj As IPrxReport;

DIs := Report.DataIslands;

DI := DIs.Item(0).Edit;

Prop := DI.Properties;

THead := Prop.TopHeader;

Filter := THead.Filter;

Filter.UseCondition := True;

Filter.Condition.AsString := "VALUE<100"

DI.Save;

MObj.Save;

End Sub Main;

After executing the example the Condition Filtering option is enabled, and a filtering condition is set for columns of the first data area of the regular report. The identifier of the regular report - Report.