Show Column avg/sum inside the pager template

[naimish]

Hi,

I am using radgrid for showing database data, and in footer section, i am showing average of  one column data.
Now beside that i need to show that average to the some where inside pager template region.

But i dont know how can i show that thing inside pager region.

[Shinu]

Hello Naimish,


The following code will help you in this.

Code:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    GridFooterItem footerItem = (GridFooterItem)RadGrid1.MasterTableView.GetItems(GridItemType.Footer)[0];
    string value = footerItem["Number"].Text; // get the value usingColumnUniqueName
    foreach (GridPagerItem pagerItem in RadGrid1.MasterTableView.GetItems(GridItemType.Pager))
    {
        Label showAvg = (Label)pagerItem.FindControl("showAggregate");
        showAvg.Text = value; // Set the Label Text
    }
}

And my aspx looks like this:

   <PagerTemplate>
        <asp:Label ID="showAggregate" runat="server" Text="Hi" ></asp:Label>
    </PagerTemplate>
    <Columns>
         . . .
        <telerik:GridBoundColumn Aggregate="Avg" DataField="Number" DataType="System.Int32" HeaderText="Number"
            SortExpression="Number" UniqueName="Number">
        </telerik:GridBoundColumn>
    </Columns>
</MasterTableView>

Regards,
Shinu.

[naimish]

Hi Shinu,

Sorry for late reply, your given solution helped me to resolve my issue.

Very-very thank you.