Pivot control is the most elegant solution for organizing and analyzing business data. The main feature and the biggest advantage of this control is its ability to summarize large amounts of information and represent it in a cross tabulated format. Therefore it is the ultimate tool for creating statistical, financial and other types of reports.
The control is fully customizable, as an end user can easily rearrange the control’s layout using the drag and drop functionality. The result of runtime customization is re-summarizing of business data according to the new layout of the rows and columns.
It is possible to implement automatic summary calculation. Summary can be specified for individual field. Several different types of summary are available such as Count, Sum, Min, Max, Average, etc.
Control also supports filtering data in runtime. For this purposes a pre-filter tool is introduced enabling the end user to create whatever condition on whichever field he wants. Besides the filtering of the data, the data can also be sorted by any field in an ascending or descending order.
Pivot control can also serve as a data provider for a ChartViever control. If chart is connected with Pivot control, there is no need to specify series and axis members. The definition for the chart is already defined in Pivot control. Based on different data selection in the Pivot control, graph is drawn in ChartViewer control. This is yet another huge step towards easy, elegant and efficient data presentation and data analysis.
Designer
Pivot designer is used to define series, column fields, row fields, data fields, etc. By defining series the appearance and the behaviour, of the data displayed in the grid, is determined. To learn more about the designer and how to use it see chapter Pivot Designer.
Control has many properties that define its appearance, design, behaviour etc.
Context Properties
Properties in this section define the appearance of the control in Personalization Directory and the behaviour of the control when in edit mode.
| Property | Description |
|---|---|
| Category | Define the name by which the control is displayed in Personalization Directory. |
| Entity | Defines the name of the group in which the control is located in Personalization Directory. |
| NavigationVisible | The feature is obsolete. |
| TrackDirty | Defines whether user interface can be closed while the control is in edit mode. |
Data Properties
Properties in this section define how and which data is bound to the control.
| Property | Description |
|---|---|
| Adapter | Defines the MxAdapter component from which data can be retrieved and used for any kind of manipulation. |
| DataSourceName | Defines the data source which will be used to display and manipulate data. |
Design Properties
Properties in this section define basic properties of the control, appearance and functionality of the control.
| Property | Description |
|---|---|
| Name | Defines the name of the control or the component. |
NOTE: Properties described here are related exclusively to Mx Controls. For the description of other properties please see Developer Express documentation.
Example (MxSpace)
To see the implementation of Pivot control open MxSpace solution project in Visual Studio. In Solution Explorer expand node Parts and double click WorkOrderAnalysisPart.cs. See the Pivot control used for displaying work order data.
To implement Pivot control
- In Solution Explorer open the desired MxPart component (WorkOrderAnalysisPart) and add Pivot control from the Toolbox on the canvas to a desired location.
- Select the control and open Property Window.
- In Adapter property select the desired adapter.
- In DataSourceName property select the data source containing the field whose value will be displayed.
- In Category property enter the name of the context navigation which will contain menus for working with the control.
- On the canvas right click the control and select option Run Designer.
- In the designer define series, column fields, data fields, etc. To learn more about the designer see chapter Pivot Designer.