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

Group Aggregate with Paging (showing partial aggregate)

10 Answers 115 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Nicolas
Top achievements
Rank 1
Nicolas asked on 13 Mar 2013, 01:29 PM
I have basic radgrid with paging and grouping enabled. When my datasource has a small number of items everything is fine, however when the grid needs to use paging, my groups footer aggregate is evaluated on the rows of the current page only. I would like to build a custom aggregate function based on all the data (in the group) instead of having "per page per group" totals. How can it be done?

Given I achieve what I just described, would it be possible to hide the group footer ONLY when the end of group is not reached? As you can guess, it might be confusing to see multiple "group totals for the whole group"... Let's say I have a page size of 100 and my first group has 150 items, how could I force the group footer to appear only on the 2nd page (page 1 would have no group footer)?

Let me know if you want me to provide some code.

10 Answers, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 18 Mar 2013, 08:56 AM
Hello Nicolas,

As you noticed the grid generates Group Aggregate values only for the items on the current page. This behavior is due to the current implementation of RadGrid grouping logic and there are no scheduled plans to modify it.

Sorry for any inconvenience caused.

Greetings,
Pavlina
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Michael Fellmeth
Top achievements
Rank 1
answered on 08 May 2013, 07:33 PM
If possible, please consider Nicolas' request for future releases, and let me add that it would be helpful to be able to display footer totals only at the end of the table as well. 

While there are certainly scenarios where "running" group totals by page are desirable, it's much more common in my experience to display group totals only at the end of groups. Also, footer totals only at the end of the table.

The current functionality of displaying "running" group totals on every page while displaying footer totals directly beneath that are aggregated over the whole dataset creates a confusing presentation.

Ideally, the options would exist to display either (1) running group totals for each page on every page OR (2) group totals that really are group totals only at the end of the group. And options would also exist that allow footer totals aggregated over the whole dataset to display either (1) on every page OR (2) only at the end of the table.

Thanks for considering this request,
Michael 
0
Pavlina
Telerik team
answered on 13 May 2013, 09:30 PM
Hi Michael,
 
I want to assure you that I passed your feature request to our developers for future consideration. Please do not hesitate to contact us if other questions or problems arise.

Kind regards,
Pavlina
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
PRITESH
Top achievements
Rank 1
answered on 02 Jun 2014, 05:35 AM
I am using radGrid with Grouping and paging enabled,

It shows page wise aggregation in footer instead of showing aggregation at the end of each Group ,
I am using newer version of telerik 2014

does this problem still exists in the new version of telerik or it has been solved?

If solved than please provide the way to get rid of it.,.

Thank You
0
Shinu
Top achievements
Rank 1
answered on 02 Jun 2014, 05:57 AM
Hi Pritesh,

You can use  a  GroupFooterTemplate property for specifying a template that will show inside each group's footer rows. You can use them to provide a more customized look for the group totals display. Take a look at this online demo for more help.
Grid - Group Footers

Thanks,
Shinu
0
PRITESH
Top achievements
Rank 1
answered on 25 Jun 2014, 08:46 AM
Hi Shinu,

I wanted to ask that the Group wise Total in RadGrid Grouping displays at the end of the page while it should
show at the end of each Group,

I have attached screen Shots for the reference , Please provide us Solution and also how can i display text in row to show
Groupwise Total where groupwise total row is displayed  and Grand Total where Last row for total displayed


Thanx and Regard

Pritesh
0
Shinu
Top achievements
Rank 1
answered on 25 Jun 2014, 09:29 AM
Hi Pritesh,

The sample demo on Grid - Group Footers  shows how the Grouping works. Each grouping will display its Aggregate value. I guess you want to display the Aggregate for string field, you can set its Aggregate to Count. Then if you want to display different text on grouping and footer, try the Group footer template.

Thanks,
Shinu
0
vaibhav
Top achievements
Rank 1
answered on 16 Aug 2016, 12:41 PM

Hi pritesh,sonu,

I have also the same requirement as pritesh have and even i am also trying this but still didnot get any clue.

if your issue resolve then can you please share me some clue.

 

Thanks,

Vaibhav Kumar

0
Sandhya
Top achievements
Rank 1
answered on 27 Oct 2016, 09:04 AM

Team,

Can you please suggest how we can display group total at the end of each group. With Show footer true it is displaying total on each page. My group data comes in many pages, lets say 1to 3 pages. I don't want footer total in 1 and 2 pages. I only want total at the end of group in this scenario only on  3 page.  Same question is asked in this thread.Please reply ASAP.

0
Kamesh
Top achievements
Rank 1
answered on 08 Nov 2016, 09:06 AM
is this implemented? this post is at 2013 I believe by this time this feature might be implemented, Please suggest
Tags
Grid
Asked by
Nicolas
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Michael Fellmeth
Top achievements
Rank 1
PRITESH
Top achievements
Rank 1
Shinu
Top achievements
Rank 1
vaibhav
Top achievements
Rank 1
Sandhya
Top achievements
Rank 1
Kamesh
Top achievements
Rank 1
Share this question
or