Summed footer for custom grid template

[WCRA Dev]

I've created a custom grid template that displays 3 columns of data (see code below).  The data is then grouped by year.  How can I show a total for each of these three columns in the group footer?

                    <telerik:GridTemplateColumn HeaderStyle-Width="246" ItemStyle-Width="246"
                        UniqueName="TemplateColumn2">
                        <HeaderTemplate>
                            <table ID="Table1" border="0" cellpadding="0" cellspacing="0" width="246">
                                <tr>
                                    <td align="center" colspan="3">
                                        Remaining Reserve<BR />Open MN Claims Only</td>
                                </tr>
                                <tr>
                                    <td width="82px">
                                        <center>
                                            Indemnity</center>
                                    </td>
                                    <td width="82px">
                                        <center>
                                            Medical</center>
                                    </td>
                                    <td width="82px">
                                        <center>
                                            Med Only</center>
                                    </td>
                                </tr>
                            </table>
                        </HeaderTemplate>
                        <ItemTemplate>
                            <table ID="Table2" border="0" cellpadding="0" cellspacing="0" width="246">
                                <tr>
                                    <td align="right" width="82px">
                                        <%#DataBinder.Eval(Container.DataItem, "open_indemnity", "{0:c}")%>
                                    </td>
                                    <td align="right" width="82px">
                                        <%#DataBinder.Eval(Container.DataItem, "open_medical", "{0:c}")%>
                                    </td>
                                    <td align="right" width="82px">
                                        <%#DataBinder.Eval(Container.DataItem, "open_medonly", "{0:c}")%>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                        <HeaderStyle Width="246px" />
                        <ItemStyle Width="78px" />
                    </telerik:GridTemplateColumn>

[Princy]

Hello Christian,

I have tried following code for a similar scenaio in my application. I used custom code to calculate the sum and created table structure dynamically for aligning the footer text properly. Please modify the code according your need.

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)

{

int length = RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader).Length;

for (int i = 0; i < length; i++)

{

int result1 = 0;

int result2 = 0;

int result3 = 0;

GridGroupHeaderItem groupHeader = (GridGroupHeaderItem)RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader)[i];

GridItem[] children = groupHeader.GetChildItems();

foreach (GridDataItem child in children)

{

GridDataItem childItem = child as GridDataItem;

DataRowView DataRow = (DataRowView)child.DataItem;

result1 = Convert.ToInt32(DataRow["open_indemnity"].ToString()) + result1;

result2 = Convert.ToInt32(DataRow["open_medical"].ToString()) + result2;

result3 = Convert.ToInt32(DataRow["open_medonly"].ToString()) + result2;

}

GridGroupFooterItem groupFooter = (GridGroupFooterItem)RadGrid1.MasterTableView.GetItems(GridItemType.GroupFooter)[i];

HtmlTable tbl = new HtmlTable();

HtmlTableCell cell1 = new HtmlTableCell();

HtmlTableRow row = new HtmlTableRow();

row.Align = "right";

cell1.Width = "100";

cell1.BorderColor = "red";

cell1.InnerText = result1.ToString();

row.Cells.Add(cell1);

tbl.Rows.Add(row);

HtmlTableCell cell2 = new HtmlTableCell();

cell2.InnerText = result2.ToString();

cell2.Width = "100";

row.Cells.Add(cell2);

tbl.Rows.Add(row);

HtmlTableCell cell3 = new HtmlTableCell();

cell3.InnerText = result3.ToString();

cell3.Width = "100";

row.Cells.Add(cell3);

tbl.Rows.Add(row);

groupFooter["TemplateColumn2"].Controls.Clear();

groupFooter["TemplateColumn2"].Controls.Add(tbl);

}

}

I got border for the text displayed in GridGroupFooter and was able to resolve this by adding following css on page.

CSS:

 <style type="text/css">
        .RadGrid_Default .rgFooter td
        {
            border-bottom: none !important;
            border-top: none !important;
        }
 </style>

I hope this help you,
Princy.

[WCRA Dev]

Thank you, this helps a lot.  The only issue now is that if the DataGrid is refreshed this error "Object reference not set to an instance of an object" happens on the line of code below:

result1 = Convert.ToDecimal(DataRow["open_indemnity"].ToString()) + result1;

[Mira]

Hello Christian,

I have followed your scenario and prepared a sample project for you demonstrating how the desired functionality can be achieved. You can find it attached to this message.

Please take a look at it and let me know whether it helps.

Best wishes,
Mira
the Telerik team