menu

ASP.NET Web Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class PivotGrid

    Show / Hide Table of Contents

    Class PivotGrid

    Inheritance
    System.Object
    EssentialJavaScript
    Control
    PivotGrid
    Implements
    System.Web.IHtmlString
    Inherited Members
    Control.ServerProperties
    Control.GetTag(String)
    Control.Render()
    Control.Serialize(Object)
    Control.RenderJson()
    Control.BuildScriptContent(String)
    Control.RemoveScriptContent(String)
    Control.InitializeScript()
    Control.CreateUnObtrusiveContainer(String)
    Control.CreateUnObtrusiveDataAttributes(Object, String, String)
    Control.CreateUnObtrusiveDataAttributesFor(Object, String, String)
    Control.CreateUnObtrusiveDataDictionary(Object, String, String)
    Control.CreateDataVariable(Object, String, Object)
    Control.CreateDataVariable(IDictionary<String, Object>)
    Control.Raw()
    Control.ToHtmlString()
    Control.SetHtmlAttributes(StringBuilder, IDictionary<String, Object>)
    Control.SetHtmlAttributes(HtmlTag, IDictionary<String, Object>)
    Control.SetHtmlAttributes(Object)
    Control.ID
    Control.ClientID
    Control.UniqueID
    Control.Parent
    Control.ControlType
    Control.ServerEvents
    Control.Output
    Control.Data
    Control.UnobtrusiveData
    EssentialJavaScript.MetadataProvider
    EssentialJavaScript.DataManager(String)
    EssentialJavaScript.DataManager(String, DataSource)
    EssentialJavaScript.Scroller(String)
    EssentialJavaScript.Scroller(String, ScrollerProperties)
    EssentialJavaScript.ScriptManager(Boolean)
    EssentialJavaScript.ScriptManager()
    EssentialJavaScript.Olap()
    EssentialJavaScript.Pivot()
    EssentialJavaScript.SetContext(HttpContextBase)
    EssentialJavaScript.Barcode(String)
    EssentialJavaScript.Barcode(String, BarcodeProperties)
    EssentialJavaScript.Sparkline(String)
    EssentialJavaScript.Sparkline(String, SparklineProeprties)
    EssentialJavaScript.SunburstChart(String)
    EssentialJavaScript.SunburstChart(String, SunburstProperties)
    EssentialJavaScript.BulletGraph(String)
    EssentialJavaScript.BulletGraph(String, BulletGraphProperties)
    EssentialJavaScript.Chart(String)
    EssentialJavaScript.Chart(String, ChartProperties)
    EssentialJavaScript.CircularGauge(String)
    EssentialJavaScript.CircularGauge(String, CircularGaugeProperties)
    EssentialJavaScript.Diagram(String)
    EssentialJavaScript.Diagram(String, DiagramProperties)
    EssentialJavaScript.SymbolPalette(String)
    EssentialJavaScript.SymbolPalette(String, SymbolPaletteProperties)
    EssentialJavaScript.Overview(String)
    EssentialJavaScript.Overview(String, OverviewProperties)
    EssentialJavaScript.DigitalGauge(String)
    EssentialJavaScript.DigitalGauge(String, DigitalGaugeProperties)
    EssentialJavaScript.LinearGauge(String)
    EssentialJavaScript.LinearGauge(String, LinearGaugeProperties)
    EssentialJavaScript.Map(String)
    EssentialJavaScript.Map(String, MapProperties)
    EssentialJavaScript.RangeNavigator(String)
    EssentialJavaScript.RangeNavigator(String, RangeNavigatorProperties)
    EssentialJavaScript.TreeMap(String)
    EssentialJavaScript.TreeMap(String, Double, Double)
    EssentialJavaScript.TreeMap(String, TreeMapProperties, Double, Double)
    EssentialJavaScript.TreeMap(String, TreeMapProperties)
    EssentialJavaScript.DateRangePicker(String)
    EssentialJavaScript.DateRangePicker(String, DateRangePickerProperties)
    EssentialJavaScript.ComboBox(String)
    EssentialJavaScript.ComboBox(String, ComboBoxProperties)
    EssentialJavaScript.HeatMapLegend(String)
    EssentialJavaScript.HeatMapLegend(String, HeatMapLegendProperties)
    EssentialJavaScript.Kanban(String)
    EssentialJavaScript.Kanban(String, KanbanProperties)
    EssentialJavaScript.Pager(String)
    EssentialJavaScript.Pager(String, PagerProperties)
    EssentialJavaScript.PdfViewer(String)
    EssentialJavaScript.PdfViewer(String, PdfViewerProperties)
    EssentialJavaScript.RadialMenu(String)
    EssentialJavaScript.RadialMenu(String, RadialMenuProperties)
    EssentialJavaScript.RadialSlider(String)
    EssentialJavaScript.RadialSlider(String, RadialSliderProperties)
    EssentialJavaScript.HeatMap(String)
    EssentialJavaScript.HeatMap(String, HeatMapProperties)
    EssentialJavaScript.RecurrenceEditor(String)
    EssentialJavaScript.RecurrenceEditor(String, RecurrenceEditorProperties)
    EssentialJavaScript.ListBox(String)
    EssentialJavaScript.ListBox(String, ListBoxProperties)
    EssentialJavaScript.ListView(String)
    EssentialJavaScript.ListView(String, ListViewProperties)
    EssentialJavaScript.ReportViewer(String)
    EssentialJavaScript.ReportViewer(String, ReportViewerProperties)
    EssentialJavaScript.Accordion(String)
    EssentialJavaScript.Accordion(String, AccordionProperties)
    EssentialJavaScript.Autocomplete(String)
    EssentialJavaScript.Autocomplete(String, AutocompleteProperties)
    EssentialJavaScript.Button(String)
    EssentialJavaScript.Button(String, ButtonProperties)
    EssentialJavaScript.Captcha(String)
    EssentialJavaScript.Captcha(String, CaptchaProperties)
    EssentialJavaScript.CheckBox(String)
    EssentialJavaScript.CheckBox(String, CheckBoxProperties)
    EssentialJavaScript.ColorPicker(String)
    EssentialJavaScript.ColorPicker(String, ColorPickerProperties)
    EssentialJavaScript.DatePicker(String)
    EssentialJavaScript.DatePicker(String, DatePickerProperties)
    EssentialJavaScript.DateTimePicker(String)
    EssentialJavaScript.DateTimePicker(String, DateTimePickerProperties)
    EssentialJavaScript.Dialog(String)
    EssentialJavaScript.Dialog(String, DialogProperties)
    EssentialJavaScript.DropDownList(String)
    EssentialJavaScript.DropDownList(String, DropDownListProperties)
    EssentialJavaScript.NumericTextbox(String)
    EssentialJavaScript.NumericTextbox(String, EditorProperties)
    EssentialJavaScript.PercentageTextbox(String)
    EssentialJavaScript.PercentageTextbox(String, EditorProperties)
    EssentialJavaScript.CurrencyTextbox(String)
    EssentialJavaScript.CurrencyTextbox(String, EditorProperties)
    EssentialJavaScript.FileExplorer(String)
    EssentialJavaScript.FileExplorer(String, FileExplorerProperties)
    EssentialJavaScript.Gantt(String)
    EssentialJavaScript.Gantt(String, GanttProperties)
    EssentialJavaScript.Grid<T>(String)
    EssentialJavaScript.Grid<T>(String, GridProperties)
    EssentialJavaScript.GroupButton(String)
    EssentialJavaScript.GroupButton(String, GroupButtonProperties)
    EssentialJavaScript.MaskEdit(String)
    EssentialJavaScript.MaskEdit(String, MaskEditProperties)
    EssentialJavaScript.Menu(String)
    EssentialJavaScript.Menu(String, MenuProperties)
    EssentialJavaScript.NavigationDrawer(String)
    EssentialJavaScript.NavigationDrawer(String, NavigationDrawerProperties)
    EssentialJavaScript.ProgressBar(String)
    EssentialJavaScript.ProgressBar(String, ProgressBarProperties)
    EssentialJavaScript.RadioButton(String)
    EssentialJavaScript.RadioButton(String, RadioButtonProperties)
    EssentialJavaScript.Rating(String)
    EssentialJavaScript.Rating(String, RatingProperties)
    EssentialJavaScript.Ribbon(String)
    EssentialJavaScript.Ribbon(String, RibbonProperties)
    EssentialJavaScript.Rotator(String)
    EssentialJavaScript.Rotator(String, RotatorProperties)
    EssentialJavaScript.RTE(String)
    EssentialJavaScript.RTE(String, RTEproperties)
    EssentialJavaScript.Schedule(String)
    EssentialJavaScript.Schedule(String, ScheduleProperties)
    EssentialJavaScript.Signature(String)
    EssentialJavaScript.Signature(String, SignatureProperties)
    EssentialJavaScript.Slider(String)
    EssentialJavaScript.Slider(String, SliderProperties)
    EssentialJavaScript.SpellCheck(String)
    EssentialJavaScript.SpellCheck(String, SpellCheckProperties)
    EssentialJavaScript.SplitButton(String)
    EssentialJavaScript.SplitButton(String, SplitButtonProperties)
    EssentialJavaScript.Splitter(String)
    EssentialJavaScript.Splitter(String, SplitterProperties)
    EssentialJavaScript.Spreadsheet<T>(String)
    EssentialJavaScript.Spreadsheet<T>(String, WorkbookProperties)
    EssentialJavaScript.Tab(String)
    EssentialJavaScript.Tab(String, TabProperties)
    EssentialJavaScript.TagCloud(String)
    EssentialJavaScript.TagCloud(String, TagCloudProperties)
    EssentialJavaScript.Tile(String)
    EssentialJavaScript.Tile(String, TileProperties)
    EssentialJavaScript.TimePicker(String)
    EssentialJavaScript.TimePicker(String, TimePickerProperties)
    EssentialJavaScript.ToggleButton(String)
    EssentialJavaScript.ToggleButton(String, ToggleButtonProperties)
    EssentialJavaScript.Toolbar(String)
    EssentialJavaScript.Toolbar(String, ToolbarProperties)
    EssentialJavaScript.Tooltip(String)
    EssentialJavaScript.Tooltip(String, TooltipProperties)
    EssentialJavaScript.TreeGrid(String)
    EssentialJavaScript.TreeGrid(String, TreeGridProperties)
    EssentialJavaScript.TreeView(String)
    EssentialJavaScript.TreeView(String, TreeViewProperties)
    EssentialJavaScript.Uploadbox(String)
    EssentialJavaScript.Uploadbox(String, UploadboxProperties)
    EssentialJavaScript.WaitingPopup(String)
    EssentialJavaScript.WaitingPopup(String, WaitingPopupProperties)
    EssentialJavaScript.ReportDesigner(String)
    EssentialJavaScript.ReportDesigner(String, ReportDesignerProperties)
    EssentialJavaScript.UnObtrusive
    EssentialJavaScript.UnObtrusiveInScriptManager
    EssentialJavaScript.Context
    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.JavaScript
    Assembly: Syncfusion.EJ.Pivot.dll
    Syntax
    public class PivotGrid : Control, IHtmlString

    Constructors

    PivotGrid()

    Declaration
    public PivotGrid()

    PivotGrid(String, PivotGridProperties)

    Declaration
    public PivotGrid(string id, PivotGridProperties propModel)
    Parameters
    Type Name Description
    System.String id
    PivotGridProperties propModel

    Fields

    PivotEngine

    Declaration
    public PivotEngine PivotEngine
    Field Value
    Type Description
    Syncfusion.PivotAnalysis.Base.PivotEngine

    Properties

    Model

    Declaration
    protected override object Model { get; }
    Property Value
    Type Description
    System.Object
    Overrides
    Control.Model

    PivotGridModel

    Declaration
    public PivotGridProperties PivotGridModel { get; set; }
    Property Value
    Type Description
    PivotGridProperties

    PivotReport

    Declaration
    public PivotReport PivotReport { get; set; }
    Property Value
    Type Description
    PivotReport

    PluginName

    Declaration
    public override string PluginName { get; }
    Property Value
    Type Description
    System.String
    Overrides
    Control.PluginName

    TagName

    Declaration
    public override string TagName { get; }
    Property Value
    Type Description
    System.String
    Overrides
    Control.TagName

    Methods

    ApplyValueSorting(Dictionary<String, Object>, String)

    Declaration
    public Dictionary<string, object> ApplyValueSorting(Dictionary<string, object> dict, string sortedHeaders)
    Parameters
    Type Name Description
    System.Collections.Generic.Dictionary<System.String, System.Object> dict
    System.String sortedHeaders
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    CreateContainer(String)

    Declaration
    public override HtmlString CreateContainer(string controlId)
    Parameters
    Type Name Description
    System.String controlId
    Returns
    Type Description
    System.Web.HtmlString
    Overrides
    Control.CreateContainer(String)

    DeserializedReports(String)

    Declaration
    public PivotReport DeserializedReports(string reports)
    Parameters
    Type Name Description
    System.String reports
    Returns
    Type Description
    PivotReport

    DrillthroughDataTable(PivotGridHelper)

    Declaration
    public PivotGridArgs DrillthroughDataTable(PivotGridHelper helper)
    Parameters
    Type Name Description
    PivotGridHelper helper
    Returns
    Type Description
    PivotGridArgs

    DrillthroughDataTable(OlapDataManager, String, String, String)

    Declaration
    public Dictionary<string, object> DrillthroughDataTable(OlapDataManager dataManager, string gridLayout, string cellPosition, string selector)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager dataManager
    System.String gridLayout
    System.String cellPosition
    System.String selector
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    DrillthroughHierarchies(PivotGridHelper)

    Declaration
    public string DrillthroughHierarchies(PivotGridHelper helper)
    Parameters
    Type Name Description
    PivotGridHelper helper
    Returns
    Type Description
    System.String

    DrillthroughHierarchies(OlapDataManager, String, String)

    Declaration
    public string DrillthroughHierarchies(OlapDataManager dataManager, string gridLayout, string cellPosition)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager dataManager
    System.String gridLayout
    System.String cellPosition
    Returns
    Type Description
    System.String

    ExportPivotGrid(OlapDataManager, String, String, HttpResponse)

    Declaration
    public void ExportPivotGrid(OlapDataManager DataManager, string args, string fileName, HttpResponse response)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String args
    System.String fileName
    System.Web.HttpResponse response

    ExportPivotGrid(Object, String, String, HttpResponse)

    Declaration
    public void ExportPivotGrid(object dataSource, string args, string fileName, HttpResponse response)
    Parameters
    Type Name Description
    System.Object dataSource
    System.String args
    System.String fileName
    System.Web.HttpResponse response

    ExportToExcel(OlapDataManager, String, String, HttpResponse)

    Declaration
    public void ExportToExcel(OlapDataManager DataManager, string args, string fileName, HttpResponse response)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String args
    System.String fileName
    System.Web.HttpResponse response

    ExportToExcel(IWorkbook, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToExcel(IWorkbook workbook, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    IWorkbook workbook
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToExcel(String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToExcel(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToPdf(PdfDocument, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToPdf(PdfDocument pdfDoc, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    PdfDocument pdfDoc
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToPdf(String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToPdf(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToWord(WordDocument, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToWord(WordDocument document, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    WordDocument document
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToWord(String, HttpResponse, Color, Color, Color, Color)

    Declaration
    public void ExportToWord(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
    Parameters
    Type Name Description
    System.String fileName
    System.Web.HttpResponse response
    System.Drawing.Color valueCellColor
    System.Drawing.Color valueCellBGColor
    System.Drawing.Color summaryCellColor
    System.Drawing.Color summaryCellBGColor

    ExportToXml(String, String, HttpResponse)

    Declaration
    public void ExportToXml(string clientReport, string fileName, HttpResponse response)
    Parameters
    Type Name Description
    System.String clientReport
    System.String fileName
    System.Web.HttpResponse response

    FindEditorTreeInfo(OlapDataManager, String)

    Declaration
    public List<object> FindEditorTreeInfo(OlapDataManager manager, string dimensionName)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager manager
    System.String dimensionName
    Returns
    Type Description
    System.Collections.Generic.List<System.Object>

    GenerateJSONData(PivotReport, PivotEngine)

    Declaration
    public string GenerateJSONData(PivotReport pivotReport, PivotEngine pivotCellInfos)
    Parameters
    Type Name Description
    PivotReport pivotReport
    Syncfusion.PivotAnalysis.Base.PivotEngine pivotCellInfos
    Returns
    Type Description
    System.String

    GenerateJSONData(OlapDataManager, String)

    Declaration
    public string GenerateJSONData(OlapDataManager DataManager, string gridLayout)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String gridLayout
    Returns
    Type Description
    System.String

    GenerateJSONData(PivotEngine)

    Declaration
    public string GenerateJSONData(PivotEngine pivotCellInfos)
    Parameters
    Type Name Description
    Syncfusion.PivotAnalysis.Base.PivotEngine pivotCellInfos
    Returns
    Type Description
    System.String

    GetDependentControl()

    Declaration
    protected override List<string> GetDependentControl()
    Returns
    Type Description
    System.Collections.Generic.List<System.String>
    Overrides
    Control.GetDependentControl()

    GetJsonData(PivotGridHelper)

    Declaration
    public PivotGridArgs GetJsonData(PivotGridHelper helper)
    Parameters
    Type Name Description
    PivotGridHelper helper
    Returns
    Type Description
    PivotGridArgs

    GetJsonData(PivotReport, Object)

    Declaration
    public Dictionary<string, object> GetJsonData(PivotReport report, object dataSource)
    Parameters
    Type Name Description
    PivotReport report
    System.Object dataSource
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, Boolean, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager dataManager, bool checkedStatus, string parentNode, string tag, string headerInfo)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager dataManager
    System.Boolean checkedStatus
    System.String parentNode
    System.String tag
    System.String headerInfo
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string gridLayout)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String gridLayout
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String, Boolean)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string gridLayout, bool enablePivotFieldList)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String gridLayout
    System.Boolean enablePivotFieldList
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string cellPostion, string headerInfo)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String cellPostion
    System.String headerInfo
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string value, string rowInfo, string columnInfo)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String value
    System.String rowInfo
    System.String columnInfo
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String, String, String, Boolean)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string dropType, string nodeInfo, string filterParams, bool enablePivotFieldList)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String dropType
    System.String nodeInfo
    System.String filterParams
    System.Boolean enablePivotFieldList
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, OlapDataManager, String, String, String, String, Boolean)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string dropType, string nodeInfo, string filterParams, string gridLayout, bool enablePivotFieldList)
    Parameters
    Type Name Description
    System.String action
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String dropType
    System.String nodeInfo
    System.String filterParams
    System.String gridLayout
    System.Boolean enablePivotFieldList
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string sortedHeaders)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String sortedHeaders
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string cellPosition, string headerInfo)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String cellPosition
    System.String headerInfo
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string state, string fieldHeader, string sortedHeaders)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String state
    System.String fieldHeader
    System.String sortedHeaders
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string state, string fieldHeader, string filterParams, string sortedHeaders)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String state
    System.String fieldHeader
    System.String filterParams
    System.String sortedHeaders
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String, String, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string gridLayout, string cellPosition, string headerInfo, string sortedHeaders, string filterParams)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String gridLayout
    System.String cellPosition
    System.String headerInfo
    System.String sortedHeaders
    System.String filterParams
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, Object, String, String, String, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, object dataSource, string gridLayout, string cellPosition, string headerInfo, string sortedHeaders, string filterParams, string valueSort)
    Parameters
    Type Name Description
    System.String action
    System.Object dataSource
    System.String gridLayout
    System.String cellPosition
    System.String headerInfo
    System.String sortedHeaders
    System.String filterParams
    System.String valueSort
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetJsonData(String, String, OlapDataManager, String, String, String)

    Declaration
    public Dictionary<string, object> GetJsonData(string action, string connectionString, OlapDataManager datamanager, string cellPostion, string headerInfo, string gridLayout)
    Parameters
    Type Name Description
    System.String action
    System.String connectionString
    Syncfusion.Olap.Manager.OlapDataManager datamanager
    System.String cellPostion
    System.String headerInfo
    System.String gridLayout
    Returns
    Type Description
    System.Collections.Generic.Dictionary<System.String, System.Object>

    GetLayoutProperties(String)

    Declaration
    public GridLayout GetLayoutProperties(string gridLayout)
    Parameters
    Type Name Description
    System.String gridLayout
    Returns
    Type Description
    Syncfusion.Olap.Engine.GridLayout

    ImportFromXml(String)

    Declaration
    public void ImportFromXml(string xmlString)
    Parameters
    Type Name Description
    System.String xmlString

    OnElementDropped(OlapDataManager, String, String)

    Declaration
    public OlapDataManager OnElementDropped(OlapDataManager dataManager, string eventArgument, string droppedElement)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager dataManager
    System.String eventArgument
    System.String droppedElement
    Returns
    Type Description
    Syncfusion.Olap.Manager.OlapDataManager

    OnFetchMembers(String, String)

    Declaration
    public FilterItemsCollection OnFetchMembers(string headerInfo, string cellPosition)
    Parameters
    Type Name Description
    System.String headerInfo
    System.String cellPosition
    Returns
    Type Description
    Syncfusion.PivotAnalysis.Base.FilterItemsCollection

    OnFilterElement(OlapDataManager, String)

    Declaration
    public OlapDataManager OnFilterElement(OlapDataManager DataManager, string clientParams)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String clientParams
    Returns
    Type Description
    Syncfusion.Olap.Manager.OlapDataManager

    OnFiltering(String, String)

    Declaration
    public void OnFiltering(string headerInfo, string cellPosition)
    Parameters
    Type Name Description
    System.String headerInfo
    System.String cellPosition

    OnSplitButtonRemove(OlapDataManager, String)

    Declaration
    public OlapDataManager OnSplitButtonRemove(OlapDataManager DataManager, string clientParams)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String clientParams
    Returns
    Type Description
    Syncfusion.Olap.Manager.OlapDataManager

    PopulateData(String)

    Declaration
    public void PopulateData(string report)
    Parameters
    Type Name Description
    System.String report

    RenderControl(String)

    Declaration
    public override void RenderControl(string controlId)
    Parameters
    Type Name Description
    System.String controlId
    Overrides
    Control.RenderControl(String)

    ReportManipulations(OlapDataManager, String, String)

    Declaration
    public OlapDataManager ReportManipulations(OlapDataManager DataManager, string reportName, string operationName)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String reportName
    System.String operationName
    Returns
    Type Description
    Syncfusion.Olap.Manager.OlapDataManager

    SetPaging(String, String)

    Declaration
    public OlapReport SetPaging(string currentReport, string pagingInfo)
    Parameters
    Type Name Description
    System.String currentReport
    System.String pagingInfo
    Returns
    Type Description
    Syncfusion.Olap.Reports.OlapReport

    UpdateDrilledReport(OlapDataManager, String)

    Declaration
    public void UpdateDrilledReport(OlapDataManager DataManager, string HeaderInfo)
    Parameters
    Type Name Description
    Syncfusion.Olap.Manager.OlapDataManager DataManager
    System.String HeaderInfo

    Events

    AddPDFHeaderFooter

    Declaration
    public event PivotGrid.PDFHeaderFooterEventHandler AddPDFHeaderFooter
    Event Type
    Type Description
    PivotGrid.PDFHeaderFooterEventHandler

    CSVExport

    Declaration
    public event PivotGrid.CSVExportEventHandler CSVExport
    Event Type
    Type Description
    PivotGrid.CSVExportEventHandler

    ExcelExport

    Declaration
    public event PivotGrid.ExcelExportEventHandler ExcelExport
    Event Type
    Type Description
    PivotGrid.ExcelExportEventHandler

    PDFExport

    Declaration
    public event PivotGrid.PDFExportEventHandler PDFExport
    Event Type
    Type Description
    PivotGrid.PDFExportEventHandler

    PDFGridExporting

    Declaration
    public event PivotGrid.PDFGridExportingEventHandler PDFGridExporting
    Event Type
    Type Description
    PivotGrid.PDFGridExportingEventHandler

    WordExport

    Declaration
    public event PivotGrid.WordExportEventHandler WordExport
    Event Type
    Type Description
    PivotGrid.WordExportEventHandler

    Implements

    System.Web.IHtmlString
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved