PivotGridControl.FieldValueNotExpanded Event

Occurs in OLAP mode, when an end-user clicks an expand button or selects Expand All from the context menu, and the field value cannot be expanded.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v14.2.dll

Declaration

C#

public event PivotFieldValueEventHandler FieldValueNotExpanded

VB.NET

Public Event FieldValueNotExpanded As PivotFieldValueEventHandler

Event Data

The FieldValueNotExpanded event's handler receives an argument of the PivotFieldValueEventArgs type. The following properties provide information specific to this event:

Property	Description
CustomTotal	Gets the custom total which the currently processed column/row header corresponds to.
DataField	Gets the data field which identifies the processed value.
Field	Gets the field being processed. Inherited from PivotFieldEventArgs.
FieldIndex	Gets the field's position among the visible fields within the header area.
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 RoutedEventArgs.
IsCollapsed	Gets whether the processed field value is collapsed.
IsColumn	Gets whether the field is displayed within the Column Header Area.
IsOthersValue	Gets whether the current header corresponds to the "Others" row/column.
MaxIndex	Gets the maximum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.
MinIndex	Gets the minimum row index (for row fields) or column index (for column fields) that corresponds to the field value currently being processed.
OriginalSource	Gets the original reporting source as determined by pure hit testing, before any possible Source adjustment by a parent class. Inherited from RoutedEventArgs.
RoutedEvent	Gets or sets the RoutedEvent associated with this RoutedEventArgs instance. Inherited from RoutedEventArgs.
Selected	Gets whether the processed field value is selected.
Source	Gets or sets a reference to the object that raised the event. Inherited from RoutedEventArgs.
Value	Gets the column field or row field value which the currently processed column/row header corresponds to.
ValueType	Gets the type of the currently processed column/row header.

Remarks

In OLAP binding mode, when the control is bound to a cube on an OLAP server, the pivot grid does not calculate summaries itself. Instead, it delegates all data management and calculations to the server side. The raw data is not downloaded to the client side - only the results of calculations.

When an end-user clicks an expand button or the Expand All context menu item, the pivot grid queries the server for a list of child field values. If there are no child field values associated with the current field value, the field value cannot be expanded, and the FieldValueNotExpanded event is raised. This event can be handled, for example, to display a message that informs a user that the field value cannot be expanded.