WinForms Pivot Table Control

Filtering by Summary Values

With this release, we have introduced a new Summary Filter that extends your ability to refine data within the pivot grid. When the control is bound to a tabular datasource, the Summary Filter allows you to specify a range of summary values that you would like to see in the report for each data field.

Our new Summary Filter popup window displays the actual distribution of summary values helping you evaluate how many summary values will be shown and hidden by the current filter. In the same distribution chart, you can also see how many of these values are already hidden by Summary Filters (light blue bars).

In addition, you are free to configure summary filtering for any data level: summary, Total or Grand Total values.

Improved OLAP Browsing in Field List

In OLAP mode, the DevExpress WinForms PivotGrid Control automatically retrieves measure groups and folders from the server and displays them in the Field List. KPI measures are now shown within a separate category.

User Folders in Field List

For standard data source mode, this release introduces the ability to arrange fields into user-defined folders in the Field List. To implement this new feature, specify a folder for each field. Whenever the field is displayed in the Field List, it will be shown in the specified folder. As you would expect, you can create folder hierarchies, by placing folders one into another.

Charting Automation Features

When displaying the PivotGrid Control’s data in a chart, you rarely need to compare cell values to Totals or Grand Totals as these values differ significantly. At the same time, when selecting large cell blocks, Total values inevitably appear within the selection. To solve this with previous versions, you had to manually disable a few options that controlled Total value visibility within the bound chart control.

With this release, PivotGrid automatically defines which values should be passed to ChartControl. It analyzes the current selection, finds the lowest-level data and excludes all higher-level Totals. The following animation shows how selection changes are reflected within a bound Chart control.

Yet another new automation feature "rotates" the chart by changing series into arguments and vice versa depending on the current selection. In this mode the control makes sure that the number of series never exceeds the number of arguments.

Filtering by OLAP Member Unique Names

By default, a pivot grid identifies field values by the corresponding OLAP member values. With this release, you can configure the pivot grid to use OLAP member unique names instead. This option is useful if your cube contains several members with the same value, as it enables the pivot grid to distinguish between such members.

Optimized Performance and Memory Consumption for OLAP

The WinForms PivotGrid consumes much less memory when fetching summary values if the layout contains one to three data fields. The query generation engine has also been optimized, giving you up to two times faster performance against certain operations (such as expanding field values).

Simplified OLAP Binding

You no longer need to create data source objects nor reference additional assemblies to bind the pivot grid to OLAP cubes using ADOMD.NET or XMLA. Simply specify the connection string (as you would with OLE DB), and select the required data provider via the newly introduced OLAPDataProvider property.

Improved Best Fit Performance

Best Fit performance has been significantly improved.

Miscellaneous Enhancements

• Improved Top N Values Feature

  We have introduced a new way to define the number of top values to be displayed (an update for the Top N Values feature – available in OLAP mode). You can now specify the maximum allowed sum of the corresponding summary values and the pivot grid will display the maximum number of field values whose summaries do not exceed the specified number in total.

• New Event for Easy Customization of Data Passed to a Chart

  We have introduced a new CustomChartDataSourceRows event that allows you to add, modify and remove specific rows from the chart data source.

• Improved Clipboard Interaction

  We have added several settings that allow you to control clipboard interaction, including the copying of fragmentary multi-selections and field value hierarchies with both collapsed and expanded values.