By default, the PivotBarVisible property is exPivotBarDefault, which is a BIT-OR combination of the following values. exPivotBarVisible | exPivotBarSizable | exPivotBarAutoFit | exPivotBarShowTotals | exPivotBarAllowValues | exPivotBarAllowFormatConditionalAppearance | exPivotBarAllowFormatAppearance | exPivotBarAllowFormatContent | exPivotBarAutoUpdate | exPivotBarAllowUndoRedo | exPivotBarAllowResizeColumns. The PivotColumnsFloatBarVisible property indicates whether the control shows a floating panel to display the pivot columns that can be dropped to the control's pivot bar.  The LayoutStartChanging/LayoutEndChanging events notify your application once changes occurs in the control.

The following screen shot shows the control's pivot bar:

 

Use the PivotBarVisible property to specify one or more of the followings:

• shows or hides the control's pivot bar
• allow resizing the control's pivot bar
• show the control's pivot bar to a floating panel
• auto-resize the control's pivot bar so its content fits the client area
• show or hides the total aggregate functions
• enables or disables the Auto-Hide feature, so the pivot bar is shown only when the cursor hovers the pivot bar
• allows or prevents displaying value columns
• prevent showing the appearances or format content to the control's context menu
• shows or hides the Refresh button, in case the grouping of data is time consuming
• enables or disables the control's Undo/Redo feature
• allows or prevents resizing the columns in the pivot bar