Group Aggregate with Paging (showing partial aggregate)

11 posts, 0 answers
  1. Nicolas
    Nicolas avatar
    2 posts
    Member since:
    Feb 2013

    Posted 13 Mar 2013 Link to this post

    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.
  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 18 Mar 2013 Link to this post

    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Michael Fellmeth
    Michael Fellmeth avatar
    4 posts
    Member since:
    Feb 2007

    Posted 08 May 2013 Link to this post

    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 
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 13 May 2013 Link to this post

    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.
  6. PRITESH
    PRITESH avatar
    12 posts
    Member since:
    Mar 2014

    Posted 02 Jun 2014 Link to this post

    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
  7. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 02 Jun 2014 in reply to PRITESH Link to this post

    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
  8. PRITESH
    PRITESH avatar
    12 posts
    Member since:
    Mar 2014

    Posted 25 Jun 2014 in reply to Shinu Link to this post

    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
  9. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 25 Jun 2014 in reply to PRITESH Link to this post

    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
  10. vaibhav
    vaibhav avatar
    2 posts
    Member since:
    Oct 2015

    Posted 16 Aug Link to this post

    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

  11. Sandhya
    Sandhya avatar
    4 posts
    Member since:
    Oct 2015

    Posted 27 Oct Link to this post

    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.

  12. Kamesh
    Kamesh avatar
    1 posts
    Member since:
    Oct 2013

    Posted 08 Nov in reply to Pavlina Link to this post

    is this implemented? this post is at 2013 I believe by this time this feature might be implemented, Please suggest
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017