This is a migrated thread and some comments may be shown as answers.

[Solved] Order by groupby headers

2 Answers 93 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Paul asked on 20 Oct 2008, 01:49 PM

Hi,

Im trying to work out how to order by the group header. I have the following grouping:

    
                        GridGroupByExpression expression = new GridGroupByExpression(); 
        
                        GridGroupByField gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerName"; 
        
                        gridGroupByField.HeaderText = "Customer Name"; 
        
                        expression.SelectFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerName"; 
        
                        gridGroupByField.HeaderText = "Customer Name"; 
        
                        expression.GroupByFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerStatus"; 
        
                        gridGroupByField.HeaderText = "Customer Status"; 
        
                        expression.SelectFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerStatus"; 
        
                        gridGroupByField.HeaderText = "Customer Status"; 
        
                        expression.GroupByFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustStatusID"; 
        
                        gridGroupByField.HeaderText = "Number of splits: "; 
        
                        gridGroupByField.HeaderValueSeparator = " "; 
        
                        // gridGroupByField.FormatString = "<strong style='color:red'>{0}</strong>"; 
        
                        gridGroupByField.Aggregate = GridAggregateFunction.Count; 
        
                        expression.SelectFields.Add(gridGroupByField); 
        
                        rg_Results.MasterTableView.GroupByExpressions.Add(expression);

I want to order by the customer status in the header, how would i do this?

2 Answers, 1 is accepted

answered on 21 Oct 2008, 07:48 AM

Hi,

You can set the sort order of the group column accordingly as shown below. In this example I sort the group using the CustomerID field a shown below:

CS:

    
             protected void Page_Load(object sender, EventArgs e) 
        
                    { 
        
                        GridGroupByExpression expression = new GridGroupByExpression(); 
        
                        GridGroupByField gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CompanyName"; 
        
                        gridGroupByField.HeaderText = "Company Name"; 
        
                        expression.SelectFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerID"; 
        
                        gridGroupByField.HeaderText = "Customer ID"; 
        
                        expression.SelectFields.Add(gridGroupByField); 
        
                        gridGroupByField = new GridGroupByField(); 
        
                        gridGroupByField.FieldName = "CustomerID"; 
        
                        gridGroupByField.SortOrder = GridSortOrder.Descending; 
        
                        expression.GroupByFields.Add(gridGroupByField); 
        
                        RadGrid1.MasterTableView.GroupByExpressions.Add(expression); 
        
                    }

Thanks,
Shinu