custom aggregate for grid and table

[moegal]

I have a grid with datasource1 and then I have a gridtableview with datasource2 similar to the example "Grid / Several Tables at a Level"both data sources have a column called Price.

Can I create an aggregate that uses the values from both?

If so, can you point me in the right direction.

Thanks, Marty

[Shinu]

Hi,

Please take a look into the sample code snippet I tried to give the aggregate of common column in the Footer of the Second Detail Table. Make sure that you have set the 'Name' property for each GridTableView.

C#:

static int total1 = 0;
static int total2 = 0;
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        if (e.Item.OwnerTableView.Name == "NameOfTheFirstDetailTable")
        {
            GridDataItem dataItem = e.Item as GridDataItem;
            int fieldValue = int.Parse(dataItem["ColumnUniqueName"].Text);
            total1 += fieldValue;
        }
        if (e.Item.OwnerTableView.Name == "NameOfTheSecondDetailTable")
        {
            GridDataItem dataItem = e.Item as GridDataItem;
            int fieldValue = int.Parse(dataItem["ColumnUniqueName"].Text);
            total2 += fieldValue;
        }
    }
    if (e.Item is GridFooterItem)
    {
        GridFooterItem fitem = (GridFooterItem)e.Item;
        if (e.Item.OwnerTableView.Name == "NameOfTheSecondDetailTable")
        {
            fitem["Order2"].Text = "Total Price="+ (total1 + total2).ToString();
        }
    }
}

Thanks,
Shinu.

[moegal]

thanks, I will give it a try!