Represent a pivot grid control which can be used in a report.

Remarks

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.

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.

Appearance, behaviour, data, etc. can all be defined by specifying control’s properties. It is also possible to define everything using a designer. In the designer it is possible to configure fields, layout and appearance options.

To run the designer

1. Select the PivotGrid control on the report.
2. Open Properties window.
3. At the bottom of the window click link Run Designer....

To add PivotGrid to a report

1. In Solution Explorer open the desired MxReport component by double clicking it.
2. Open Toolbox window and expand DX:Reports.vX.X section.
3. Select XRPivotGrid control and drag it to the desired band.
4. Open Properties window.
5. Define the data to display using the control’s wizard or its properties.

To learn more about the control, how to implement it and use it see Developer Express documentation.