PivotGridOptionsChartDataSourceBase.ProvideRowTotals Property

Gets or sets whether row totals are passed to a chart control.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v21.2.Core.dll

Declaration

C#
VB.NET

[DefaultValue(false)]
public virtual bool ProvideRowTotals { get; set; }

<DefaultValue(False)>
Public Overridable Property ProvideRowTotals As Boolean

Property Value

Type	Default	Description
Boolean	false	true if row totals are displayed in a chart control; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ProvideRowTotals
WinForms Controls	PivotGridControl	.OptionsChartDataSource.ProvideRowTotals
Reporting	XRPivotGrid	.OptionsChartDataSource.ProvideRowTotals
ASP.NET MVC Extensions	MVCxPivotGrid	.OptionsChartDataSource.ProvideRowTotals
ASP.NET MVC Extensions	PivotGridSettings	.OptionsChartDataSource.ProvideRowTotals
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsChartDataSource.ProvideRowTotals

Remarks

In the following image, a chart control creates series for selected PivotGrid rows (the PivotGridOptionsChartDataSourceBase.ProvideDataByColumns property is set to false). The ProvideRowTotals property is set to true, and a series representing the “Austria Total” row is created in a chart control:

Chart_ShowRowTotals_True

If the ProvideRowTotals property is set to false, a series for the “Austria Total” row is not created:

Chart_ShowRowTotals_False

Note

This property is in effect when PivotGridOptionsChartDataSourceBase.DataProvideMode is set to PivotChartDataProvideMode.UseCustomSettings.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ProvideRowTotals property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#
VB.NET

how-to-create-a-custom-chart-data-source-e2520/CS/CustomChartDataSourceWin/CustomChartDataSource.cs#L96

        (!fPivot.OptionsChartDataSource.ProvideRowGrandTotals && cell.RowValueType == PivotGridValueType.GrandTotal) ||
        (!fPivot.OptionsChartDataSource.ProvideRowTotals && cell.RowValueType == PivotGridValueType.Total);
}

how-to-create-a-custom-chart-data-source-e2520/VB/CustomChartDataSourceWin/CustomChartDataSource.vb#L99

Private Function SkipCellValue(ByVal cell As PivotCellEventArgs) As Boolean
    Return ((Not fPivot.OptionsChartDataSource.ProvideColumnCustomTotals) AndAlso cell.ColumnValueType = PivotGridValueType.CustomTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideColumnGrandTotals) AndAlso cell.ColumnValueType = PivotGridValueType.GrandTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideColumnTotals) AndAlso cell.ColumnValueType = PivotGridValueType.Total) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowCustomTotals) AndAlso cell.RowValueType = PivotGridValueType.CustomTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowGrandTotals) AndAlso cell.RowValueType = PivotGridValueType.GrandTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowTotals) AndAlso cell.RowValueType = PivotGridValueType.Total)
End Function

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

PivotGridOptionsChartDataSourceBase.ProvideRowTotals Property

Declaration

Property Value

Property Paths

Remarks

PivotGridOptionsChartDataSourceBase.ProvideRowTotals Property

Declaration

Property Value

Property Paths

Remarks

Related GitHub Examples