menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class TableBuilder - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Class TableBuilder

    Represents the table builder class used to generate pivot engine either from cell set or relational data.

    Inheritance
    System.Object
    TableBuilder
    Namespace: Syncfusion.Olap.UWP.Engine
    Assembly: Syncfusion.Olap.UWP.dll
    Syntax
    public class TableBuilder : Object

    Constructors

    TableBuilder()

    Declaration
    public TableBuilder()

    Methods

    BuildEngineFromCellSet(CellSet, Member, SummaryLayout, GridLayout, Boolean, Boolean)

    Builds the pivot engine from the cell set.

    Declaration
    public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, Member expandedCell, SummaryLayout summaryLayout, GridLayout gridLayout, bool IncludeCellCaption, bool IsMdx)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Member expandedCell

    The expanded cell.

    SummaryLayout summaryLayout

    The summary layout.

    GridLayout gridLayout

    The grid layout.

    System.Boolean IncludeCellCaption

    Indicates whether to include cell caption.

    System.Boolean IsMdx

    Indicates whether it is MDX query.

    Returns
    Type Description
    PivotEngine

    The pivot engine.

    BuildEngineFromCellSet(CellSet, Member, SummaryLayout, GridLayout, Boolean, Boolean, Object)

    Builds the pivot engine from the cell set.

    Declaration
    public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, Member expandedCell, SummaryLayout summaryLayout, GridLayout gridLayout, bool IncludeCellCaption, bool IsMdx, object dataManager)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Member expandedCell

    The expanded cell.

    SummaryLayout summaryLayout

    The summary layout.

    GridLayout gridLayout

    The grid layout.

    System.Boolean IncludeCellCaption

    Indicates whether to include cell caption.

    System.Boolean IsMdx

    Indicates whether it is MDX query.

    System.Object dataManager

    The data manager.

    Returns
    Type Description
    PivotEngine

    The pivot engine.

    BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout)

    Builds the engine from cell setfor excel layout.

    Declaration
    public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Member expandedCell

    The expanded cell.

    System.Boolean isMdx

    if set to true [is MDX].

    GridLayout layout

    The layout.

    Returns
    Type
    PivotEngine

    BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout, Boolean)

    Builds the engine from cell setfor excel layout.

    Declaration
    public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout, bool showLevelTypeAll)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Member expandedCell

    The expanded cell.

    System.Boolean isMdx

    if set to true [is MDX].

    GridLayout layout

    The layout.

    System.Boolean showLevelTypeAll

    if set to true [show level type all].

    Returns
    Type
    PivotEngine

    BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout, Boolean, Object)

    Builds the engine from cell setfor excel layout.

    Declaration
    public static PivotEngine BuildEngineFromCellSetforExcelLayout(CellSet cellSet, Member expandedCell, bool isMdx, GridLayout layout, bool showLevelTypeAll, object dataManager)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Member expandedCell

    The expanded cell.

    System.Boolean isMdx

    if set to true [is MDX].

    GridLayout layout

    The layout.

    System.Boolean showLevelTypeAll

    if set to true [show level type all].

    System.Object dataManager

    The data manager.

    Returns
    Type
    PivotEngine

    BuildEngineFromIQueryable(IQueryable, OlapReport, SortType, String[], String[], SummaryInfo[], Boolean, GridLayout, Boolean, PivotCellDescriptor, Boolean)

    Builds the engine from IEnumerable source

    Declaration
    public static PivotEngine BuildEngineFromIQueryable(IQueryable queryableSource, OlapReport CurrentReport, SortType sortOrder, string[] columnGroup, string[] rowGroup, SummaryInfo[] summaryInfos, bool isRowSummary, GridLayout layout, bool ExpandAll, PivotCellDescriptor drilledCell, bool drillDown)
    Parameters
    Type Name Description
    System.Linq.IQueryable queryableSource

    The IEnumerable source.

    OlapReport CurrentReport

    The current report.

    SortType sortOrder

    The sort order.

    System.String[] columnGroup

    The column group.

    System.String[] rowGroup

    The row group.

    SummaryInfo[] summaryInfos

    The summary infos.

    System.Boolean isRowSummary

    if set to true [is row summary].

    GridLayout layout

    The layout.

    System.Boolean ExpandAll

    if set to true [expand all].

    PivotCellDescriptor drilledCell

    The drilled cell.

    System.Boolean drillDown

    if set to true [drill down].

    Returns
    Type
    PivotEngine

    BuildTableFromCellSet(CellSet, SummaryLayout, GridLayout, Boolean)

    Builds the pivot engine from the cell set.

    Declaration
    public static PivotEngine BuildTableFromCellSet(CellSet cellSet, SummaryLayout summaryLayout, GridLayout gridLayout, bool IsMDX)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    SummaryLayout summaryLayout

    The summary layout.

    GridLayout gridLayout

    The grid layout.

    System.Boolean IsMDX

    Indicates whether it is MDX query.

    Returns
    Type Description
    PivotEngine

    The pivot engine.

    GetMaxLevel(Axis, Int32)

    Returns the maximum level of the tuple set.

    Declaration
    public static int GetMaxLevel(Axis cubeAxis, int dimension)
    Parameters
    Type Name Description
    Axis cubeAxis

    The cube axis.

    System.Int32 dimension

    The dimension.

    Returns
    Type
    System.Int32

    GetMinLevel(Axis, Int32)

    Returns the minimum level of the tuple set.

    Declaration
    public static int GetMinLevel(Axis cubeAxis, int dimension)
    Parameters
    Type Name Description
    Axis cubeAxis

    The cube axis.

    System.Int32 dimension

    The dimension.

    Returns
    Type
    System.Int32

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved