Sort Groups by Summary (Coming in v2010 vol 2)

DevExpress Data Blog
28 October 2010

There are many times where we would like to sort a report by aggregate data contained in a group. This feature has now been added in v2010.2. The following report is a sales report grouped by product category and sorted by cumulative sales in each category (descending). Take a look:

Sales Report by Categroy

Now when viewing the properties of a group header you have the ability to create a Sorting Summary for the given group. This can be defined directly in the Group Header Band properties or by invoking the Group Sorting Summary Editor with the ellipsis button.

SummaryDialogs


The process for setting it up is straight forward!
  1. Bind your report to a table and/or array of objects
  2. Add a grouping in the Group and Sort property window
  3. Set the  Group Sorting Summary properties as above
GroupProperties

That’s it!


As always, if there are any questions and/or comments please get a hold of me!

Seth Juarez
Email: sethj@devexpress.com
Twitter: @SethJuarez

2 comment(s)
Sigurd Decroos
Sigurd Decroos

Nice addition to the reports!

Please, show us more about embedded Childreports, I'm really waiting for that feature.

28 October, 2010
Mark Bissett 2
Mark Bissett 2

I'll second Sigurd's comment.

29 October, 2010

Please login or register to post comments.