IsStairCell(Row: Integer; Column: Integer): Boolean;
The IsStairCell property returns whether stairs hierarchy is used in a cell.
Row. Cell row index.
Column. Cell column index.
The property returns True if a cell is a hierarchy step.
Executing the example requires an express report with the EXPRESS identifier. In the report, on the Layout sidehead tab, the use of stairs hierarchy for titles should be enabled (see Use Stairs Hierarchy or StairsHierarchy). At least two dimensions should be present in the sidehead.
Add links to the Pivot, Express, and Metabase system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Pivot: IPivot;
Table: IPivotTable;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get express report
Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
// Get display settings for report data table
Pivot := Express.Pivot;
// Get table properties
Table := Pivot.ObtainTable;
// Check if cell is a hierarchy step
If Table.IsStairCell(0, 0) Then
Debug.WriteLine("Table cell is a hierarchy step");
Else
Debug.WriteLine("Table cell is not a hierarchy step");
End If;
End Sub UserProc;
After executing the example it is checked if the cell is a hierarchy step, and the console displays the appropriate message.
See also: