Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotLayout Members

In This Article
Contains various options used to adjust the layout of the PivotTable report.

#Properties

Name Description
CompactNewFields Gets or sets a value indicating whether new fields should have their PivotFieldLayout.Compact property set to true.
DataOnRows Gets or sets a value indicating whether multiple data fields in a pivot table should be displayed in rows down the report.
IndentInCompactForm Gets or sets the indent increment for items from different row fields when a pivot table is shown in compact form.
MergeTitles Gets or sets a value indicating whether to merge and center cells containing item labels for the outer row and column fields, subtotal and grand total captions.
OutlineNewFields Gets or sets a value indicating whether new fields should have their PivotFieldLayout.Outline property set to true.
PageOrder Gets or sets the order in which multiple page fields are displayed in the PivotTable report filter area.
PageWrap Gets or sets the number of page fields to display before starting another column or row based on the PivotLayout.PageOrder property value.
ShowColumnGrandTotals Gets or sets a value indicating whether grand totals should be displayed for columns in the PivotTable report.
ShowRowGrandTotals Gets or sets a value indicating whether grand totals should be displayed for rows in the PivotTable report.
SubtotalIncludeHiddenItems Gets or sets a value indicating whether hidden page field items in a pivot table should be included in subtotals and grand totals.

#Methods

Name Description
HideAllSubtotals() Hides all subtotals in the PivotTable report.
InsertBlankRows() Inserts a blank row after each outer row field item in a pivot table.
RemoveBlankRows() Removes blank rows after items of the outer row fields in a pivot table.
RepeatAllItemLabels(Boolean) Specifies whether to repeat item labels for all outer row and column fields in a pivot table.
SetReportLayout(PivotReportLayout) Applies the specified report layout to a pivot table.
ShowAllSubtotals(Boolean) Displays all subtotals in the PivotTable report.
See Also