menu

Blazor

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Namespace Syncfusion.Blazor.PivotView - Blazor API Reference | Syncfusion

    Show / Hide Table of Contents

    Namespace Syncfusion.Blazor.PivotView

    Classes

    AggregateEventArgs

    The aggregate event arguments provide the necessary information on each pivot value cell framing in the pivot engine for pivot table render.

    AggregateMenuOpenEventArgs

    The aggregate menu open event arguments provide the necessary information to customize the aggregate menu options before it opens.

    AggregateTypes

    Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, Sum - Allows to display the pivot table values with sum. Product - Allows to display the pivot table values with product. Count - Allows to display the pivot table values with count. DistinctCount - Allows to display the pivot table values with distinct count. Min - Allows to display the pivot table with minimum value. Max - Allows to display the pivot table with maximum value. Avg - Allows to display the pivot table values with average. Index - Allows to display the pivot table values with index. PopulationStDev - Allows to display the pivot table values with population standard deviation. SampleStDev - Allows to display the pivot table values with sample standard deviation. PopulationVar - Allows to display the pivot table values with population variance. SampleVar - Allows to display the pivot table values with sample variance. RunningTotals - Allows to display the pivot table values with running totals. DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field. PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field. PercentageOfGrandTotal - Allows to display the pivot table values with percentage of grand total of all values. PercentageOfColumnTotal - Allows to display the pivot table values in each column with percentage of total values for the column. PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row. PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field. PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column. PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row.

    AuthenticationInfo

    Allows you to set the credential information to access the specified SSAS cube.

    It is applicable only for OLAP data source.

    AxisSet

    Allows you to configure the pivot cell information retrieved from the data source.

    BeforeExportEventArgs

    The before export event arguments provides the necessary information to customize before exporting the file.

    BeginDrillThroughEventArgs

    The begin drill-through event arguments provide the necessary information about the cell clicked on the pivot table for drill-through and editing.

    CalculatedFieldCreateEventArgs

    The calcualted field create event arguments provide the necessary information about the calculated field settings before it creates to update the pviot table.

    CalculatedFields

    Configures the specific calculated field infomation.

    CalculatedFieldSettings

    Allows options to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    CellClickEventArgs

    The cell click event arguments provides the necessary information about the cell clicked in the pivot table.

    CellSelectedObject

    Defines the selected cells information on the pivot table.

    ChartLabelInfo

    Chart Label information.

    ChartSelectionMode

    Defines the pivot chart selection mode. They are None - Disable the selection. Series - To select a series. Point - To select a point. Cluster - To select a cluster of point. DragXY - To select points, by dragging with respect to both horizontal and vertical axis. DragY - To select points, by dragging with respect to vertical axis. DragX - To select points, by dragging with respect to horizontal axis.

    ChartSeriesCreatedEventArgs

    The chart series created event arguments provide the necessary information about the chart series that used to create the pivot chart.

    ChartSeriesType

    Defines the pivot chart types. The available chart types are: Line - Allows to display the pivot chart with line series. Column - Allows to display the pivot chart with column series. Area - Allows to display the pivot chart with area series. Bar - Allows to display the pivot chart with bar series. StackingColumn - Allows to display the pivot chart with stacked column series. StackingArea - Allows to display the pivot chart with stacked area series. StackingBar - Allows to display the pivot chart with stacked bar series. StackingLine - Allows to display the pivot chart with stacked line series. StepLine - Allows to display the pivot chart with step line series. StepArea - Allows to display the pivot chart with step area series. SplineArea - Allows to display the pivot chart with spline area series. Scatter - Allows to display the pivot chart with scatter series. Spline - Allows to display the pivot chart with spline series. StackingColumn100 - Allows to display the pivot chart with 100% stacked column series. StackingBar100 - Allows to display the pivot chart with 100% stacked bar series. StackingLine100 - Allows to display the pivot chart with 100% stacked line series. StackingArea100 - Allows to display the pivot chart with 100% stacked area series. Bubble - Allows to display the pivot chart with bubble series. Pareto - Allows to display the pivot chart with pareto series. Polar - Allows to display the pivot chart with polar series. Radar - Allows to display the pivot chart with radar series.

    ColumnRenderEventArgs

    The column render event arguments provide the necessary information about the pivot table column headers before rendering.

    Condition

    Defines the conditioanal formatting operators. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    ConditionalFormatSettings

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    CustomGroups

    Allows to specify the custom group information of specific field to create custom groups.

    DataOptions

    Allows the following pivot report information such as rows, columns, values, filters, etc., that are used to render the pivot table and field list. catalog: Allows to set the database name of SSAS cube as string type that used to retrieve the data from the specified connection string. Note: It is applicable only for OLAP data source. cube: Allows you to set the SSAS cube name as string type that used to retrieve data for pivot table rendering. Note: It is applicable only for OLAP data source. providerType: Allows to set the provider type to identify the given connection is either Relational or SSAS to render the pivot table and field list. url: Allows to set the URL as string type, which helps to identify the service endpoint where the data are processed and retrieved to render the pivot table and field list. Note: It is applicable only for OLAP data source. localeIdentifier: Allows you to set the specific culture code as number type to render pivot table with desired localization. By default, the pivot table displays with culture code 1033, which indicates "en-US" locale. Note: It is applicale only for OLAP data source. dataSource: Allows you to set the data source as JSON collection to the pivot report either from local or from remote server to the render the pivot that and field list. You can fetch JSON data from remote server by using DataManager. Note: It is applicable only for relational data source. rows: Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. columns: Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. values: Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. filters: Allows to filter the values in other axis based on the collection of filter fields in pivot table. excludeFields: Allows you to restrict the specific field(s) from displaying it in the field list UI. You may also be unable to render the pivot table with this field(s) by doing so. Note: It is applicable only for relational data source. expandAll: Allows you to either expand or collapse all the headers that are displayed in the pivot table. By default, all the headers are collapsed in the pivot table. Note: It is applicable only for Relational data. valueAxis: Allows you to set the value fields that to be plotted either in row or column axis in the pivot table. filterSettings: Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table. sortSettings: Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the enableSorting property to be true. enableSorting: Allows to perform sort operation to order members of a specific fields either in ascending or descending that used to be displayed in the pivot table. formatSettings: Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C. drilledMembers: Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table. valueSortSettings: Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order. calculatedFieldSettings: Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table. allowMemberFilter: Allows to perform filter operation based on the selective filter members of the specific fields used to be displayed in the pivot table. allowLabelFilter: Allows to perform filter operation based on the selective headers used to be displayed in the pivot table. allowValueFilter: Allows to perform filter operation based only on value fields and its resultant aggregated values over other fields defined in row and column axes that used to be displayed in the pivot table. showSubTotals: Allows to show or hide sub-totals in both rows and columns axis of the pivot table. showRowSubTotals: Allows to show or hide sub-totals in row axis of the pivot table. showColumnSubTotals: Allows to show or hide sub-totals in column axis of the pivot table. showGrandTotals: Allows to show or hide grand totals in both rows and columns axis of the pivot table. showRowGrandTotals: Allows to show or hide grand totals in row axis of the pivot table. showColumnGrandTotals: Allows to show or hide grand totals in column axis of the pivot table. grandTotalsPosition: Allows the grand totals to be displayed at the top or bottom of the pivot table's row and column axis. subTotalsPosition: Specifies different types of positions that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table. showHeaderWhenEmpty: Allows the undefined headers to be displayed in the pivot table, when the specific field(s) are not defined in the raw data. For example, if the raw data for the field ‘Country’ is defined as “United Kingdom” and “State” is not defined means, it will be shown as “United Kingdom >> Undefined” in the header section. alwaysShowValueHeader: Allows to show the value field header always in pivot table, even if it holds a single field in the value field axis. conditionalFormatSettings: Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions. emptyCellsTextContent: Allows to show custom string to the empty value cells that used to display in the pivot table. You can fill empty value cells with any value like “0”, ”-”, ””, “(blank)”, etc. groupSettings: Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table. showAggregationOnValueField: Allows the pivot button with specific value field caption along with the aggregation type, to be displayed in the grouping bar and field list UI. For example, if the value field "Sold Amount" is aggregated with Sum, it will be displayed with caption "Sum of Sold Amount" in its pivot button. authentication: Allows you to set the credential information to access the specified SSAS cube. Note: It is applicable only for OLAP data source.

    DataSourceType

    Allows to define the data source type. They are, JSON: Defines JSON type of data source. CSV: Defines CSV or string[][] type of data source.

    DateGroup

    Defines group of date field. They are: Years - Defines group field as 'Years' for date type field. Quarters - Defines group field as 'Quarters' for date type field. QuarterYear - Defines group field as 'Quarter Year' for date type field. Months - Defines group field as 'Months' for date type field. Days - Defines group field as 'Days' for date type field. Hours - Defines group field as 'Hours' for date type field. Minutes - Defines group field as 'Minutes' for date type field. Seconds - Defines group field as 'Seconds' for date type field.

    DateMembers

    It allow to set date members information.

    DateOperators

    Defines the conditional operators for date type fields. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. Before - Display the pivot table with preview all records from the given date. BeforeOrEqualTo - Display the pivot table with previous all records along with the given date. After - Display the pivot table with next all records to the given date. AfterOrEqualTo - Display the pivot table with next all records along with the given date. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    DrillArgs<T>

    The drill event arguments provide the necessary information about the pivot cell that performing drill operation.

    DrilledItem

    Allows you to configure the drill information of a specific field item that used to display the pivot table.

    DrillOptions

    Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

    DrillThroughEventArgs

    The drill-through event arguments provides the necessary information about the cell clicked in the pivot table for drill-through.

    EditCompletedEventArgs<T>

    The event argument which holds the editing information of the raw data made in corresponding aggregated cell before updated to the pivot table.

    EditMode

    Allow options for performing CRUD operations with different modes in the data grid that used to update the appropriate cells in the pivot table. The available modes are as follows: Normal - Allows the currently selected row alone will be completely changed to edit state. You can change the cell values and save it to the data source by clicking “Update” toolbar button. Dialog - Allows the currently selected row data will be shown in an exclusive dialog. You can change the cell values and save it to the data source by clicking “Save” button in the dialog. Batch - Allows you to perform double-click on any data specific cell in the data grid, the state of that selected cell will be changed to edit state.

    EnginePopulatedEventArgs

    The engine populated event arguments provides the necessary information about the engine populated using updated report.

    EnginePopulatingEventArgs

    The engine populating event arguments provides the necessary information to customize the report before populating the pivot engine.

    FetchReportArgs

    The fetch report event arguments provides the necessary information to fetch reports from storage.

    Field

    Allows you to configure the information retrieved from the data source for the field list.

    FieldDragStartEventArgs

    The field drag start event arguments provides the necessary information about the drag field and its axis.

    FieldDropEventArgs

    The field drop event arguments provides the necessary information to customize the drop field and its drop axis.

    FieldDroppedEventArgs

    The field dropped event arguments provides the necessary information about the dropped field and its dropped axis.

    FieldItemInfo

    Allows to configure the specific field infomration during UI operation at runtime.

    FieldListRefreshedEventArgs

    The field list refreshed event arguments provide the necessary information to render the pivot table.

    FieldOptions

    Allows specific fields associated with field information that needs to be displayed in the field axes of pivot table. The following configurations which are applicable are as follows:.

    FieldRemoveEventArgs

    The field remove event arguments provide the necessary information about the selected field information before it removes.

    Filter

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    FilterType

    Allows you to set the specific filter type to display the filter members in the pivot table. They are: Include - Specifies the filter type as include for member filter. Exclude - Specifies the filter type as exclude for member filter. Label - Specifies the filter type as label for header filter. Date - Specifies the filter type as date for date based filter. Number - Specifies the filter type as number for number based filter. Value - Specifies the filter type as value for value based filter.

    FormatSettings

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C.

    FormatType

    Defines the format types. They are: Number - Defines format type as 'Number' for numeric type field. Date - Defines format type as 'DateTime' for date type field.

    GrandTotalsPosition

    Allows the grand totals to be displayed at the top or bottom of the pivot table’s row and column axis. By default, the grand totals are displayed at the bottom of the pivot table’s row and column axes. Bottom - Allows the grand totals to be displayed in bottom position in the pivot table's row and column axis. Top - Allows the grand totals to be displayed in top position in the pivot table's row and column axis.

    GroupSettings

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    GroupType

    Defines the group types. They are: Date - Defines group type as 'Date' for date type field Number - Defines group type as 'Number' for numeric type field. Custom - Defines group type as 'Custom' for custom group field.

    HyperCellClickEventArgs

    The hyperlink cell click event arguments provides the necessary information about the cell clicked in the pivot table for hyperlink.

    LabelOperators

    Defines the conditional operators for string type fields. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. BeginWith - Display the pivot table that begins with text. DoesNotBeginWith - Display the pivot table that does not begins with text. EndsWith - Display the pivot table that ends with text. DoesNotEndsWith - Display the pivot table that does not ends with text. Contains - Display the pivot table that contains text. DoesNotContains - Display the pivot table that does not contain text. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    LabelPosition

    Defines the data label position. They are, Outer: Positions the label outside the point. Top: Positions the label on top of the point. Bottom: Positions the label at the bottom of the point. Middle: Positions the label to the middle of the point. Auto: Positions the label based on series.

    LevelPos

    Level Position.

    LoadEventArgs<T>

    The load event arguments provides the necessary information to customize the pivot table before initializing the component.

    LoadReportArgs

    The load report event arguments provides the necessary information to load the report.

    MemberEditorOpenEventArgs

    The member editor open event arguments provide the necessary information about the selected field and its fitler settingster on before filter popup opens.

    MemberFilteringEventArgs

    The member filtering event arguments provides the necessary information about the filtering which is performing.

    Members

    It allow to set members information.

    Mode

    It defines the field list render modes. The available modes are: Fixed - To display the field list icon in pivot table UI to invoke the built-in dialog. Popup - To display the field list in a static position within a web page.

    MultipleAxisMode

    Defines the mode of displaying the chart series that are created from different measures. They are Stacked - Separates the chart series of different measures and display them in their own chart area.br/> Single - Group the chart series of different measures and display them with separate Y-axes in a single chart area.br/> Combined - Group the chart series with a single Y-axis for all value fields in the pivot chart area. These chart series will be drawn based on the Y-axis range values calculated from all of the bound value fields. Note: The first value field in the value axis will be used to format the Y-axis range values. For example, if the first value field is in currency format and the remaining value fields are in different number formats or no format, the currency format will be used for the Y-axis range values.

    NewReportArgs

    The new report event arguments provides the necessary information to create a new report.

    NumberFormattingEventArgs

    The number formatting event arguments provide the necessary information about the format settings of the selected field before it creates to update the pviot table.

    Operators

    Defines the conditional operators for filtering settings. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. BeginWith - Display the pivot table that begins with text. DoesNotBeginWith - Display the pivot table that does not begins with text. EndsWith - Display the pivot table that ends with text. DoesNotEndsWith - Display the pivot table that does not ends with text. Contains - Display the pivot table that contains text. DoesNotContains - Display the pivot table that does not contain text. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Before - Display the pivot table with preview all records from the given date. BeforeOrEqualTo - Display the pivot table with previous all records along with the given date. After - Display the pivot table with next all records to the given date. AfterOrEqualTo - Display the pivot table with next all records along with the given date. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    PagerPosition

    Specifies the position of the pager in the Pivot Table.

    PdfBorder

    Defines the border options for PDF export.

    PdfBorderStyle

    Defines border style to PDF export file. They are Solid - Export as PDF with solid type border. Dash - Export as PDF with dash type border. Dot - Export as PDF with dot type border. DashDot - Export as PDF with dashdot type border. DashDotDot - Export as PDF with dashdotdot type border.

    PdfCellRenderArgs

    The PDF cell render event arguments provides the necessary information to customize the pivot cells while PDF exporting.

    PdfStyle

    Defines the styles information to customize the PDF cell.

    PdfTheme

    Defines the theme options for PDF export.

    PdfThemeStyle

    Defines the theme options for PDF export.

    PivotAccumulationChartSelectionMode

    Defines the SelectionMode for chart types pie, doughnut, Funnel and pyramid. None - Disable the selection. Point - To select a point.

    PivotActionBeginEventArgs

    The action begins event arguments provide information about the current UI action, such as the action name, current datasource settings, and the selected field information which are configured based on the UI actions like drill down/up, value sorting, built-in toolbar options, grouping bar and field list buttons actions such as sorting, filtering, editing, aggregate type change and so on, CRUD operation in editing in the pivot table.

    PivotActionCompleteEventArgs<T>

    The action complete event arguments provide information about the current UI action, such as the current action name, current datasource settings, selected field information, and the current action information which are configured based on the UI actions like drill down/up, value sorting, built-in toolbar options, grouping bar and field list buttons actions such as sorting, filtering, editing, aggregate type change and so on, CRUD operation in editing in the pivot table.

    PivotActionFailureEventArgs

    When the current UI action fails to achieve the desired result, the action failure event arguments provide necessary information about the current UI action, such as the current action name and failure information which are configured based on the UI actions like drill down/up, value sorting, built-in toolbar options, grouping bar and field list buttons actions such as sorting, filtering, editing, aggregate type change and so on, CRUD operation in editing in the pivot table.

    PivotActionInfo<T>

    Defines the unique information of the current UI action performed such as sorting, filtering, dril, editing, report manipulation, summarization, etc.

    PivotAuthentication

    Allows you to set the credential information to access the specified SSAS cube.

    It is applicable only for OLAP data source.

    PivotCalculatedFieldSetting

    Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    PivotCellSelectedEventArgs

    The cell selected event arguments provide the necessary information about the pivot cells that have been selected.

    PivotCellSelectionMode

    Defines mode of cell selection. The modes available are: Flow - Allows the range of cells to be selected between the start index and the end index, which also includes the other cells of the selected rows in the pivot table. Box - Allows you to select a range of cells within the starting and ending column indexes that are included in the range between row cells in the pivot table. BoxWithBorder - Allows the range of cells to be selected as the box mode, but along with the borders in the pivot table.

    PivotChartAlignment

    Defines the Alignment. They are Near - Align the element to the left. Center - Align the element to the center. Far - Align the element to the right.

    PivotChartAnchor

    Defines the strip line text position. Start - Places the strip line text at the start. Middle - Places the strip line text in the middle. End - Places the strip line text at the end.

    PivotChartAreaSettings

    Allow options to customize the chart area with a variety of settings such as background color, border, opacity and background image in the pivot chart. For example, to change the of the pivot chart's background, set the property opacity to 0.5.

    PivotChartAxisLine

    Allows options for customizing axis lines.

    PivotChartAxisPosition

    Defines the Position. They are inside - Place the ticks or labels inside to the axis line. outside - Place the ticks or labels outside to the axis line.

    PivotChartBorder

    Allows options to customize the border of the chart area.

    PivotChartBorderType

    Defines border type for multi level labels. Rectangle - Shows chart border as rectangle. Brace - Shows chart border as braces. WithoutBorder - Shows chart without border. Without top Border - Shows chart with border on its top. Without top and bottom border - Shows chart with border on its top and bottom. Curly brace - Shows chart with curly braces.

    PivotChartCommonBorder

    Allows options to customize the border of the chart area.

    PivotChartCommonFont

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartConnectorStyle

    Allow options to customize the pie, funnel, doughnut and pyramid chart data label connector.

    PivotChartConnectorType

    Defines the ConnectorType for chart types pie, doughnut, Funnel and pyramid. They are Line - Accumulation series Connector line type as Straight line. Curve - Accumulation series Connector line type as Curved line.

    PivotChartCornerRadius

    Allows to render the column series points with particular rounded corner.

    PivotChartCrosshairSettings

    Allow options to customize the crosshair line with different settings such as color and width of the line, line types that are shown horizontally and vertically to indicate the value of the axis at the mouse hover or touch position in the pivot chart.

    PivotChartCrosshairTooltip

    Allows options to customize the crosshair ToolTip.

    PivotChartCrosshairTooltipTextStyle

    Allows options to customize the crosshair ToolTip text.

    PivotChartData

    Pivot chart data.

    PivotChartDataLabel

    Allows to set the data label for the series.

    PivotChartDrawType

    Type of series to be drawn in radar or polar series. They are line - Renders the line series. column - Renders the column series. area - Renders the area series. scatter - Renders the scatter series. spline - Renders the spline series. stackingColumn - Renders the stacking column series. stackingArea - Renders the stacking area series. rangeColumn - Renders the range column series. splineArea - Renders the spline area series.

    PivotChartEdgeLabelPlacement

    Defines the Edge Label Placement for an axis. They are none - No action will be perform. hide - Edge label will be hidden. shift - Shift the edge labels.

    PivotChartEmptyPointBorder

    Allows to configure the empty points border with color and width in the chart.

    PivotChartEmptyPointMode

    Defines the empty point mode of the chart. Gap - Used to display empty points as space. Zero - Used to display empty points as zero. Drop - Used to ignore the empty point while rendering. Average - Used to display empty points as previous and next point average.

    PivotChartEmptyPointSettings

    Allows to configure the empty points with a variety of means such as fill color, border and mode in the chart.

    PivotChartErrorBarCapSettings

    Allows options for customizing the cap of the error bar.

    PivotChartErrorBarDirection

    Defines the direction of error bar. They are Both - Renders both direction of error bar. Minus - Renders minus direction of error bar. Plus - Renders plus direction error bar.

    PivotChartErrorBarMode

    Defines the modes of error bar. They are Vertical - Renders a vertical error bar. Horizontal - Renders a horizontal error bar. Both - Renders both side error bar.

    PivotChartErrorBarType

    Defines the type of error bar. They are Fixed - Renders a fixed type error bar. Percentage - Renders a percentage type error bar. StandardDeviation - Renders a standard deviation type error bar. StandardError - Renders a standard error type error bar. Custom - Renders a custom type error bar.

    PivotChartErrorSettings

    Allows options for displaying and customizing error bar for individual point in a series.

    PivotChartGroupModes

    Defines the mode of the group mode for chart types pie, doughnut, Funnel and pyramid Point - When choosing points, the selected points get grouped. Value - When choosing values, the points which less then values get grouped.

    PivotChartIndexes

    Allows you to highlight a specific point of the series while rendering the pivot chart. For example, to highlight first point in the first series, set the properties series to 0 and points to 1. To use this option, it requires the property selectionMode to be Point or Series.

    PivotChartLabelBorder

    Allows to set the border of the multi level labels.

    PivotChartLabelIntersectAction

    Defines the Alignment. They are None - Shows all the labels. Hide - Hide the label when it intersect. Rotate45 - Rotate the label to 45 degree when it intersect. Rotate90 - Rotate the label to 90 degree when it intersect.

    PivotChartLabelPlacement

    Defines the Label Placement for category axis. They are BetweenTicks - Render the label between the ticks. OnTicks - Render the label on the ticks.

    PivotChartLabelPosition

    Defines the LabelPosition for chart types pie, doughnut, Funnel and pyramid. They are Inside - Define the data label position for the accumulation series Inside. Outside - Define the data label position for the accumulation series Outside.

    PivotChartLegendBorder

    Options to customize the border of the legend.

    PivotChartLegendMargin

    Options to customize the margin of the legend.

    PivotChartLegendPosition

    Defines the position of the legend. They are Auto - Places the legend based on area type. Bottom - Displays the legend on the bottom of chart. Top - Displays the legend on the top of chart. Left - Displays the legend on the left of chart. Right - Displays the legend on the right of chart. Custom - Displays the legend based on given x and y value.

    PivotChartLegendSettings

    Allow options for customizing legends with different properties such as legend visibility, height, width, position, legend padding, alignment, textStyle, border, margin, background, opacity, description, tabIndex in the pivot chart.

    PivotChartLegendShape

    Defines the shape of legend. They are Circle - Renders a circle. Rectangle - Renders a rectangle. Triangle - Renders a triangle. Diamond - Renders a diamond. Cross - Renders a cross. HorizontalLine - Renders a horizontalLine. VerticalLine - Renders a verticalLine. Pentagon - Renders a pentagon. InvertedTriangle - Renders a invertedTriangle. SeriesType -Render a legend shape based on series type.

    PivotChartLegendTextStyle

    Allows options to customize the legend text.

    PivotChartLineType

    Defines the mode of line in crosshair. They are None - Hides both vertical and horizontal crosshair line. Both - Shows both vertical and horizontal crosshair line. Vertical - Shows the vertical line. Horizontal - Shows the horizontal line.

    PivotChartMajorGridLines
    PivotChartMajorTickLines

    Allows options for customizing major tick lines.

    PivotChartMarginSettings

    Allow options to customize the left, right, top and bottom margins of the pivot chart.

    PivotChartMarkerDataLabel

    Allow options to customize the marker data label for the pivot chart.

    PivotChartMarkerDataLabelBorder

    Allow options to change the border of the data label on the pivot chart series marker.

    PivotChartMarkerDataLabelFont

    Allow options to change the font of the data label on the pivot chart series marker.

    PivotChartMarkerDataLabelMargin

    Allow options to change the margin of the data label on the pivot chart series marker.

    PivotChartMarkerSettings

    Allow options to customize the marker settinngs for the pivot chart.

    PivotChartMinorGridLines

    Allows options for customizing minor grid lines.

    PivotChartMinorTickLines

    Allows options for customizing minor tick lines.

    PivotChartPrimaryXAxis

    Allows to customize Primary X Axis for the pivot chart.

    PivotChartPrimaryXAxisBorder

    Allows to customize the label border with a variety of means such as label color and width in the chart.

    PivotChartPrimaryXAxisCrosshairTooltip

    Allows options to customize the crosshair ToolTip.

    PivotChartPrimaryXAxisFont

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPrimaryXAxisLineStyle

    Allows to configure the axis line such as line width, dashArray and color in a chart.

    PivotChartPrimaryXAxisMajorGridLines

    Allows to configure the major grid lines such as line width, color and dashArray in the axis.

    PivotChartPrimaryXAxisMajorTickLines

    Allows to configure the major tick lines such as width, height and color in the chart.

    PivotChartPrimaryXAxisMinorGridLines

    Allows to configure the minor grid lines such as line width, dashArray and color in the axis.

    PivotChartPrimaryXAxisMinorTickLines

    Allows to configure the minor tick lines such as width, height and color in the chart.

    PivotChartPrimaryXAxisStripBorder

    Allow options to customize the border of the chart series such as color and border size in the pivot chart. For example, to display the chart series border color as red, set the properties color to either "red" or "#FF0000" or "rgba(255,0,0,1.0)" and width to0.5.

    PivotChartPrimaryXAxisStripFont

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPrimaryXAxisStripLineSetting

    Allows to congifure the strip line properties such as line position, size, color, size type, border, text and opacity in the chart.

    PivotChartPrimaryXAxisStripLineSettings

    Allows to congifure the strip line properties such as line position, size, color, size type, border, text and opacity in the chart.

    PivotChartPrimaryXAxisTitleStyle

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPrimaryYAxis
    • Allow options to customize the vertical(value) axis with different properties such as labelIntersectAction, labelStyle, title, description, crosshairTooltip, labelFormat, titleStyle, plotOffset, edgeLabelPlacement, labelPlacement, tickPosition, opposedPosition, minor and major grid lines, minor and major tick lines, border, etc. in the pivot chart.
    PivotChartPrimaryYAxisBorder

    Allows to customize the label border with a variety of means such as label color and width in the chart.

    PivotChartPrimaryYAxisCrosshairTooltip

    Allows options to customize the crosshair ToolTip.

    PivotChartPrimaryYAxisFont

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPrimaryYAxisLineStyle

    Allows to configure the axis line such as line width, dashArray and color in a chart.

    PivotChartPrimaryYAxisMajorGridLines

    Allows to configure the major grid lines such as line width, color and dashArray in the axis.

    PivotChartPrimaryYAxisMajorTickLines

    Allows to configure the major tick lines such as width, height and color in the chart.

    PivotChartPrimaryYAxisMinorGridLines

    Allows to configure the minor grid lines such as line width, dashArray and color in the axis.

    PivotChartPrimaryYAxisMinorTickLines

    Allows to configure the minor tick lines such as width, height and color in the chart.

    PivotChartPrimaryYAxisStripBorder

    Allow options to customize the border of the chart series such as color and border size in the pivot chart. For example, to display the chart series border color as red, set the properties color to either "red" or "#FF0000" or "rgba(255,0,0,1.0)" and width to0.5.

    PivotChartPrimaryYAxisStripFont

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPrimaryYAxisStripLineSetting

    Allows to set the stripLine collection for the axis.

    PivotChartPrimaryYAxisStripLineSettings

    Allows to congifure the strip line properties such as line position, size, color, size type, border, text and opacity in the chart.

    PivotChartPrimaryYAxisTitleStyle

    Allows to customize the apprearance of the text in the chart such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartPyramidModes

    Defines the mode of the pyramid Linear - Height of the pyramid segments reflects the values Surface - Surface/Area of the pyramid segments reflects the values.

    PivotChartSegment

    Allows to set the regions that helps to differentiate a line series.

    PivotChartSegments

    Allows to set the collection of regions that helps to differentiate a line series.

    PivotChartSeries

    Allow options to customize the chart series with different settings such as fill color, animation of the series, series width, border, visibility of the series, opacity, chart series types, marker, tooltip, trendlines, etc., in the pivot chart. For example, to display the line type pivot chart, set the property type to** Line**.

    PivotChartSeriesAnimation

    Allows to configure the animation behavior for chart series such as animation duration and delay.

    PivotChartSeriesBorder

    Allow options to customize the border of the chart series such as color and border size in the pivot chart. For example, to display the chart series border color as red, set the properties color to either "red" or "#FF0000" or "rgba(255,0,0,1.0)" and width to0.5.

    PivotChartSettings

    Allows a set of options to customize a pivot chart with a variety of settings, such as chart series, chart area, axis labels, legends, border, crosshairs, theme, title, tooltip, zooming, etc. The following options are available to customize the pivot chart.

    • background: Allows you to change the background color of the chart series in the pivot chart. For example, to display the chart series with background color as red, set the property background to either "red" or**"#FF0000"** or**"rgba(255,0,0,1.0)"**.
    • border: Allow options to customize the border of the chart series such as color and border size in the pivot chart. For example, to display the chart series border color as red, set the properties color to either "red" or**"#FF0000"** or**"rgba(255,0,0,1.0)"** and width to0.5.
    • chartArea: Allow options to customize the chart area with a variety of settings such as background color, border, opacity and background image in the pivot chart. For example, to change the of the pivot chart's background, set the property opacity to 0.5.
    • chartSeries: Allow options to customize the chart series with different settings such as fill color, animation of the series, series width, border, visibility of the series, opacity, chart series types, marker, tooltip, trendlines, etc., in the pivot chart. For example, to display the line type pivot chart, set the property type to** Line**.
    • crosshair: Allow options to customize the crosshair line with different settings such as color and width of the line, line types that are shown horizontally and vertically to indicate the value of the axis at the mouse hover or touch position in the pivot chart.
    • description: Allows you to add a description of the pivot chart.
    • enableAnimation: Allows you to enable/disable the tooltip animation while performing the mouse move from one point to another in the pivot chart.
    • enableExport: Allows the pivot chart to be exported to either** PDF** or** PNG** or** JPEG** or** SVG** filter formats.
    • enableMultipleAxis: Allows you to draw the pivot chart with multiple value fields as separate chart area.
    • enableSideBySidePlacement: Allows you to draw points of the column type pivot chart series as side by side.
    • isMultiSelect: Allows you to perform multiple selection in the pivot chart.To enable this option, it requires the property selectionMode to be Point or Series or Cluster.
    • isTransposed: Allows you to render the pivot chart in a transposed manner or not.
    • legendSettings: Allow options for customizing legends with different properties such as legend visibility, height, width, position, legend padding, alignment, textStyle, border, margin, background, opacity, description, tabIndex in the pivot chart.
    • margin: Allow options to customize the left, right, top and bottom margins of the pivot chart.
    • palettes: Allows you to draw the chart series points with custom color in the pivot chart.
    • primaryXAxis: Allow options to customize the horzontal(row) axis with different properties such as labelIntersectAction, labelStyle, title, description, crosshairTooltip, labelFormat, titleStyle, plotOffset, edgeLabelPlacement, labelPlacement, tickPosition, opposedPosition, minor and major grid lines, minor and major tick lines, border, etc. in the pivot chart.
    • primaryYAxis: Allow options to customize the vertical(value) axis with different properties such as labelIntersectAction, labelStyle, title, description, crosshairTooltip, labelFormat, titleStyle, plotOffset, edgeLabelPlacement, labelPlacement, tickPosition, opposedPosition, minor and major grid lines, minor and major tick lines, border, etc. in the pivot chart.
    • selectedDataIndexes: Allows you to highlight a specific point of the series while rendering the pivot chart. For example, to highlight first point in the first series, set the properties series to 0 and points to 1. To use this option, it requires the property selectionMode to be Point or Series.
    • selectionMode: Allow options for customizing the selection mode to be done either by a specific series or point or cluster or by dragging it to the pivot chart. For example, to highlight a specific point in a specific series of the pivot chart, set the property selectionMode to** Point**.
    • showMultiLevelLabels: Allows you to display the multi-level label feature in the pivot chart.This multi-level labels used to perform drill operation in the pivot chart.
    • subTitle: Allows you to add the subtitle to the pivot chart.
    • subTitleStyle: Allow options to customize the subtitle in the pivot chart with different properties such as fontStyle, font size, fontWeight, font color, testAlignment, fontFamily, opacity, textOverflow.
    • tabIndex: Allows you to highlight specific legends by clicking the mouse or by interacting with the keyboard in the pivot chart.
    • theme: Allows you to draw a pivot chart with either material, fabric, bootstrap, highcontrast light, material dark, fabric dark, highcontrast, bootstrap dark, bootstrap4 theme.
    • title: Allows you to add title to the pivot chart.
    • titleStyle: Allow options to customize the title in the pivot chart with different properties such as fontStyle, font size, fontWeight, font color, testAlignment, fontFamily, opacity, textOverflow.
    • tooltip: Allow options to customize the tooltip of the pivot chart with different properties such as visibility of the tooltip, enableMarker, fill color, opacity, header for tooltip, format, textStyle, template, border, enableAnimation.
    • useGroupingSeparator: Allows the group separator to be shown to the values in the pivot chart.
    • value: Allows you to draw a pivot chart with a specific value field during initial loading.
    • zoomSettings: Allow options to customize the pivot chart zooming with different properties such as enablePinchZooming, enableSelectionZooming, enableDeferredZooming, enableMouseWheelZooming, zoom modes, toolbarItems, enableScrollbar and enablePan.
    PivotChartShape

    Defines the shape of marker. They are Circle - Renders the marker shaper as circle. Rectangle - Renders the marker shaper as rectangle. Triangle - Renders the marker shaper as triangle. Diamond - Renders the marker shaper as diamond. Cross - Renders the marker shaper as cross. HorizontalLine - Renders the marker shaper as horizontalLine. VerticalLine - Renders the marker shaper as verticalLine. Pentagon- Renders the marker shaper as pentagon. InvertedTriangle - Renders the marker shaper as invertedTriangle. Image - Renders the marker shaper as image.

    PivotChartSizeType

    Defines the unit of Strip line Size. They are Auto - In numeric axis, it will consider a number and DateTime axis, it will consider as milliseconds. Pixel - The stripline gets their size in pixel. Year - The stipline size is based on year in the DateTime axis. Month - The stipline size is based on month in the DateTime axis. Day - The stipline size is based on day in the DateTime axis. Hour - The stipline size is based on hour in the DateTime axis. Minutes - The stipline size is based on minutes in the DateTime axis. Seconds - The stipline size is based on seconds in the DateTime axis.

    PivotChartSplineType

    It defines type of spline. Natural - Used to render Natural spline. Cardinal - Used to render cardinal spline. Clamped - Used to render Clamped spline Monotonic - Used to render monotonic spline.

    PivotChartStripLines

    Allows to customize the strip lineof the pivot chart.

    PivotChartSubTitleStyle

    Allows to customize the apprearance of the chart subtitle such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartTextOverflow

    Defines the Text overflow. None - Shown the chart title with overlap if exceed. Wrap - Shown the chart title with wrap if exceed. Trim - Shown the chart title with trim if exceed.

    PivotChartTitleStyle

    Allows to customize the apprearance of the chart title such as font style, font size, font weight, font color, font family, text alignment, opacity, text overflow.

    PivotChartToolbarItems

    Defines the ZoomingToolkit, They are. Zoom - Renders the zoom button. ZoomIn - Renders the zoomIn button. ZoomOut - Renders the zoomOut button. Pan - Renders the pan button. Reset - Renders the reset button.

    PivotChartTooltipBorder

    Allows to customize the pivot chart tooltip border.

    PivotChartTooltipSettings

    Allows to customize the pivot chart tooltip.

    PivotChartTooltipTextStyle

    Allows to customize pivot chart tooltip text style.

    PivotChartTrendline

    Allows to set the trendlines that are used to predict the trend.

    PivotChartTrendlineAnimation

    Options to customize the animation for trendlines.

    PivotChartTrendlineMarker

    Specifies the configuration of the marker in trendline.

    PivotChartTrendlines

    Allows to set the collection of trendlines that are used to predict the trend.

    PivotChartTrendlineTypes

    Defines the type of trendlines. They are: Linear - Defines the linear trendline. Exponential - Defines the exponential trendline. Polynomial - Defines the polynomial trendline. Power - Defines the power trendline. Logarithmic - Defines the logarithmic trendline. MovingAverage - Defines the moving average trendline.

    PivotChartZIndex

    Specifies the order of the strip line. Over | Behind. Over - Places the strip line over the series elements. Behind - laces the strip line behind the series elements.

    PivotChartZoomMode

    Defines the zooming mode, They are. X,Y - Chart will be zoomed with respect to both vertical and horizontal axis. X - Chart will be zoomed with respect to horizontal axis. Y - Chart will be zoomed with respect to vertical axis.

    PivotChartZoomSettings

    Allow options to customize the pivot chart zooming with different properties such as enablePinchZooming, enableSelectionZooming, enableDeferredZooming, enableMouseWheelZooming, zoom modes, toolbarItems, enableScrollbar and enablePan.

    PivotColumn

    Defines the grid columns information that used to render as the pivot table header.

    PivotConditionalFormatSettings

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    PivotConditionalFormattingStyle

    Allows to set the custom styles for the formatting applied values in the pivot table.

    PivotCustomGroupSettings

    It allows to set the custom group information to create custom group fields.

    It is applicable only for custom grouping.

    PivotEditInfo<T>

    Defines the edited information such as current edit type, action and its edited record information such as edited data, previous data and index positions of before editing performed.

    PivotExportInfo

    Defines the export information such as current export type and its additional settings such as page size, orientation, header, footer, etc.,

    PivotFieldListAuthentication

    Allows you to set the credential information to access the specified SSAS cube.

    It is applicable only for OLAP data source.

    PivotFieldListCalculatedFieldSetting

    Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    PivotFieldListCalculatedFieldSettings

    Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    PivotFieldListColumn

    Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in column axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in column axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field.

    PivotFieldListColumns

    Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in column axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in column axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotFieldListConditionalFormatSetting

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    PivotFieldListConditionalFormatSettings

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    PivotFieldListCustomGroup

    It allows to set the custom group information to create custom group fields.

    It is applicable only for custom grouping.

    PivotFieldListCustomGroups

    It allows to set the custom group information to create custom group fields.

    It is applicable only for custom grouping.

    PivotFieldListDataSourceSettings<TValue>

    Allows the following pivot report information such as rows, columns, values, filters, etc., that are used to render the pivot table and field list. Catalog: Allows to set the database name of SSAS cube as string type that used to retrieve the data from the specified connection string. Note: It is applicable only for OLAP data source. Cube: Allows you to set the SSAS cube name as string type that used to retrieve data for pivot table rendering. Note: It is applicable only for OLAP data source. ProviderType: Allows to set the provider type to identify the given connection is either Relational or SSAS to render the pivot table and field list. Note: It is applicable only for OLAP data source. GrandTotalsPosition: Allows the grand totals to be displayed in either the top or bottom position in the pivot table's row and column axis.By default, the grand totals are displayed at the bottom of the pivot table's row and column axis. SubTotalsPosition: Gets or sets an enum value that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table. Note: By default, the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table. Url: Allows to set the URL as string type, which helps to identify the service endpoint where the data are processed and retrieved to render the pivot table and field list. Note: It is applicable only for OLAP data source. LocaleIdentifier: Allows you to set the specific culture code as number type to render pivot table with desired localization. By default, the pivot table displays with culture code 1033, which indicates "en-US" locale. Note: It is applicale only for OLAP data source. DataSource: Allows you to set the data source to the pivot report either as JSON data collection or from remote data server using DataManager to the render the pivot that and field list. Note: It is applicable only for relational data source. Rows: Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. Columns: Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. Values: Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. Filters: Allows to filter the values in other axis based on the collection of filter fields in pivot table. ExcludeFields: Allows you to restrict the specific field(s) from displaying it in the field list UI. You may also be unable to render the pivot table with this field(s) by doing so. Note: It is applicable only for relational data source. ExpandAll: Allows you to either expand or collapse all the headers that are displayed in the pivot table. By default, all the headers are collapsed in the pivot table. Note: It is applicable only for Relational data. ValueAxis: Allows you to set the value fields that to be plotted either in row or column axis in the pivot table. FilterSettings: Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table. SortSettings: Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the enableSorting property to be true. EnableSorting: Allows to perform sort operation to order members of a specific fields either in ascending or descending that used to be displayed in the pivot table. FormatSettings: Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C. DrilledMembers: Allows specific fields to with specify the headers that used to be either expanded or collapsed in the pivot table. ValueSortSettings: Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order. CalculatedFieldSettings: Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table. AllowMemberFilter: Allows to perform filter operation based on the selective filter members of the specific fields used to be displayed in the pivot table. AllowLabelFilter: Allows to perform filter operation based on the selective headers used to be displayed in the pivot table. AllowValueFilter: Allows to perform filter operation based only on value fields and its resultant aggregated values over other fields defined in row and column axes that used to be displayed in the pivot table. ShowSubTotals: Allows to show or hide sub-totals in both rows and columns axis of the pivot table. ShowRowSubTotals: Allows to show or hide sub-totals in row axis of the pivot table. ShowColumnSubTotals: Allows to show or hide sub-totals in column axis of the pivot table. ShowGrandTotals: Allows to show or hide grand totals in both rows and columns axis of the pivot table. ShowRowGrandTotals: Allows to show or hide grand totals in row axis of the pivot table. ShowColumnGrandTotals: Allows to show or hide grand totals in column axis of the pivot table. ShowHeaderWhenEmpty: Allows the undefined headers to be displayed in the pivot table, when the specific field(s) are not defined in the raw data. For example, if the raw data for the field ‘Country’ is defined as “United Kingdom” and “State” is not defined means, it will be shown as “United Kingdom >> Undefined” in the header section. AlwaysShowValueHeader: Allows to show the value field header always in pivot table, even if it holds a single field in the value field axis. ConditionalFormatSettings: Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions. EmptyCellsTextContent: Allows to show custom string to the empty value cells that used to display in the pivot table. You can fill empty value cells with any value like “0”, ”-”, ””, “(blank)”, etc. GroupSettings: Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table. Authentication: Allows you to set the credential information to access the specified SSAS cube. Note: It is applicable only for OLAP data source.

    PivotFieldListDrilledMember

    Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

    PivotFieldListDrilledMembers

    Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

    PivotFieldListEvents<TValue>

    Configures pivot component based events.

    PivotFieldListField

    Allows specific fields associated with field information that can be used while creating fieldlist. The following configurations which are applicable are as follows: Name: Allows you to set the field name which is going to configure while creating the fieldlist. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotFieldListFieldMapping

    Allows specific fields associated with field information that can be used while creating fieldlist. The following configurations which are applicable are as follows: Name: Allows you to set the field name which is going to configure while creating the fieldlist. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotFieldListFilter

    Allows to filter the values in other axis based on the collection of filter fields in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotFieldListFilters

    Allows to filter the values in other axis based on the collection of filter fields in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotFieldListFilterSetting

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    PivotFieldListFilterSettings

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    PivotFieldListFormatSetting

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the Format property to be C.

    PivotFieldListFormatSettings

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the Format property to be C.

    PivotFieldListGroupSetting

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    PivotFieldListGroupSettings

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    PivotFieldListRow

    Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field.

    PivotFieldListRows

    Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotFieldListSortSetting

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the EnableSorting property to be true.

    PivotFieldListSortSettings

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the EnableSorting property to be true.

    PivotFieldListStyle

    Allows to set the custom styles for the formatting applied values in the pivot table.

    PivotFieldListTemplates

    Configures pivot component templates.

    PivotFieldListValue

    Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source. BaseField: Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source. BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotFieldListValues

    Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source. BaseField: Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source. BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotFieldListValueSortSettings

    Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

    PivotFieldOptions

    Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source. BaseField: Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source. BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotFilterSetting

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    PivotFormatSetting

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the Format property to be C.

    PivotGroupSetting

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    PivotPagerTemplateContext

    Represents the context for Template that provides the pivot table's rows and columns page information, such as current page, page size, and total number of pages.

    PivotPieChartCenter

    Pivot accumulation chart center.

    PivotReportInfo

    Defines the report name that used to create, load, rename save and save as current report.

    PivotSortSetting

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the EnableSorting property to be true.

    PivotTableCheckboxSelectionType

    Defines modes of checkbox Selection. They are: Default - Allows multiple rows to be selected by clicking rows one by one. ResetOnRowClick - Allows to reset the previously selected row when a row is clicked and multiple rows can be selected by using CTRL or SHIFT key.

    PivotTableClipMode

    Defines the cell content's overflow mode. The available modes are Clip - Truncates the cell content when it overflows its area. Ellipsis - Displays ellipsis when the cell content overflows its area. EllipsisWithTooltip - Displays ellipsis when the cell content overflows its area also it will display tooltip while hover on ellipsis applied cell.

    PivotTableContextMenuItem

    Defines the pivot table context menu items. They are Drillthrough - Enables drill through for the cell. Expand - Expands the cell. Collapse - Collapse the cell. CalculatedField - Enables calculated field for the pivot grid. Pdf Export - Export the grid as Pdf format. Excel Export - Export the grid as Excel format. Csv Export - Export the grid as CSV format. Sort Ascending - Sort the current column in ascending order. Sort Descending - Sort the current column in descending order. Aggregate - Sets aggregate type to sum.

    PivotTableGridLine

    Defines modes of GridLine, They are Both - Show both the vertical and horizontal line in the Grid. None - Hide both the vertical and horizontal line in the Grid. Horizontal - Shows the horizontal line only in the Grid. Vertical - Shows the vertical line only in the Grid. Default - Shows the grid lines based on the theme.

    PivotTablePrintMode

    Print mode options are AllPages - Print all pages records of the Grid. CurrentPage - Print current page records of the Grid.

    PivotTableSelectionType

    Defines types of Selection. They are: Single - Allows the user to select a row or cell on their own in the pivot table. Multiple - Allows the user to select multiple rows or columns or cells in the pivot table.

    PivotToolbarInfo

    Defines the current toolbar information such as current display options and its settings such as chart settings, grid settings, etc.

    PivotTooltipTemplateContext

    Pivot tooltip template context.

    PivotValueSortSettings

    Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

    PivotViewAuthentication

    Allows you to set the credential information to access the specified SSAS cube.

    It is applicable only for OLAP data source.

    PivotViewCalculatedFieldSetting

    Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    PivotViewCalculatedFieldSettings

    Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

    PivotViewCellEditSettings

    Allow options for performing CRUD operations, such as add, edit, delete, and update the raw items of any cell from the pivot table. The raw items can be viewed in a data grid that used to be displayed as a dialog by double-clicking the appropriate value cell in the pivot table. CRUD operations can be performed in this data grid either by double-clicking the cells or using toolbar options. The options available are as follows: AllowAdding: Allows you to add a new record to the data grid used to update the appropriate cells in the pivot table. AllowEditing: Allows you to edit the existing record in the data grid that used to update the appropriate cells in the pivot table. AllowDeleting: Allows you to delete the existing record from the data grid that used to update the appropriate cells in the pivot table. AllowCommandColumns: Allows an additional column appended in the data grid layout holds the command buttons to perform the CRUD operations to edit, delete, and update the raw items to the data grid that used to update the appropriate cells in the pivot table. Mode: Allow options for performing CRUD operations with different modes in the data grid that used to update the appropriate cells in the pivot table. The available modes are normal, batch and dialog. Normal mode is enabled for CRUD operations in the data grid by default. AllowEditOnDblClick: Allows you to restrict CRUD operations by double-clicking the appropriate value cell in the pivot table. ShowConfirmDialog: Allows you to show the confirmation dialog to save and discard CRUD operations performed in the data grid that used to update the appropriate cells in the pivot table. ShowDeleteConfirmDialog: Allows you to show the confirmation dialog to delete any records from the data grid.

    PivotViewColumn

    Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in column axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in column axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field.

    PivotViewColumns

    Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in column axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in column axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotViewConditionalFormatSetting

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    PivotViewConditionalFormatSettings

    Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

    PivotViewConditionalSetting

    Allow options for setting the visibility of hyperlink based on specific condition. The options available here are as follows: Measure: Allows you to specify the value field caption to get visibility of hyperlink option for specific measure. Condition: Allows you to choose the operator type such as equals, greater than, less than, etc. Value1: Allows you to set the start value. Value2: Allows you to set the end value. This option will be used by default when the operator Between and NotBetween is chosen to apply.

    PivotViewConditionalSettings

    Allow options for setting the visibility of hyperlink based on specific condition. The options available here are as follows: Measure: Allows you to specify the value field caption to get visibility of hyperlink option for specific measure. Condition: Allows you to choose the operator type such as equals, greater than, less than, etc. Value1: Allows you to set the start value. Value2: Allows you to set the end value. This option will be used by default when the operator Between and NotBetween is chosen to apply.

    PivotViewCustomGroup

    It allows to set the custom group information to create custom group fields.

    It is applicable only for custom grouping.

    PivotViewCustomGroups

    It allows to set the custom group information to create custom group fields.

    It is applicable only for custom grouping.

    PivotViewDataSourceSettings<TValue>

    Allows the following pivot report information such as rows, columns, values, filters, etc., that are used to render the pivot table and field list. Catalog: Allows to set the database name of SSAS cube as string type that used to retrieve the data from the specified connection string. Note: It is applicable only for OLAP data source. Cube: Allows you to set the SSAS cube name as string type that used to retrieve data for pivot table rendering. Note: It is applicable only for OLAP data source. ProviderType: Allows to set the provider type to identify the given connection is either Relational or SSAS to render the pivot table and field list. Url: Allows to set the URL as string type, which helps to identify the service endpoint where the data are processed and retrieved to render the pivot table and field list. Note: It is applicable only for OLAP data source. LocaleIdentifier: Allows you to set the specific culture code as number type to render pivot table with desired localization. By default, the pivot table displays with culture code 1033, which indicates "en-US" locale. Note: It is applicale only for OLAP data source. DataSource: Allows you to set the data source as JSON collection to the pivot report either from local or from remote server to the render the pivot that and field list. You can fetch JSON data from remote server by using DataManager. Note: It is applicable only for relational data source. Rows: Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. Columns: Allows specific fields associated with field information that needs to be displayed in column axis of pivot table. Values: Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. Filters: Allows to filter the values in other axis based on the collection of filter fields in pivot table. ExcludeFields: Allows you to restrict the specific field(s) from displaying it in the field list UI. You may also be unable to render the pivot table with this field(s) by doing so. Note: It is applicable only for relational data source. ExpandAll: Allows you to either expand or collapse all the headers that are displayed in the pivot table. By default, all the headers are collapsed in the pivot table. Note: It is applicable only for Relational data. ValueAxis: Allows you to set the value fields that to be plotted either in row or column axis in the pivot table. FilterSettings: Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table. SortSettings: Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the enableSorting property to be true. EnableSorting: Allows to perform sort operation to order members of a specific fields either in ascending or descending that used to be displayed in the pivot table. FormatSettings: Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C. DrilledMembers: Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table. ValueSortSettings: Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order. CalculatedFieldSettings: Allows to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table. AllowMemberFilter: Allows to perform filter operation based on the selective filter members of the specific fields used to be displayed in the pivot table. AllowLabelFilter: Allows to perform filter operation based on the selective headers used to be displayed in the pivot table. AllowValueFilter: Allows to perform filter operation based only on value fields and its resultant aggregated values over other fields defined in row and column axes that used to be displayed in the pivot table. ShowSubTotals: Allows to show or hide sub-totals in both rows and columns axis of the pivot table. ShowRowSubTotals: Allows to show or hide sub-totals in row axis of the pivot table. ShowColumnSubTotals: Allows to show or hide sub-totals in column axis of the pivot table. ShowGrandTotals: Allows to show or hide grand totals in both rows and columns axis of the pivot table. ShowRowGrandTotals: Allows to show or hide grand totals in row axis of the pivot table. ShowColumnGrandTotals: Allows to show or hide grand totals in column axis of the pivot table. GrandTotalsPosition: Allows the grand totals to be displayed in either the top or bottom position in the pivot table's row and column axis.By default, the grand totals are displayed at the bottom of the pivot table's row and column axis. SubTotalsPosition: Gets or sets an enum value that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table. Note: By default, the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table. ShowHeaderWhenEmpty: Allows the undefined headers to be displayed in the pivot table, when the specific field(s) are not defined in the raw data. For example, if the raw data for the field ‘Country’ is defined as “United Kingdom” and “State” is not defined means, it will be shown as “United Kingdom >> Undefined” in the header section. AlwaysShowValueHeader: Allows to show the value field header always in pivot table, even if it holds a single field in the value field axis. ConditionalFormatSettings: Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions. EmptyCellsTextContent: Allows to show custom string to the empty value cells that used to display in the pivot table. You can fill empty value cells with any value like “0”, ”-”, ””, “(blank)”, etc. GroupSettings: Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table. ShowAggregationOnValueField: Allows the pivot button with specific value field caption along with the aggregation type, to be displayed in the grouping bar and field list UI. For example, if the value field "Sold Amount" is aggregated with Sum, it will be displayed with caption "Sum of Sold Amount" in its pivot button. Authentication: Allows you to set the credential information to access the specified SSAS cube. Note: It is applicable only for OLAP data source.

    PivotViewDisplayOption

    Allow options to configure the view port as either pivot table or pivot chart or both table and chart. The options available are: View: Allows you to choose the view port as either pivot table or pivot chart or both table and chart. Primary: Allows you to set the primary view to be either pivot table or pivot chart. To use this option, it requires the property view to be Both.

    PivotViewDrilledMember

    Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

    PivotViewDrilledMembers

    Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table.

    PivotViewEvents<TValue>

    Configures pivot view events.

    PivotViewField

    Allows specific fields associated with field information that can be used while creating fieldlist. The following configurations which are applicable are as follows: Name: Allows you to set the field name which is going to configure while creating the fieldlist. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotViewFieldMapping

    Allows specific fields associated with field information that can be used while creating fieldlist. The following configurations which are applicable are as follows: Name: Allows you to set the field name which is going to configure while creating the fieldlist. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotViewFilter

    Allows to filter the values in other axis based on the collection of filter fields in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotViewFilters

    Allows to filter the values in other axis based on the collection of filter fields in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotViewFilterSetting

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    PivotViewFilterSettings

    Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table.

    PivotViewFormatSetting

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the Format property to be C.

    PivotViewFormatSettings

    Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the Format property to be C.

    PivotViewGridSettings

    Allows the set of options to customize rows, columns, values cell and its content in the pivot table. The following options to customize the pivot table are: Height: Allow the height of the pivot table content to be set, meaning that the height given should be applied without considering the column headers in the pivot table. Width: Allow to set width of the pivot table. Note: The pivot table will not display less than 400px, as it is the minimum width to the component. GridLines: Allow the options for customizing the cell borders of each cell to be displayed in the pivot table. For example, to display a pivot table without cell borders, set the property gridLines to None. AllowTextWrap: Allow the contents of the cells to be wrapped when they exceed the width of the cells in the pivot table. textWrapSettings: Allows options to wrap either column and row header or value or both header and cell content. For example, to allow the wrap option to value cells alone, then set the property wrapMode to Content in the textWrapSettings class. AllowReordering: Allows to reorder a specific column header from one index to another index in the pivot table by drag-and-drop. AllowResizing: Allows the columns to be resized by clicking and dragging the right edge of the column headers. RowHeight: Allow to set height to the pivot table rows commonly. ColumnWidth: Allow to set width to the pivot table columns commonly. ClipMode: Allows the contents of the cell overflow to be displayed in the pivot table. For example, to truncate the cell content of a cell when it overflows with respect to its cell width, set the property clipMode to Clip. AllowSelection: Allows a row or column or cell to be highlighted by simply clicking or arrow key in the pivot table. SelectionSettings: Allow set of options to customize the selection of a row or column or cell by simply clicking on the arrow key in the pivot table. For example, to highlight both rows and columns with multiple selection, set the properties mode to Both and type to Multiple in selectionSettings class. SelectedRowIndex: Allows to highlight specific row in the pivot table during initial rendering. For example, to highlight the pivot table's first row, set the property selectedRowIndex to 0. ContextMenuItems: Allows to show built-in context with pre-defined menu option or custom menu options by simply right clicking on the pivot table cell.

    PivotViewGroupingBarSettings

    Allows a set of options for customizing the grouping bar UI with a variety of settings such as UI visibility to a specific view port, customizing the pivot button features such as filtering, sorting, changing aggregate types, removing any fields. The options available to customize the grouping bar UI are: ShowFilterIcon: Allows you to show or hide the filter icon that used to be displayed on the pivot button of the grouping bar UI. This filter icon is used to filter the members of a particular field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon that used to be displayed in the pivot button of the grouping bar UI. This sort icon is used to order members of a particular fields either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon that used to be displayed in the pivot button of the grouping bar UI. This remove icon is used to remove any field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon that used to be displayed in the pivot button of the grouping bar UI. This value type icon helps to select the appropriate aggregation type to value fields at runtime. DisplayMode: Allow options to show the grouping bar UI to specific view port such as either pivot table or pivot chart or both table and chart. For example, to show the grouping bar UI to pivot table on its own, set the property displayMode to Table. AllowDragAndDrop: Allows you to restrict the pivot buttons that were used to drag on runtime in the grouping bar UI. This will prevent you from modifying the current report.

    PivotViewGroupSetting

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    PivotViewGroupSettings

    Allows specific fields to group their data on the basis of their type. For example, the date type fields can be formatted and displayed based on year, quarter, month, and more. Likewise, the number type fields can be grouped range-wise, such as 1-5, 6-10, etc. You can perform custom group to the string type fields that used to displayed in the pivot table.

    PivotViewHyperlinkSettings

    Allow a set of options to display a hyperlink to link data for individual cells that are shown in the pivot table. These options allow you to enable a separate hyperlink for row headers, column headers, value cells, and summary cells in the HyperlinkSettings class. The options available are: ShowHyperlink: Allows you to set the visibility of hyperlink in all cells. ShowRowHeaderHyperlink: Allows you to set the visibility of hyperlink in row headers. ShowColumnHeaderHyperlink: Allows you to set the visibility of hyperlink in column headers. ShowValueCellHyperlink: Allows you to set the visibility of hyperlink in value cells. ShowSummaryCellHyperlink: Allows you to set the visibility of hyperlink in summary cells. HeaderText: Allows you to set the visibility of hyperlink based on header text. ConditionalSettings: Allows you to set the visibility of hyperlink based on specific condition. CssClass: Allows you to add CSS class name to the hyperlink options.

    PivotViewPagerSettings

    Represents a class that allows configuring the paging UI option with a variety of settings, such as UI position, template and visibility to a specific axis info, such as page size and paging data.

    PivotViewPageSettings

    Represents a class that allows configuring the page information such as page size and current page details for each axis in order to display the pivot table with a specific page when paging.

    PivotViewRow

    Allows specific fields associated with field information that needs to be displayed in row axis of pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. ShowNoDataItems: Allows you to display all members items of a specific field to the pivot table, even doesn't have any data in its row/column intersection in data source. Note: It is applicable only for relational data source. ShowSubTotals: Allows to show or hide sub-totals to a specific field in row axis of the pivot table. IsNamedSet: Allows you to set whether the specified field is a named set or not. In general, the named set is a set of dimension members or a set expression (MDX query) to be created as a dimension in the SSAS OLAP cube itself. Note: It is applicable only for OLAP data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowFilterIcon: Allows you to show or hide the filter icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This filter icon is used to filter the members of a specified field at runtime in the pivot table. ShowSortIcon: Allows you to show or hide the sort icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This sort icon is used to order members of a specified field either in ascending or descending at runtime. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotViewRows

    Configures row fields in the pivot table.

    PivotViewSelectionSettings

    Allows set of options to customize the selection of a row or column or cell by simply clicking on the arrow key in the pivot table. The options available are: Mode - Allow options to highlight either row wise or column wise or specific cells in the pivot table. For expample, to highlight the columns, set the property modeto Column.CellSelectionMode: Allow options to customize the mode of selection to highlight either row wise or column wise or specific cell in the pivot table. For example, to apply the selection that includes in between cells of rows within the range, set the property cellSelectionModeto Box.Type: Allow options to customize the selection type to highlight either row wise or column wise or specific cell in the pivot table. For example, to highlight multiple rows or columns or cells, set the property typeto Multiple.CheckboxOnly: Allows the selection options to highlight the rows in the pivot table using checkbox selection on their own. persistSelection: Allows you to keep selections in rows or columns or cells while performing all operations in the pivot table. CheckboxMode: Allow options to customize the checkbox selection mode in the pivot table. For example, to select multiple rows one by one through simple clicking on rows, set the property checkboxModeto Default.EnableSimpleMultiRowSelection`: Allows to perform multiple selection in rows with single clicks without using SHIFT or CTRL keys.

    PivotViewSortSetting

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the EnableSorting property to be true.

    PivotViewSortSettings

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table. By default, the data source containing fields are display with Ascending order alone. To use this option, it requires the EnableSorting property to be true.

    PivotViewStyle

    Allows to set the custom styles for the formatting applied values in the pivot table.

    PivotViewTemplates

    Configures pivot component templates.

    PivotViewTextWrapSettings

    Allows the options for customizing the content of the cells to be wrapped in either rows and column headers or values or both headers and values in the pivot table. For example, to wrap the contents of the value cells in the pivot table, then set the property WrapMode to Content in the textWrapSettings class. The options available are: Both: Allows the content of the cells to be wrapped in both headers and values. Header: Allows the content of the cells to be wrapped in rows and column headers alone. Content: Allows the content of the cells to be packed for the value cells alone.

    PivotViewValue

    Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source. BaseField: Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source. BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. ExpandAll: Allows you to expand or collapse all of the pivot table's headers for a specific field. This will prevent you from modifying the current report.

    PivotViewValues

    Allows specific fields associated with field information that needs to be displayed as aggregated numeric values in pivot table. The following configurations which are applicable are as follows: Name: Allows you to set the field name that needs to be displayed in row/column/value/filter axis of pivot table. Caption: Allows you to set caption to the specific field. It will be used to display instead of its name in pivot table component's UI. Type: Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… Note: It is applicable only for relational data source. BaseField: Allows you to set the selective field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom or PercentageOfParentTotal aggregate types. Note: It is applicable only for relational data source. BaseItem: Allows you to set the selective item of a specific field, which used to display the values with either DifferenceFrom or PercentageOfDifferenceFrom aggregate types. The selective item should be set the from field specified in the baseField property. Note: It is applicable only for relational data source. IsCalculatedField: Allows to set whether the specified field is a calculated field or not. In general, the calculated field is created from the bound data source or using simple formula with basic arithmetic operators in the pivot table. Note: It is applicable only for OLAP data source. ShowRemoveIcon: Allows you to show or hide the remove icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This remove icon is used to remove the specified field during runtime. ShowValueTypeIcon: Allows you to show or hide the value type icon of a specific field that used to be displayed in the pivot button of the grouping bar and field list UI. This value type icon helps to select the appropriate aggregation type to specified value field at runtime. ShowEditIcon: Allows you to show or hide the edit icon of a specific field that used to be displayed on the pivot button of the grouping bar and field list UI. This edit icon is used to modify caption, formula, and format of a specified calculated field at runtime that to be displayed in the pivot table. AllowDragAndDrop: Allows you to restrict the specific field's pivot button that is used to drag on runtime in the grouping bar and field list UI. This will prevent you from modifying the current report.

    PivotViewValueSortSettings

    Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

    PivotViewVirtualScrollSettings

    Represents a class that allows defining values for options relating to the virtual scrolling experience in the pivot table.

    Primary

    Allows you to set the primary view to be either table or chart.The available options are: Table - Allows you to display the pivot table as primary view. Chart - Allows you to display the pivot chart as primary view.

    ProviderType

    Allows to set the provider type to identify the given connection is either Relational or SSAS to render the pivot table and field list. The following options are: Relational - Allows to render the pivot table with JSON data collection either fetch at local or remote server. SSAS - Allows to render the pivot table with OLAP data fetch from OLAP cube.

    RemoveReportArgs

    The remove report event arguments provides the necessary information to remove the report.

    RenameReportArgs

    The rename report event arguments provides the necessary information to rename the report.

    SaveReportArgs

    The save report event arguments provides the necessary information to save the report.

    SelectionMode

    Defines mode of selection. They are Cell - Defines SelectionMode to Cell. Row - Defines SelectionMode to Row. Column - Defines SelectionMode to Column. Both - Defines SelectionMode to both Row and Column.

    SelectionSettings

    Defines the cell selection settings.

    ServiceInvokedEventArgs

    Provides data for the ServiceInvoked event, triggered after the server has processed a service request. This includes the action that was performed, the response data returned by the server, and the option to cancel further processing.

    ServiceInvokeEventArgs

    Provides data for the ServiceInvoking event, triggered before a service request is sent from the Pivot Table to the server. This includes information about the action being performed, the current report configuration, and any custom parameters used for the request.

    SfPivotFieldList<TValue>

    PivotFieldlist JS interop adaptor.

    SfPivotView<TValue>

    The PivotView component is used to read both OLAP and Relational datasource, allows to create multi-dimensional views for analysis and satisfying business user needs.

    Sort

    Allows specific fields associated with sort settings to order their members either in ascending or descending that used to be displayed in the pivot table.

    Sorting

    Allows to apply sorting to the specified field either by ascending or descending or JSON order. The types are, Ascending - Allows to display the field members in ascending order. Descending - Allows to display the field members in descending order. None - It allows to display the field members based on JSON order.

    Style

    Allows the style information to cusotmize the pivot table cell apprearance.

    SubTotalsPosition

    Specifies different types of positions that will allow the row and column sub-totals to be displayed at the top or bottom of the header group in the pivot table. The options available are: Auto - Defines the row and column sub-totals to be displayed in their default positions, i.e., the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table. Top - Defines the row and column sub-totals to be displayed at the top of the header group in the pivot table. Bottom - Defines the row and column sub-totals to be displayed in bottom of the header group in the pivot table. Note: By default, the column sub-totals are displayed at the bottom and row sub-totals are displayed at the top of their header group in the pivot table.

    SummaryTypes

    Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, Sum - Allows to display the pivot table values with sum. Product - Allows to display the pivot table values with product. Count - Allows to display the pivot table values with count. DistinctCount - Allows to display the pivot table values with distinct count. Min - Allows to display the pivot table with minimum value. Max - Allows to display the pivot table with maximum value. Avg - Allows to display the pivot table values with average. Index - Allows to display the pivot table values with index. PopulationStDev - Allows to display the pivot table values with population standard deviation. SampleStDev - Allows to display the pivot table values with sample standard deviation. PopulationVar - Allows to display the pivot table values with population variance. SampleVar - Allows to display the pivot table values with sample variance. RunningTotals - Allows to display the pivot table values with running totals. DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field. PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field. PercentageOfGrandTotal - Allows to display the pivot table values with percentage of grand total of all values. PercentageOfColumnTotal - Allows to display the pivot table values in each column with percentage of total values for the column. PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row. PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field. PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column. PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row. CalculatedField - Allows to display the pivot table with calculated field values. It allows user to create a new calculated field alone.

    ToolbarArgs

    The toolbar event arguments provides the necessary information to customize options of the toolbar creating.

    ToolbarItems

    Allows the built-in toolbar options that used to access features like switching between pivot table and pivot chart, changing chart types, conditional formatting, number formatting, exporting, etc… with ease at runtime. The available toolbar options are: New - Allows to create a new report. Save - Allows to save the current report. Save As - Allows to perform save as the current report. Rename - Allows to rename the current report. Remove - Allows to delete the current report. Load - Allows to load any report from the report list. Grid - Allows to show the pivot table. Chart - Allows to show the pivot chart with specific type from the built-in list. Exporting - Allow set of options to export the pivot table as PDF/Excel/CSV and the pivot chart as PDF and image format such as PNG, JPEG, SVG. Sub-total - Allow set of options to show or hide the sub totals in the pivot table. The subtotals will not be displayed in the pivot chart by default. Grand Total - Allow set of options to show or hides the grand totals in the pivot table. By default, the grand totals will not be displayed in the pivot chart. Conditional Formatting - Allows to show the conditional formatting pop-up to apply formatting to the values. Number Formatting - Allows to show the number formatting pop-up to apply number formatting to the values. Formatting - Allow options to show the conditional formatting and the number formatting pop-up that used to apply formatting to the values in the component. Field List - Allows you to show the field list pop-up. It allows you to modify the report with a variety of actions such as re-arrange the fields between axes by drag-and-drop, add new fields to report, remove any fields from report, filtering and sorting a specific field members, etc., that are used to update the pivot table during runtime. MDX - Allows ro show the MDX query that was run to retrieve data from the OLAP data source. Note: It is applicable only for OLAP data source.

    ValueOperators

    Defines the conditional operators for value type fields. They are Equals - Display the pivot table that matches with the given text or value or date. DoesNotEquals - Display the pivot table that does not match with the given text or value or date. GreaterThan - Display the pivot table when the text or value is greater. GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal. LessThan - Display the pivot table when the text or value is lesser. LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal. Between - Display the pivot table that records between the start and end text or value or date. NotBetween - Display the pivot table that does not record between the start and end text or value or date.

    ValueSortSettings

    Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

    View

    It defines the view port as either table or chart or both table and chart. The available options are: Table - To render the component as tabular form. Chart - To render the component as graphical format. Both - To render the component as both table and chart.

    WrapMode

    Defines the wrap mode for pivot table.
    Both - Wraps both the header and content.
    Header - Wraps header alone.
    Content - Wraps content alone.

    Interfaces

    IPivotFieldList

    Interface for Pivot Fieldlist.

    IPivotFieldListDataSourceSettings

    Interface for Pivot Fieldlist datasource settings.

    IPivotView

    Interface for pivot view.

    IPivotViewDataSourceSettings

    Interface for Pivotview Datasourcesettings.

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