in
Forums
Blogs
DevExpress.com
Client Center
Support Center
DevExpress Channel

Thinking Out Loud

WinForms Pivot Table - Updates Coming to the XtraPivotGrid

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.

Published Jul 13 2009, 03:18 PM by Developer Express - Ray
Filed under: ,
Technorati tags: v2009.2, XtraPivotGrid

Comments

 

Cigdem Hiz said:

good news !

July 14, 2009 2:05 AM
 

Microsoft Updates | All Days Long said:

Pingback from  Microsoft Updates | All Days Long

July 14, 2009 5:41 AM
 

Robert Chaffe said:

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?

July 14, 2009 8:43 AM
 

Arturo Martínez said:

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

July 14, 2009 11:41 AM
 

Tomas Mohapl said:

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

July 14, 2009 4:39 PM
 

Bassam Abdelaal said:

Hello,

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

waiting for it for a loooong time!

Bassam

July 15, 2009 9:31 AM
 

Kevin Killion said:

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?

July 15, 2009 10:56 AM
 

Rick Schultz said:

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?

July 15, 2009 4:23 PM
 

Mark Chimes said:

Rick,

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

July 16, 2009 5:55 PM
 

Martin Ehlers said:

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

July 22, 2009 9:55 AM
 

ctodx said:

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

August 20, 2009 8:29 PM

Leave a Comment

(required)  
(optional)
(required)  
Verification code: Required
   
Add
Copyright © 1998-2010 Developer Express Inc.
ALL RIGHTS RESERVED