Transposed: Boolean;
The Transposed property determines whether the table is transposed.
Available values:
True - the table is transposed, that is, rows were turned to columns and columns were turned to rows.
False - the table is not transposed.
Selected table elements and collections of dimensions located by rows (IPivot.LeftHeader) and by columns (IPivot.TopHeader) will also be transposed.
NOTE. Transposition of dimension collections arranged in rows and columns is not available for the row mode of the time series database, represented in the Analytical Queries (OLAP) tool.
Executing the example requires a form with a button on it named Button1, the TabSheetBox component and the UiErAnalyzer component named UiErAnalyzer1, which is used as a data source.
Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
Analyzer: IEaxAnalyzer;
Grid: IEaxGrid;
Begin
Analyzer := UiErAnalyzer1.ErAnalyzer;
Grid := Analyzer.Grid;
Grid.AdjustMode := EaxAdjustMode.ColumnsThenRows;
Grid.Transposed := True;
End Sub Button1OnClick;
After executing the example the table and element selection in the table are transposed. See below example of a table before (upper image) and after (lower image) transposition:
See also: