How to show the total number of record in footer?

[Jeff Tang]

How to show the total number of record in footer? I have no paging. Thanls

[Princy]

Hello Jeff,

You can set Aggregate property for bound columns as 'Count' which will be dispalyed in the footer.For more information on this check out the link below
Aggregates

Thanks
Princy.

[Jeff Tang]

Thanks, I got the total number? It displayed " Count : xxx" , can I change the display to my custom text, (eg. "No. of Records : xxx") ? Thanks.

[Shinu]

Hi Jeff,

Try out the following code snippet to achieve the desired scenario.

CS:

   protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridFooterItem)
        {
            GridFooterItem footer = (GridFooterItem)e.Item;
            string strCount = footer["columnUniqueName"].Text.Split(':')[1];
            footer["columnUniqueName"].Text = "No. of Records :" + strCount;
        }
    }

Hope this helps..
Shinu

[Jeff Tang]

Thanks. But when should I call this function?

[Shinu]

Hi Jeff,

You can try the code snippet in the ItemDataBound event of the Grid as shown above.

Shinu

[Daniel]

Hello Jeff,

RadGrid1_ItemDataBound event handler will be called automatically by your RadGrid control if attached either declaratively or in code-behind.

declarative:

<telerik:RadGrid ID="RadGrid1" runat="server" OnItemDataBound="RadGrid1_ItemDataBound"
...

in code-behind (C#):

RadGrid1.ItemDataBound += new Telerik.Web.UI.GridItemEventHandler(RadGrid1_ItemDataBound);

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Rob]

I've implemented the code above to replace the string "Custom :" that RadGrid is putting in my footer when I custom aggregate a bound column that contains text.

I'm struggling to understand why the grid is inserting the string "Custom :" at all though. It's definitely not a string that I'm putting in there. Furthermore, if I provide a value for this column in the CustomAggregate event, for example "$ Totals", then this is concatenated to the "Custom :" string, and I end up with "Custom : $ Totals"! 

Fortunately, replacing the footer text for this column in the ItemDataBound event as per the code in the post above works, but why is the grid inserting this string "Custom :" into my footer cell?! Surely the whole point to custom aggregation is that I decide what goes in each cell, not the grid.