The Pivot Grid module is a comprehensive data analysis, data mining, and visual reporting solution for XAF applications. The module contains List Editors that adapt DevExpress WinForms Pivot Grid and ASP.NET Pivot Grid controls for XAF.
The feature enables you to summarize large amounts of data in a multi-dimensional pivot table where you can sort, group, and filter the data.
End-users can customize the table's layout according to their analysis requirements with simple drag-and-drop operations.
For the Pivot Grid module's demonstration, access the List Editors | PivotGrid section in the Feature Center application supplied with XAF. The Feature Center demo is installed in %PUBLIC%\Documents\DevExpress Demos 19.2\Components\eXpressApp Framework\FeatureCenter by default. The ASP.NET version of this demo is available online at http://demos.devexpress.com/XAF/FeatureCenter/.
Mobile applications do not support the Pivot Grid module.
Set the IPivotSettings.CustomizationEnabled property value depending on your application's prevailing usage scenario.
Choose false if you want to present data to end users in a specific layout. The false setting gives you full control over the pivot table's behavior and prevents users from changing it.
Choose true if end users need to frequently modify the pivot table's data layout. Note that once the user changes the pivot table's settings, they are recorded to the Application Model's top-layer .xafml file and you cannot overwrite them. In some cases, an end user's settings may merge with the modifications the developer specified in lower-level *.xafml files, and cause unpredictable behavior. The end user can get your default settings by right-clicking the pivot table and selecting **Reset View Settings* in the context menu.
The IPivotSettings.Settings property value is a complex XML-formatted string. To manage these settings, click the Settings’ ellipsis button ().
The button invokes the PivotGrid designer that allows you to modify the pivot table's layout and its other preferences.
Pivot Grid Module List Editors
The Pivot Grid module ships with the following List Editors: