DXperience v2008 vol 3: sorting by any column/row in the pivot grid (WinForms)

31 October 2008

This one is for those hard-core types who live and breathe pivot grids (and I'm talking about the end-users here).

In version v2008 vol 3, you can specify the summary columns or rows that can be sorted. At run-time, the user merely has to right-click the column or row header to bring up a context menu and then select the required sorting option.

Since pictures are worth a thousand words, check this out. Here's a pivot grid showing orders generated by the sales people, ordered by month.


I'd really like to see those sales people sorted by order amount for each month. So, I right click on the Order Amount column header:


And select Sort Sales Person by This Column:


That showed the data in ascending order (and note the small icon in the Order Amount column header that shows it's the "sorting data". To show it in descending order, I merely click the Sales Person column header:


3 comment(s)

is this only for the winforms version?

31 October, 2008
Jim Clay

Now that's cool!  When I eventually get our in house app completed, I will be shifting over to do a bunch of pivot grid stuff for the owner...This will be a very nice feature!



31 October, 2008
Polo Capital

Really nice!!!

Possibly the best new features in this release...

Tks a lot guys!

4 November, 2008

Please login or register to post comments.