[Solved] Sum of Grouped Items, not sum of all items in all groups?

[Rich]

Hi All,

I have a grid with a Grouped column. I want to display a COUNT of the groups in the footer.

Specifically i have a grid of invoices and i group them by customer. I want to show the number of unique customers in the footer.

<

 

telerik:GridBoundColumn DataField="fullName" Aggregate="Count" FooterText="Total Invoiced Members:" HeaderText="Name" SortExpression="fullName"

 

 

UniqueName="fullName">

 

 

</telerik:GridBoundColumn>

This seems to show a count of the invoices in the footer rather then a count of the "members". How can i get a count of the members?? Do i need to change the context of the query? thanks!

 

 

[Shinu]

Hi Rich,


To show the number of Groups in the footer you may try the following approach.

CS:

 protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridFooterItem)
        {
            int length = RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader).Length;
            GridFooterItem footer = (GridFooterItem)e.Item;
            footer["ColumnUniqueName"].Text = length.ToString();
        }
    }

Try setting ShowGroupFooter property to true to show count in each Group footer.

ASPX:

<MasterTableView   ShowGroupFooter="true" >

Shinu

[Rich]

Hey Thanks,

That's close except i'm really trying to show a COUNT for the entire query, this will give me the count for groups on the current page..

Any suggestions on how i can calculate the total count?

Thanks!

[Shinu]

Hi Rich,

Give a try with the following approach in the PreRender event of the Grid and see whether it works.

CS:

 protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
       // initially remove paging
        RadGrid1.MasterTableView.AllowPaging = false;
        RadGrid1.MasterTableView.Rebind();

        //get the total Group count
        int length = RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader).Length;

        //Enable paging for the Grid again
        RadGrid1.MasterTableView.AllowPaging = true;
        RadGrid1.MasterTableView.Rebind();

      // Set the footer text with the Total Group count
       foreach (GridFooterItem footer in RadGrid1.MasterTableView.GetItems(GridItemType.Footer))
       {
           footer["columnUniqueName"].Text = length.ToString();
       }

    }

Thanks
Shinu