private void SetGridSettings() { //Bind Products DropDown: this.gridEX1.DropDowns["Products"].SetDataBinding(this.jsNorthWindDataSet1.Products, ""); //Adding a GroupHeaderTotal: GridEXGroupHeaderTotal groupTotal = new GridEXGroupHeaderTotal(); groupTotal.AggregateFunction = AggregateFunction.Count; groupTotal.TotalFormatMode = FormatMode.UseStringFormat; groupTotal.TotalFormatString = "{0} Customers"; this.gridEX1.RootTable.GroupHeaderTotals.Add(groupTotal); this.gridEX1.RowHeaders = InheritableBoolean.True; this.gridEX1.GroupMode = GroupMode.Collapsed; //Group Customers by Order_Details.Product: this.gridEX1.RootTable.Groups.Add(this.gridEX1.Tables["OrderDetails"].Columns["ProductID"]); }