Name | Description |
---|---|
Authentication | Allows you to set the credential information to access the specified SSAS cube. > It is applicable only for OLAP data source. |
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. |
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. |
DataSourceSettings | 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.* 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. |
DrillOptions | Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table. |
FieldListFieldOptions | 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: * 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.* axis : Allows you to set the axis name to the specific field. This will help to display the field in specified axis such as row/column/value/filter axis of pivot table.* 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. * baseField : Allows you to set the selective field, which used to display the values with eitherDifferenceFrom 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. * showSubTotals : Allows to show or hide sub-totals to a specific field in row/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. * 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. * expandAll : Allows you to expand or collapse all of the pivot table’s headers for a specific field. |
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: * 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.* axis : Allows you to set the axis name to the specific field. This will help to display the field in specified axis such as row/column/value/filter axis of pivot table.* 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. * baseField : Allows you to set the selective field, which used to display the values with eitherDifferenceFrom 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. * showSubTotals : Allows to show or hide sub-totals to a specific field in row/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. * 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. * expandAll : Allows you to either expand or collapse all of the headers in the pivot table for a specific field. |
Filter | Allows specific fields associated with either selective or conditional-based filter members 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. |
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. |
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. |
Style | Allows the style information to cusotmize the pivot table cell apprearance. |
ValueSortSettings | Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order. |
PivotFieldList | Represents the PivotFieldList component. |
FieldItemInfo | Allows to configure the specific field infomration during UI operation at runtime. |
IAuthenticationInfo | Allows you to set the credential information to access the specified SSAS cube. > It is applicable only for OLAP data source. |
IAxisSet | Allows you to configure the pivot cell information retrieved from the data source. |
ICalculatedFieldSettings | Allows options to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table. |
ICalculatedFields | Configures the specific calculated field infomation. |
IConditionalFormatSettings | 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. |
ICustomGroups | Allows to specify the custom group information of specific field to create custom groups. |
ICustomProperties | Allows you to configure the additional properties from the pivot component to popuplate the pivot engine. |
IDataOptions | 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.* grandTotalsPosition : Allows the grand totals to be position at first position in the row and column 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. * 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. |
IDrillOptions | Allows specific fields used to display their the headers to be either expanded or collapsed in the pivot table. |
IDrilledItem | Allows you to configure the drill information of a specific field item that used to display the pivot table. |
IField | Allows you to configure the information retrieved from the data source for the field list. |
IFieldOptions | 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: |
IFilter | Allows specific fields associated with either selective or conditional-based filter members that used to be displayed in the pivot table. |
IFormatSettings | 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. |
IGroupRange | Allows to configure the group range infomration to perform date and number grouping on specifc fields. |
IGroupSettings | 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. |
IPageSettings | Allows to set the page infomration to display the pivot table with specific page during virual scrolling. |
IPivotValues | It holds the collection of cell information to render the pivot table component. |
ISort | 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. |
IStyle | Allows the style information to cusotmize the pivot table cell apprearance. |
IValueSortSettings | Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order. |
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. |
BeforeExportEventArgs | The before export event arguments provides the necessary information to customize before exporting the file. |
BeforeServiceInvokeEventArgs | The before service invoke event arguments provide the necessary information about the service before it get invoked. |
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. |
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. |
CellTemplateArgs | Defines the cell template information |
ChartSeriesCreatedEventArgs | The chart series created event arguments provide the necessary information about the chart series that used to create the pivot chart. |
ColumnRenderEventArgs | The column render event arguments provide the necessary information about the pivot table column headers before rendering. |
DrillArgs | The drill event arguments provide the necessary information about the pivot cell that performing drill operation. |
DrillThroughEventArgs | The drill-through event arguments provides the necessary information about the cell clicked in the pivot table for drill-through. |
EditCompletedEventArgs | The event argument which holds the editing information of the raw data made in corresponding aggregated cell. |
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. |
ExcelCell | Defines the cell information for excel export |
ExcelColumn | Defines the column on excel export |
ExcelRow | Defines the row on excel export |
ExcelStyles | Defines the style options for excel export |
ExportCompleteEventArgs | The export complete event arguments provide the necessary information about the exported data after completing the file export. |
FetchRawDataArgs | Defines the raw data needs to be updated. |
FetchReportArgs | The fetch report event arguments provides the necessary information to fetch reports from storage. |
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. |
FieldListRefreshedEventArgs | The field list refreshed event arguments provide the necessary information to render the pivot table. |
FieldRemoveEventArgs | The field remove event arguments provide the necessary information about the selected field information before it removes. |
HeadersSortEventArgs | Defines the cusrrent sorting information such as field name, sort order and members which is to be sorted. |
HyperCellClickEventArgs | The hyperlink cell click event arguments provides the necessary information about the cell clicked in the pivot table for hyperlink. |
LoadEventArgs | 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. |
MemberItems | Defines the filter members information that used to render member filter dialog. |
MultiLevelLabelClickEventArgs | The event argument which holds the information of the clicked multi-level label. |
MultiLevelLabelRenderEventArgs | The event argument which holds the information of the multi-level labels that renders. |
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. |
PdfBorder | Defines the border options for PDF export |
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 |
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 andfield list buttons actions such assorting , filtering ,editing ,aggregate type change and so on,CRUD operation in editing in the Pivot Table. |
PivotActionCompleteEventArgs | 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 andfield list buttons actions such assorting , 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 andfield list buttons actions such assorting , filtering ,editing ,aggregate type change and so on,CRUD operation in editing in the Pivot Table. |
PivotActionInfo | Defines the unique information of the current UI action performed such as sorting, filtering, dril, editing, report manipulation, summarization, etc. |
PivotCellSelectedEventArgs | The cell selected event arguments provide the necessary information about the pivot cells that have been selected. |
PivotColumn | Defines the grid columns information that used to render as the pivot table header. |
PivotEditInfo | 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. |
PivotReportInfo | Defines the report name that used to create, load, rename save and save as current report. |
PivotToolbarInfo | Defines the current toolbar information such as current display options and its settings such as chart settings, grid settings, etc. |
QueryCellInfoEventArgs | The query cell event arguments provide the necessary information on each pivot cell rendering in the pivot table. |
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. |
SelectionSettings | Defines the cell selection settings |
ToolbarArgs | The toolbar event arguments provides the necessary information to customize options of the toolbar creating. |
UpdateRawDataArgs | Defines the raw data needs to be fetched. |
Condition | Defines the conditioanal formatting operators. They are |
DataSourceType | Allows to define the data source type. They are, |
DateGroup | Defines group of date field. They are: |
DateOperators | Defines the conditional operators for date type fields. They are |
FilterType | Allows you to set the specific filter type to display the filter members in the pivot table. They are: |
GroupType | Defines the group types. They are: |
LabelOperators | Defines the conditional operators for string type fields. They are |
Operators | Defines the conditional operators for filtering settings. They are |
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: |
RenderMode | Allows to set the mode of rendering the pivot table. They are, |
Sorting | Allows to apply sorting to the specified field either by ascending or descending or JSON order. The types are, |
SummaryTypes | Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, |
ValueOperators | Defines the conditional operators for value type fields. They are |
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. * Median - Allows to display the pivot table values with median. * 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. > It is applicable only for relational data source. |
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. |
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. * 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. * 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. |
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. |
ExportView | Allows the table or chart to be exported in the PDF export document. The available options are: * Table - Determines the pivot table to be exported in the PDF export document. * Chart - Determines the pivot chart to be exported in the PDF export document. |
GrandTotalsPosition | Allows the grand totals to be displayed in either the top or bottom position in the pivot table’s row and column axes. The options available are: * Top: Allows the grand totals to be displayed in top position in 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 axes. |
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. |
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 | Allows the chart series to be displayed, depending on the value fields specified, in either a stacked or single chart area. The options available are: * Stacked: Allows the chart series to be displayed in a separate chart area depending on the value fields specified. * Single: Allows the chart series to be displayed in a single chart area for different value fields. *Combined: Allows to draw 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. > 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. |
PagerPosition | Allows to display the pager UI either at top or bottom of the Pivot Table UI. The options available are: * Top: Allows the pager UI to be displayed in top position of the Pivot Table UI. * Bottom: Allows the pager UI to be displayed in bottom position of the Pivot Table UI. |
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. |
PivotAccumulationChartSelectionMode | Defines the SelectionMode for chart types pie, doughnut, Funnel and pyramid. * none - Disable the selection. * point - To select a point. |
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. |
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. |
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. |
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. * |
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. |
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. |
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. |
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. |
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. * |
PivotChartLegendPosition | Defines the position of the legend. They are * auto - Places the legend based on area type. * top - Displays the legend on the top of chart. * left - Displays the legend on the left of chart. * bottom - Displays the legend on the bottom of chart. * right - Displays the legend on the right of chart. * custom - Displays the legend based on given x and y value. |
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. |
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. |
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 |
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 |
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. |
PivotChartTheme | Defines Theme of the chart. They are * Material - Render a chart with Material theme. * Fabric - Render a chart with Fabric theme. * Bootstrap - Render a chart with Bootstrap theme. * HighContrastLight - Render a chart with HighcontrastLight theme. * MaterialDark - Render a chart with MaterialDark theme. * FabricDark - Render a chart with FabricDark theme. * HighContrast - Render a chart with HighContrast theme. * BootstrapDark - Render a chart with BootstrapDark theme. * Bootstrap4 - Render a chart with Bootstrap4 theme. |
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. |
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 |
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. |
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. |
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. |
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. |
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 available options 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 at the bottom of the header group in the pivot table. |
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. |
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. |