Blazor

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class PivotViewDataSourceSettings<TValue>

    Show / Hide Table of Contents

    Class 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.

    Inheritance
    System.Object
    SfBaseComponent
    SfDataBoundComponent
    PivotViewDataSourceSettings<TValue>
    Implements
    IPivotViewDataSourceSettings
    Inherited Members
    SfDataBoundComponent.SetDataManager<T>(Object)
    SfDataBoundComponent.OnAfterRenderAsync(Boolean)
    SfDataBoundComponent.DataManager
    SfDataBoundComponent.MainParent
    SfBaseComponent.Dispose()
    SfBaseComponent.Dispose(Boolean)
    SfBaseComponent.OnObservableChange(String, Object, Boolean, NotifyCollectionChangedEventArgs)
    Namespace: Syncfusion.Blazor.PivotView
    Assembly: Syncfusion.Blazor.dll
    Syntax
    public class PivotViewDataSourceSettings<TValue> : SfDataBoundComponent, IPivotViewDataSourceSettings
    Type Parameters
    Name Description
    TValue

    A type which provides schema for the pivot component.

    Constructors

    PivotViewDataSourceSettings()

    Declaration
    public PivotViewDataSourceSettings()

    Properties

    AllowLabelFilter

    Allows to perform filter operation based on the selective headers used to be displayed in the pivot table.

    Declaration
    public bool AllowLabelFilter { get; set; }
    Property Value
    Type Description
    System.Boolean

    AllowMemberFilter

    Allows to perform filter operation based on the selective filter members of the specific fields used to be displayed in the pivot table.

    Declaration
    public bool AllowMemberFilter { get; set; }
    Property Value
    Type Description
    System.Boolean

    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.

    Declaration
    public bool AllowValueFilter { get; set; }
    Property Value
    Type Description
    System.Boolean

    AlwaysShowValueHeader

    Allows to show the value field header always in pivot table, even if it holds a single field in the value field axis.

    Declaration
    public bool AlwaysShowValueHeader { get; set; }
    Property Value
    Type Description
    System.Boolean

    Authentication

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

    It is applicable only for OLAP data source.

    Declaration
    public PivotViewAuthentication Authentication { get; set; }
    Property Value
    Type Description
    PivotViewAuthentication

    CalculatedFieldSettings

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

    Declaration
    public List<PivotViewCalculatedFieldSetting> CalculatedFieldSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewCalculatedFieldSetting>

    Catalog

    Allows to set the database name of SSAS cube as string type that used to retrieve the data from the specified connection string.

    It is applicable only for OLAP data source.

    Declaration
    public string Catalog { get; set; }
    Property Value
    Type Description
    System.String

    Columns

    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.

    Declaration
    public List<PivotViewColumn> Columns { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewColumn>

    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.

    Declaration
    public List<PivotViewConditionalFormatSetting> ConditionalFormatSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewConditionalFormatSetting>

    Cube

    Allows you to set the SSAS cube name as string type that used to retrieve data for pivot table rendering.

    It is applicable only for OLAP data source.

    Declaration
    public string Cube { get; set; }
    Property Value
    Type Description
    System.String

    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.

    It is applicable only for relational data source.

    Declaration
    public IEnumerable<TValue> DataSource { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.IEnumerable<TValue>

    DataSourceChanged

    Event invokes collapsed in the pivot table.

    Declaration
    public EventCallback<IEnumerable<TValue>> DataSourceChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Collections.Generic.IEnumerable<TValue>>

    DrilledMembers

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

    Declaration
    public List<PivotViewDrilledMember> DrilledMembers { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewDrilledMember>

    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.

    Declaration
    public string EmptyCellsTextContent { get; set; }
    Property Value
    Type Description
    System.String

    EnableServerSideAggregation

    Gets or sets a value indicating whether the pivot table retrieves the data source that is already populated on the server-side with grouping and aggregation performed on the server.

    Declaration
    public bool EnableServerSideAggregation { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the pivot table retrieves the data source that is already populated on the server-side with grouping and aggregation performed on the server. In this case, the data source is retrieved from the server and grouping and aggregation actions are performed on the server itself. Only the aggregated data is returned to the pivot table to render, providing the best performance in WebAssembly (WASM) environments where only the aggregated data is passed from server to client. false if the grouping and aggregation are performed on the client-side. The default value is false.

    Remarks

    Setting this property to true can improve performance when dealing with large data sets since the data aggregation is performed on the server-side.

    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.

    Declaration
    public bool EnableSorting { get; set; }
    Property Value
    Type Description
    System.Boolean

    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.

    It is applicable only for relational data source.

    Declaration
    public string[] ExcludeFields { get; set; }
    Property Value
    Type Description
    System.String[]

    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.

    It is applicable only for Relational data.

    Declaration
    public bool ExpandAll { get; set; }
    Property Value
    Type Description
    System.Boolean

    FieldMapping

    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.

    Declaration
    public List<PivotViewField> FieldMapping { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewField>

    Filters

    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.

    Declaration
    public List<PivotViewFilter> Filters { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewFilter>

    FilterSettings

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

    Declaration
    public List<PivotViewFilterSetting> FilterSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewFilterSetting>

    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.

    Declaration
    public List<PivotViewFormatSetting> FormatSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewFormatSetting>

    GrandTotalsPosition

    Allows the grand totals to be displayed in either the top or bottom position in the pivot table's row and column axis. The options available are:

    • BottomAllows the grand totals to be displayed in bottom position in the pivot table's row and column axis.
    • TopAllows the grand totals to be displayed in top position in the pivot table's row and column axis.
    Declaration
    public GrandTotalsPosition GrandTotalsPosition { get; set; }
    Property Value
    Type Description
    GrandTotalsPosition

    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.

    Declaration
    public List<PivotViewGroupSetting> GroupSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewGroupSetting>

    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.

    It is applicale only for OLAP data source.

    Declaration
    public double LocaleIdentifier { get; set; }
    Property Value
    Type Description
    System.Double

    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.

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

    Rows

    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.

    Declaration
    public List<PivotViewRow> Rows { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewRow>

    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.

    Declaration
    public bool ShowAggregationOnValueField { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowColumnGrandTotals

    Allows to show or hide grand totals in column axis of the pivot table.

    Declaration
    public bool ShowColumnGrandTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowColumnGrandTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowColumnGrandTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    ShowColumnSubTotals

    Allows to show or hide sub-totals in column axis of the pivot table.

    Declaration
    public bool ShowColumnSubTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowColumnSubTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowColumnSubTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    ShowGrandTotals

    Allows to show or hide grand totals in both rows and columns axis of the pivot table.

    Declaration
    public bool ShowGrandTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowGrandTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowGrandTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    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.

    Declaration
    public bool ShowHeaderWhenEmpty { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowRowGrandTotals

    Allows to show or hide grand totals in row axis of the pivot table.

    Declaration
    public bool ShowRowGrandTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowRowGrandTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowRowGrandTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    ShowRowSubTotals

    Allows to show or hide sub-totals in row axis of the pivot table.

    Declaration
    public bool ShowRowSubTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowRowSubTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowRowSubTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    ShowSubTotals

    Allows to show or hide sub-totals in both rows and columns axis of the pivot table.

    Declaration
    public bool ShowSubTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    ShowSubTotalsChanged

    Gets or sets a callback of the bound value.

    Declaration
    public EventCallback<bool> ShowSubTotalsChanged { get; set; }
    Property Value
    Type Description
    Microsoft.AspNetCore.Components.EventCallback<System.Boolean>

    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.

    Declaration
    public List<PivotViewSortSetting> SortSettings { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewSortSetting>

    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.

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

    Type

    Allows to define the data source type.

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

    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.

    It is applicable only for OLAP data source.

    Declaration
    public string Url { get; set; }
    Property Value
    Type Description
    System.String

    ValueAxis

    Allows you to set the value fields that to be plotted either in row or column axis in the pivot table.

    Declaration
    public string ValueAxis { get; set; }
    Property Value
    Type Description
    System.String

    Values

    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.

    Declaration
    public List<PivotViewValue> Values { get; set; }
    Property Value
    Type Description
    System.Collections.Generic.List<PivotViewValue>

    ValueSortSettings

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

    Declaration
    public PivotViewValueSortSettings ValueSortSettings { get; set; }
    Property Value
    Type Description
    PivotViewValueSortSettings

    Methods

    BuildRenderTree(RenderTreeBuilder)

    Declaration
    protected override void BuildRenderTree(RenderTreeBuilder __builder)
    Parameters
    Type Name Description
    Microsoft.AspNetCore.Components.Rendering.RenderTreeBuilder __builder

    OnInitializedAsync()

    Method invoked when the component is ready to start, having received its initial parameters from its parent in the render tree. Override this method if you will perform an asynchronous operation and want the component to refresh when that operation is completed.

    Declaration
    protected override Task OnInitializedAsync()
    Returns
    Type Description
    System.Threading.Tasks.Task

    A System.Threading.Tasks.Task representing any asynchronous operation.

    Overrides
    SfDataBoundComponent.OnInitializedAsync()

    OnParametersSetAsync()

    Method invoked when the component has received parameters from its parent in the render tree, and the incoming values have been assigned to properties.

    Declaration
    protected override Task OnParametersSetAsync()
    Returns
    Type Description
    System.Threading.Tasks.Task

    A System.Threading.Tasks.Task representing any asynchronous operation.

    Overrides
    SfDataBoundComponent.OnParametersSetAsync()

    ParametersSet()

    Method invoked when the component has received parameters from its parent in the render tree, and the incoming values have been assigned to properties.

    Declaration
    protected Task ParametersSet()
    Returns
    Type Description
    System.Threading.Tasks.Task

    A System.Threading.Tasks.Task representing any asynchronous operation.

    Implements

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