Descending: Boolean;
The Descending property determines whether descending sorting is to be executed.
Sub Main;
Var
MB: IMetabase;
MObj: IMetabaseObject;
Report: IPrxReport;
DIs: IPrxDataIslands;
DI: IPrxDataIsland;
DimModel: IDimensionModel;
Prop: IPrxDataIslandProperties;
PropDim: IPrxDataIslandDimension;
Sort: IPrxDataIslandDimensionSort;
Begin
MB := MetabaseClass.Active;
MObj := MB.ItemById("Report").Edit;
Report := MObj As IPrxReport;
DIs := Report.DataIslands;
DI := DIs.Item(0).Edit;
DimModel := DI.Slice.TopHeader.Item(0).Dimension.Dimension;
Prop := DI.Properties;
PropDim := Prop.Dimension(DimModel);
Sort := PropDim.Sort;
Sort.Enabled := True;
Sort.Descending := True;
DI.Save;
MObj.Save;
End Sub Main;
After executing the example descending sorting by the first dimension located in columns is enabled. The identifier of the regular report - Report.
See also: