TreeListSummaryItem.ShowInColumn Property

Gets or sets a value that specifies a column in whose footer cell the summary will be displayed.

Namespace: DevExpress.Web.ASPxTreeList

Assembly: DevExpress.Web.ASPxTreeList.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

[DefaultValue("")]
public string ShowInColumn { get; set; }

VB.NET

<DefaultValue("")>
Public Property ShowInColumn As String

Property Value

Type	Default	Description
String	String.Empty	A String value that identifies the data column within the ASPxTreeList by its unique identifier name (WebColumnBase.Name), the name of the data source field to which it is bound (TreeListDataColumn.FieldName), or the column caption (WebColumnBase.Caption).

Remarks

Note

The following column identifiers are used in searching for a column:

• The Name property
• The FieldName property
• The Caption property

Note that it is recommended to avoid using the same values between Name, FieldName and Caption properties.

Example

This example shows how to implement a custom summary calculation.

Create a summary item within the ASPxTreeList.Summary collection and customize its settings as shown below:

The ASPxTreeList.CustomSummaryCalculate event is handled to sum the budgets of selected departments. Finally, set the TreeListSettingsBehavior.ProcessSelectionChangedOnServer option to true.

The image below shows the result:

C#

using DevExpress.Data;

protected void ASPxTreeList2_CustomSummaryCalculate(object sender,
TreeListCustomSummaryEventArgs e) {
    switch (e.SummaryProcess) {
        case CustomSummaryProcess.Start:
            e.Value = (int)0;
            break;
        case CustomSummaryProcess.Calculate:
            if (e.Node.Selected)
                e.Value = (int)e.Value + (int)e.Node["Budget"];
            break;
        case CustomSummaryProcess.Finalize:
            break;
    }
}

VB.NET

Imports DevExpress.Data

Protected Sub ASPxTreeList2_CustomSummaryCalculate(ByVal sender As Object,_
ByVal e As TreeListCustomSummaryEventArgs)
   Select Case e.SummaryProcess
      Case CustomSummaryProcess.Start
         e.Value = CInt(Fix(0))
      Case CustomSummaryProcess.Calculate
         If e.Node.Selected Then
            e.Value = CInt(Fix(e.Value)) + CInt(Fix(e.Node("Budget")))
         End If
      Case CustomSummaryProcess.Finalize
   End Select
End Sub