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.

image

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:

image

And select Sort Sales Person by This Column:

image

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:

image

3 comment(s)
awake

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!

THanks,

Jim

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.