[Solved] Calculated Column in detail grid w/DataFields from Master

[FTI Dev]

I am trying to figure out how I can include/reference a bound column from my master grid in a calculated column in my detail grid.  Is there a fairly straightforward way to accomplish this?  I have tried adding the name of the column from the master grid to the DataFields property in the detail grid's calculated column - no luck.

Any guidance on this would be most appreciated!

Thanks, Bruce

[Veli]

Hello Bruce,

The scenario you are describing is not supported automatically in RadGrid. You will need to implement it yourself. We can suggest you to use a GridTemplateColumn, where in its ItemTemplate you can have a binding expression referencing a field from the parent GridDataItem:

<ItemTemplate>
    <%# (int)Eval((Container as GridDataItem).OwnerTableView.ParentItem.DataItem, "ParentColumnUniqueName") + 10 %>
</ItemTemplate>

Alternatively, you can use RadGrid's ItemCreated/ItemDataBound events to programmatically reference the parent item:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem item = e.Item as GridDataItem;
        int parentValue = (int)DataBinder.Eval(item.OwnerTableView.ParentItem.DataItem, "ParentColumnUniqueName");
        item["DestinationColumnName"].Text = (parentValue + 10).ToString();
    }
}

Regards,
Veli
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.