Blogs

Thinking Out Loud

WinForms Pivot Grid Control Enhancements (coming in v2011 vol 2)

     

With this release, we'll be extending the capabilities of our WinForms Pivot Grid with the following new features:

To improve easy-of-use, filter drop-downs within the DevExpress WinForms Pivot are now able to ignore field values that cannot be displayed because of filters applied to other fields. (view animation to learn more)

WinForms Pivot Grid and Table Control 

To facilitate and improve the way in which end-users construct filters, the WinForms Pivot Grid will include a toolbar designed to unify control over all aspects of the filter. This includes settings and commands you may be familiar with (like filter type setting or invert filter command), as well as the newly introduced Display Only Available Items.

WinForms Pivot Grid Filter Toolbar
 

 

Published Sep 27 2011, 01:21 PM by Ray Navasarkian (DevExpress)
Technorati tags: Pivot, analytics, v2011.2, WinForms
Bookmark and Share

Comments

 

Mark Bissett 2 said:

This looks great. The filter toolbar would be useful on the WinForms Grid control so end users could turn on and off the checkboxes next to the filter items, invert the filter etc.

September 27, 2011 4:37 PM
 

Sigurd Decroos said:

^^ agreed +1

September 27, 2011 5:03 PM
 

Peter Thorpe said:

+1 Hopefully a similar menu for the grid control to switch between checked list and list and possibly between value filtering and display member filtering.

September 27, 2011 6:50 PM
 

Brian Maxim said:

-1. The first “new” feature was already done a year ago:

community.devexpress.com/.../windows-forms-pivot-grid-control-using-the-customfilterpopupitems-event-to-manage-filter-items-in-10-2.aspx

We seem to get a lot of filter updates. But improving ease/speed of use will rely on a more powerful pre-filter:

www.devexpress.com/.../S19302.aspx

community.devexpress.com/.../83539.aspx

September 29, 2011 7:46 AM
 

Constant (DevExpress Support) said:

Hi Brian,

In our opinion, this is a really new feature of the XtraPivotGrid, and such a significant improvement of the previously implemented capability that it can be called a new feature. We have found that the solution provided in  version 10.2 does not work well in some situations. You can see this if you play  a bit with the www.devexpress.com/.../E2470.aspx example. So, we decided to provide a more powerful solution, which now works based upon the www.devexpress.com/.../S37209.aspx method.

By the way, I cannot promise anything now, but we will consider implementation of the "Prefilter By Summary" feature regarding the next version of the XtraPivotGrid control (12.1)

October 3, 2011 3:27 AM
 

Brian Maxim said:

Hi Constant,

Woody did hint that this could be in 11.2 so to hear its slipping again and not a definite is disappointing. A lot of your customers need it and a lot of my customers need it. At the moment it really could feature anywhere – 12.1, 12.2, 13.1, 14.2!? or never as its already been some years. It would be nice if this could be upgraded to planned, at least I’ll have something positive to tell my manager who frequently asks about the status of this and then he might just allow me to renew my DX subscription.

October 4, 2011 5:12 AM
 

Constant (DevExpress Support) said:

@Brian

I agree with you that this feature is very important. I am afraid during the current development cycle we did not have resources required for its implementation. In fact, this is a rather complex feature that requires significant source code modification. We will discuss whether or not we have enough resources to implement it in 12.1. Anyway, thank you for pointing us to this suggestion, your opinion is very important for us.

October 7, 2011 4:44 AM
 

Marco Rinaldi_1 said:

Good news!!!

Nice work and now don't stop and do the same improvements for ASPxPivotGrid!! :-)

November 17, 2011 3:41 AM
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.