Is there a way to display only the SUM in the summaries instead of the SUM, MIN, MAX, AVG, and Count.
I basically want a Totals row at the bottom of my table with the SUM only of each column. Is that possible?
I just ported my project over to VS2013 and running it on the 4.5 framework. Using the ".AutoGenerateColumn(false)" settings takes care of all of my issues and now everything is working great.
I am still wondering why I couldn't get it to work in 4.0 though. Thanks for the replies everyone.
So I've figured out why it wouldn't work, which doesn't really make sense to me.
There are a total of 22 fields in the IEnumerable that I am using for the datagrid. When I specify only the fields that I want from that I will get the extra column summary fields, even though they are blank. To get around this I have to manually set the other columns in the settings and set their hidden value to TRUE. Once you do this, you will get the desired results.
However, I am now getting another issues where no matter what size I set my first column's width to, it will not re-size. One problem down, another one up.
Hi Martin,
So to fix this issue you should configure in Summaries in ColumnSettings explicitly all columns and which exactly summaries you want to activate. For instance if I have a grid with 5 columns you should set in column settings of summaries only the summary function that should be activated(in our case this should be Sum). As Martin said I can't replicate your issue but if I do not set in the columnKey the proper id (for instance I made a mistake or just do not keep in mind it is case sensitive) then I will have issue similar to you. Please check this code snippet:
@(
Html.Infragistics().Grid(Model)
.ID("Grid1")
.AnimationDuration(150)
.Features(feature =>
{
feature.Summaries().Type(OpType.Remote).CalculateRenderMode(SummaryCalculateRenderMode.OnSelect)
.ColumnSettings(cs => {
cs.ColumnSetting().ColumnKey("ProjectId").SummaryOperands(so =>
so.SummaryOperand()
.RowDisplayLabel("sUM1")
.Type(SummaryFunction.Sum)
.Active(true);
});
cs.ColumnSetting().ColumnKey("Name").SummaryOperands(so =>
so.SummaryOperand().Type(SummaryFunction.Sum).Active(true);
cs.ColumnSetting().ColumnKey("StartDate").SummaryOperands(so =>
cs.ColumnSetting().ColumnKey("EndDate").SummaryOperands(so =>
cs.ColumnSetting().ColumnKey("IsPostponed").SummaryOperands(so =>
}
)
.Columns(column =>
column.For(project => project.ProjectId).HeaderText("Project ID").DataType("number").Width("150px");
column.For(project => project.Name).HeaderText("Name").DataType("string ").Width("200px");
column.For(project => project.StartDate).HeaderText("Start Date").DataType("date").Width("240px");
column.For(project => project.EndDate).HeaderText("End Date").DataType("date").Width("240px");
column.For(project => project.IsPostponed).HeaderText("Is Postponed?").DataType("bool").Width("80px");
.PrimaryKey("ProjectId")
.DataBind().Render()
Thanks,
Miro
Martin -
I am using NetAdvantage for .NET 2013 Vol. 1 in my MVC project. I've tried to get it working with the jQuery syntax but no luck. I believe I am stuck with the MVC helper syntax at the moment.
Hi Ryan,
Which version of the jQuery product are you using? I still can't reproduce it on my side. Have you tried to set the "Active" property to "false" in all other fields? If that doesn't work, the problem might be in the MVC helpers' syntax. If you are able to describe the igGrid in the jQuery syntax (as in the first post reply), maybe that will work. Try these suggestions, and if none of them work for you, we'll investigate further.
Martin Stoev