This is a migrated thread and some comments may be shown as answers.

Keep group footer visible

2 Answers 116 Views
Grid
This is a migrated thread and some comments may be shown as answers.
ManniAT
Top achievements
Rank 2
ManniAT asked on 22 Jul 2009, 09:40 PM
Hi,

it's the first time for me that I use RadGrid with grouping.
From a competitors product I know a view where I can show aggregates in the header.
Without (a lot since my columns are dynamic) code behind I see no way to achieve this with RadGrid.

The idea is simple - let's say I have product sales and group them by employee (drag this to the grouping section).
Now (unluckily) I get the expanded view of my items.
But (with code behind) I can change this - as well as I can remove (code behind) grouped fields from the columns.

Let's stay on the default.
I get a footer with my aggregates (in my case about 20 columns - assume "product groups").
So this looks great by theory - in fact I have to scroll for (about) 200-300 rows to find the footer.
Typically you scroll to fast - and oversee it :)

Anyhow - the first important information is in the group footer - there my customer can see "this employee sold only 10 of... but 300 of..."

The problems:
a.) footer is hard to find
b.) footer is hidden when you collapse the grouping.

The best way would be some "Show aggregate in GroupHeader" property.
But I found the group header is a single TD spanning all the columns.

The other solution would be to keep the footer visible when the group is collapsed.
But I found no way to achieve this.

I hope you understand my (my customers) needs.
Grouped view - with Aggregates visible when the group is collapsed.

Regards

Manfred

2 Answers, 1 is accepted

Sort by
0
Sebastian
Telerik team
answered on 28 Jul 2009, 09:16 AM
Hello ManniAT,

You can display the results from aggregate functions as part of the grid header by defining appropriate declarative or programmatic group expressions. See the following topics from the RadGrid online documentation for more details:

http://www.telerik.com/help/aspnet-ajax/grdgroupbydeclarativedefinition.html
http://www.telerik.com/help/aspnet-ajax/grdgroupbyprogrammaticdefinition.html

Alternatively, you can modify the result values or format them in a different than the default style as shown in these samples:

http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/expressions/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/grdperformcalculationsingroupheader.html

I hope that these approaches will help you implement the grouping presentation you are after.

Greetings,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
ManniAT
Top achievements
Rank 2
answered on 28 Jul 2009, 10:22 AM
Hi Sebastian,

as I wrote I knew those solutions.
BUT - a header like Emloyee: Sepp; Sum Products: 33,3; Average Tax: 17,8; Number of XXX: 44; is almost useless in the scenario where I have 20 fields.
In a footer I have table cells (while the header is one single TD). So the aggregates are in the specific column.
This has two features:
a.) Easily to locate
b.) Due to a.) it saves a lot of space.
--I don't have to write Average Tax - since the value is in the Tax column a simple Avg: is enough.

Anyhow I solved the things with a second level of hierarchy.
The user can not drag columns to group - instead I provide "Command buttons" like "group by site" "Group by region" and than I add a virtual level of hierarchy (from the database) which brings a record which holds the aggregated values.
Expanding this brings the detail records.

Thanks for your help

Manfred
Tags
Grid
Asked by
ManniAT
Top achievements
Rank 2
Answers by
Sebastian
Telerik team
ManniAT
Top achievements
Rank 2
Share this question
or