PivotField.DatabaseSort Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
When set to True, manual repositioning of items in a PivotTable field is allowed. Returns True if the field has no manually positioned items. Read/write Boolean.
public:
property bool DatabaseSort { bool get(); void set(bool value); };public bool DatabaseSort { get; set; }Public Property DatabaseSort As BooleanProperty Value
Remarks
The DatabaseSort property returns False if the data source is not an Online Analytical Processing (OLAP) data source.
This property returns True if the data source is OLAP and neither custom ordering nor automatic sorting has been applied to the field.
Setting the DatabaseSort property to True, for an OLAP PivotTable, will remove any custom ordering or automatic sort applied to the field (in other words, the PivotTable reverts to the default behavior when the connection was made).
Setting the DatabaseSort property to False will cause the sort order to be the current order of the items, if no automatic sort is applied.
Setting the DatabaseSort property to either True or False causes an Update.
Setting the DatabaseSort property to True for a non-OLAP source or an OLAP data field causes a run-time error.