WPF

Upgrade Guide User Guide Demos Support Forums Download
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class TableBuilder - WPF 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
    Inherited Members
    System.Object.ToString()
    System.Object.Equals(System.Object)
    System.Object.Equals(System.Object, System.Object)
    System.Object.ReferenceEquals(System.Object, System.Object)
    System.Object.GetHashCode()
    System.Object.GetType()
    System.Object.MemberwiseClone()
    Namespace: Syncfusion.Olap.Engine
    Assembly: Syncfusion.Olap.Base.dll
    Syntax
    public class TableBuilder

    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.

    BuildEngineFromCellSet(CellSet, IDataProvider)

    Builds the pivot engine from the cell set.

    Declaration
    public static PivotEngine BuildEngineFromCellSet(CellSet cellSet, IDataProvider dataProvider)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    IDataProvider dataProvider

    The data provider.

    Returns
    Type Description
    PivotEngine

    BuildEngineFromCellSetforExcelLayout(CellSet, Member, Boolean, GridLayout)

    Builds the engine from cell set for 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 Description
    PivotEngine

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

    Builds the engine from cell set for 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 Description
    PivotEngine

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

    Builds the engine from cell set for 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 Description
    PivotEngine

    BuildEngineFromIListSource(IListSource, OlapReport, SortType, String[], String[], SummaryInfo[], Boolean, GridLayout, Boolean, Int32, PivotCellDescriptor, Boolean)

    Pivot Engine Generation for Ilistsource.

    Declaration
    public static PivotEngine BuildEngineFromIListSource(IListSource listSource, OlapReport CurrentReport, SortType sortOrder, string[] columnGroup, string[] rowGroup, SummaryInfo[] summaryInfos, bool isRowSummary, GridLayout layout, bool ExpandAll, int summaryStringCount, PivotCellDescriptor drilledCell, bool drillDown)
    Parameters
    Type Name Description
    System.ComponentModel.IListSource listSource

    The list 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].

    System.Int32 summaryStringCount

    The summary string count.

    PivotCellDescriptor drilledCell

    The drilled cell.

    System.Boolean drillDown

    if set to true [drill down].

    Returns
    Type Description
    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 Description
    PivotEngine

    BuildEngineTableFromCellSet(CellSet)

    Builds the pivot engine from the specified cell set.

    Declaration
    public static PivotEngine BuildEngineTableFromCellSet(CellSet cellSet)
    Parameters
    Type Name Description
    CellSet cellSet

    The cell set.

    Returns
    Type Description
    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 Description
    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 Description
    System.Int32
    Back to top Generated by DocFX
    Copyright © 2001 - 2021 Syncfusion Inc. All Rights Reserved