PivotGridControl.FieldValueDisplayText Event
Enables you to provide custom text displayed within individual field values or filter dropdown items.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll
NuGet Package: DevExpress.Wpf.PivotGrid
#Declaration
public event PivotFieldDisplayTextEventHandler FieldValueDisplayText
#Event Data
The FieldValueDisplayText event's data class is PivotFieldDisplayTextEventArgs. The following properties provide information specific to this event:
Property | Description |
---|---|
Custom |
Gets the custom total which the currently processed column/row header corresponds to.
Inherited from Pivot |
Data |
Gets the data field that identifies the processed value.
Inherited from Pivot |
Display |
Gets or sets the item’s display text. |
Field |
Gets the field being processed.
Inherited from Pivot |
Field |
Gets the field’s position among the visible fields within the header area.
Inherited from Pivot |
Handled |
Gets or sets a value that indicates the present state of the event handling for a routed event as it travels the route.
Inherited from Routed |
Is |
Gets whether the processed field value is collapsed.
Inherited from Pivot |
Is |
Gets whether the field is displayed within the Column Header Area.
Inherited from Pivot |
Is |
Gets whether the current header corresponds to the “Others” row/column.
Inherited from Pivot |
Is |
Gets whether the current event is called to populate the filter dropdown. |
Max |
Gets the maximum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.
Inherited from Pivot |
Min |
Gets the minimum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.
Inherited from Pivot |
Original |
Gets the original reporting source as determined by pure hit testing, before any possible Source adjustment by a parent class.
Inherited from Routed |
Routed |
Gets or sets the Routed |
Selected |
Gets whether the processed field value is selected.
Inherited from Pivot |
Source |
Gets or sets a reference to the object that raised the event.
Inherited from Routed |
Thread |
Gets the data field that identifies the processed value. Provides read-only access to field settings. |
Thread |
Gets the field being processed. Provides read-only access to field settings. |
Value | Gets the processed item’s value. |
Value |
Gets the type of the currently processed column/row header.
Inherited from Pivot |
The event data class exposes the following methods:
Method | Description |
---|---|
Change |
Changes the expanded state of the field value currently being processed.
Inherited from Pivot |
Create |
Returns a list of records associated with the field value currently being processed.
Inherited from Pivot |
Create |
Returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns, and limit the number of records to be returned.
Inherited from Pivot |
Create |
Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the current cell. Allows you to specify the columns, and limit the number of records to be returned.
Inherited from Pivot |
Create |
Obsolete. In server mode, returns a list of records used to calculate a summary value for the current cell. Allows you to specify the columns, and limit the number of records to be returned.
Inherited from Pivot |
Get |
Returns a value displayed in the specified cell.
Inherited from Pivot |
Get |
Returns the specified column or row field’s value for the cell addressed by its zero-based index in the Data Area.
Inherited from Pivot |
Get |
Returns the parent field |
Get |
Returns the value of a specific parent field corresponding to the field value currently being processed.
Inherited from Pivot |
Invoke |
When overridden in a derived class, provides a way to invoke event handlers in a type-specific way, which can increase efficiency over the base implementation.
Inherited from Routed |
On |
When overridden in a derived class, provides a notification callback entry point whenever the value of the Source property of an instance changes.
Inherited from Routed |
#Remarks
Handle the FieldValueDisplayText event to do the following:
Customize the text displayed within column or row headers (field values, totals, grand totals, etc.).
If the FieldValueDisplayText event is raised for a field value or total header, the Field parameter identifies the corresponding column field or row field. If this event is raised for a data field header, the Field parameter identifies the corresponding data field. If the event is raised for a grand total header, the Field property returns null. To get the type of the processed header, use the PivotFieldValueEventArgs.ValueType property.
- Customize the text of items displayed within the filter dropdown. In this instance, the event parameter’s PivotFieldDisplayTextEventArgs.IsPopulatingFilterDropdown property is set to true. The Field parameter returns the column, row or filter field whose dropdown has been invoked.
To specify a custom display text for a header or filter window’s item, assign the required string to the PivotFieldDisplayTextEventArgs.DisplayText property.
To learn more, see Custom Formatting.
Note
If a field’s Pivot
#Example
The PivotGridControl.FieldValueDisplayText
event allows you to customize field value texts for grand totals.
To do this, check the field value type using the PivotFieldValueEventArgs.ValueType event parameter and provide the required display texts using PivotFieldDisplayTextEventArgs.DisplayText.
private void PivotGridControl_FieldValueDisplayText(object sender, DevExpress.Xpf.PivotGrid.PivotFieldDisplayTextEventArgs e) {
if (e.ValueType == DevExpress.Xpf.PivotGrid.FieldValueType.GrandTotal) {
if (e.IsColumn)
e.DisplayText = "*Custom Column Grand Total*";
else
e.DisplayText = "*Custom Row Grand Total*";
}
}
#Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the FieldValueDisplayText event.
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.