WinForms Pivot Table - Updates Coming to the XtraPivotGrid

13 July 2009

With DXperience v2009 vol 2, we've introduced the following new features/options to our Pivot Grid control.

Excel 2007 Style Customization Window
The XtraPivotGrid's customization window can now mimic the appearance and behavior of Microsoft Excel 2007 Pivot Tables.

WinForms Pivot Table Excel Style Look and Feel

New Filter Dropdown Capabilities
This release extends the Pivot Grid's filter dropdowns with the following new features:

- Incremental Search Support.
- Context menu allowing end-users to inverse the currently applied filter.
- An optional combo box specifying whether to show or hide selected items.
- The capability to select multiple items by pressing the SHIFT or CTRL key. After required items have been selected, their check state can be reversed simultaneously by pressing SPACE.

WinForms Pivot Grid Filter

Suppressing Empty Columns When Displaying Trends
When displaying trends (summary variations), the first column or row in each group is always empty because there are no preceeding values to calculate the difference. You can now suppress these empty cells by toggling a single option.

11 comment(s)
Özgür Dener

good news !

14 July, 2009
Microsoft Updates | All Days Long

Pingback from  Microsoft Updates | All Days Long

14 July, 2009
Robert Chaffe

The Customization window looks nice.  Can source fields be dropped multiple times into the Row or Column area?  Can a field's group interval or any other properties be changed via this dialog?

14 July, 2009
Arturo Martínez

How about implementing this feature in the VCL PivotGrid? It would be great if we Delphites could have these goodies too.

14 July, 2009
Tomas M.

Looks great. Will be there also tree view like in MS Pivot Grid?

14 July, 2009
Bassam Abdelaal


is this all the new features ? will it be any OLAP features ?

waiting for it for a loooong time!


15 July, 2009
Kevin Killion

Since I got to this page by following a link on an email from you, it took me a while to figure out what I was seeing here.  You really should make it clear at the start of the page that this is related to some .NET stuff you have.

The first line on this page says, "we've introduced the following new features/options to our Pivot Grid control." That makes it sound as if this is the ONLY "Pivot Grid" control you have.  I assume that your

ExpressPivotGrid is still supported, right?

15 July, 2009
Rick Schultz

Under "new filter dropdown capabilities" you mention, "Incremental Search".  What is that?  By any chance are you saying that only values currently available (based on existing filters) show up in the filter dropdown?  For example, if you've filtered a "country" field to show only Country = Canada, would you then see, in a "state" field filter dropdown, only Canadian Provinces, or would all values still show?

15 July, 2009
Mark Chimes


That would depend entirely on the structure and relationships between your data.

16 July, 2009
Martin Ehlers

Will it be possible to refresh/update a single cell - not always the whole data bound to the grid?

22 July, 2009

We're just about to release v2009.2 and it would be a good idea to have an "accumulator"

20 August, 2009

Please login or register to post comments.