More details as listed below.

I am getting the error "cannot convert from infragistics.web.ui.gridcontrols.summaryrowsetting to string". Column is defined as integer, not sure why I am getting this error.

ColumnSummaryInfo BNCartonsSummary1 = new ColumnSummaryInfo();

BNCartonsSummary1.ColumnKey = "DDCARG";

BNCartonsSummary1.Summaries.Add(SummaryType.Sum);

wbgdata1.Behaviors.SummaryRow.ColumnSummaries.Add(BNCartonsSummary1);

Columns are added manually as listed below:
tblShipment = new DataTable("Shipment");
tblShipment.Columns.Add(new DataColumn("Cartons", typeof(int)));

tc = wbgdata1.Columns["DDCARG"] as TemplateDataField;

if (tc == null)

{
tc = new TemplateDataField();

tc.Key = "DDCARG";

tc.ItemTemplate = new PlaceHolderTemplate();

this.wbgdata1.Columns.Add(tc);

}

Please help.

Thanks.

Denis,

Could you please put together a sample with Webdatagrid where the columns are created manually with the summary data showing in footer values?.

Thanks for your help.

Srini 

Please see the sample code that produces the error.

using System;

using System.Data;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Infragistics.Web.UI.GridControls;

namespace WebApplication4

{

public partial class WebForm1 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

GetData();

FooterValues();

}

public void FooterValues()

{

this.WebDataGrid1.Columns[0].Footer.Text = "Totals:";

WebDataGrid1.Behaviors.CreateBehavior<SummaryRow>();

ColumnSummaryInfo CartonsSummary = new ColumnSummaryInfo();

CartonsSummary.ColumnKey = "NumOfCartons";

CartonsSummary.Summaries.Add(SummaryType.Sum);

WebDataGrid1.Behaviors.SummaryRow.ColumnSummaries.Add(CartonsSummary);

SummaryRowSetting CartonsSummary1 = new SummaryRowSetting(WebDataGrid1, "Department");

CartonsSummary1.ShowSummaryButton = false;

this.WebDataGrid1.Behaviors.SummaryRow.ColumnSettings.Add(CartonsSummary1);

}

public void GetData()

{

DataTable tblShipment = new DataTable("Shipment");

tblShipment.Columns.Add(new DataColumn("NumOfCartons", typeof(int)));

UnboundField col = new UnboundField();

col.Key = "NumOfCartons";

col.Header.Text = "NumOfCartons";

this.WebDataGrid1.Columns.Add(col);

DataRow r = tblShipment.NewRow();

r["NumOfCartons"] = 30;

tblShipment.Rows.Add(r);

WebDataGrid1.DataSource = tblShipment;

//Bind the Dataset to the web grid

WebDataGrid1.DataBind();

}

}

}

Thank you for reporting this.

I have asked our engineering staff to examine this further.  To ensure that it will receive attention, I have logged this behavior   in our internal tracking system with a Development ID of 236746. A support case is created on your behalf with number CAS-183509-S8H5L0, so that you can be notified when the bug is fixed.
You can find your active cases under Account - Support Activity in our website. Select your ticket and go to Development Issues tab to view the status of related bugs.

Let me know if I may be of further assistance.

Denis,

summary value is getting doubled for the regular unbound column, please review the sample code attached.

Denis,

Also, is it possible to remove the caption sum = ?.

Thanks.

Denis,

Thank you for the sample code. I am able o get the summary of the template column using your code, but I noticed that summary value is getting doubled for the unbound column. Please review the sample code and advise.

Thanks.