ASP.Net RadGrid how to add multiple groupby programatically

[Roger]

     I would like to add two levels of grouping in my grid.

This seems to work for 1st level of Grouping well, but now I want to add a sublevel similar to dragging a 2nd column up to grouping panel.  I have tried several iterations of the Select fields / GroupBy Expressions, but nothing seems to be working.  I have not seen a nice example of adding a 2nd level via code.

My 2nd level will be a field called TypeOfDoc.  I would like to show the count of documents in that header as well.

 

GridGroupByExpression expression = new GridGroupByExpression();
            // Select Fields
            GridGroupByField gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "ContentType";
            gridGroupByField.HeaderText = "Content Type ";
            gridGroupByField.HeaderValueSeparator = ";";
            expression.SelectFields.Add(gridGroupByField);

            // Adding Count Picking a field not in Group by
            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "Title";
            gridGroupByField.HeaderText = " ";
            gridGroupByField.HeaderValueSeparator = " ";
            gridGroupByField.FormatString = "<strong>({0})</strong>";
            gridGroupByField.Aggregate = GridAggregateFunction.Count;
            expression.SelectFields.Add(gridGroupByField);

            // GroupByField

            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "ContentType";
            gridGroupByField.HeaderText = "ContentType";
            expression.GroupByFields.Add(gridGroupByField);
            RadGrid1.MasterTableView.GroupByExpressions.Add(expression);

            RadGrid1.MasterTableView.GroupsDefaultExpanded = false;

[Roger]

After some Trial and Error effort I was able to get this to work and posting for others that may want to see a solution.  

* It does not give counts by Group, each count is of all records.  I am still working on this.

 

 GridGroupByExpression expression = new GridGroupByExpression();
            // Select Fields
            GridGroupByField gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "ContentType";
            gridGroupByField.HeaderText = " ";
            gridGroupByField.HeaderValueSeparator = " ";
            expression.SelectFields.Add(gridGroupByField);

            // Adding Count Picking a field not in Group by
            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "Title";
            gridGroupByField.HeaderText = " ";
            gridGroupByField.HeaderValueSeparator = " ";
            gridGroupByField.FormatString = "<strong>({0})</strong>";
            gridGroupByField.Aggregate = GridAggregateFunction.Count;
            expression.SelectFields.Add(gridGroupByField);

            // GroupByField

            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "ContentType";
            gridGroupByField.HeaderText = " ";
            expression.GroupByFields.Add(gridGroupByField);
            RadGrid1.MasterTableView.GroupByExpressions.Add(expression);

            
            expression = new GridGroupByExpression();
            
            // Select Fields
            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "TypeOfDocument";
            gridGroupByField.HeaderText = " ";
            gridGroupByField.HeaderValueSeparator = " ";
            expression.SelectFields.Add(gridGroupByField);

            // Adding Count Picking a field not in Group by
            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "Title";
            gridGroupByField.HeaderText = " ";
            gridGroupByField.HeaderValueSeparator = " ";
            gridGroupByField.FormatString = "<strong>({0})</strong>";
            gridGroupByField.Aggregate = GridAggregateFunction.Count;
            expression.SelectFields.Add(gridGroupByField);

            // GroupByField

            gridGroupByField = new GridGroupByField();
            gridGroupByField.FieldName = "TypeOfDocument";
            gridGroupByField.HeaderText = "";
            expression.GroupByFields.Add(gridGroupByField);
            RadGrid1.MasterTableView.GroupByExpressions.Add(expression);

            RadGrid1.MasterTableView.GroupsDefaultExpanded = false;

[Doncho]

Hi Roger,

I am glad to hear you have found a solution to the issue. Thank you for sharing it with the community!

Concerning the Group aggregates, you may find it useful to check out the Group Footers article and review the implementation of our live demo - Group Footers.

I hope you will find this information helpful.

Kind regards,
Doncho
Progress Telerik