Hi Charles,

Thank you for the updated sample. I managed to ran it although I changed the line where you increase the value of valTotal:

valTotal += System.Convert.ToDecimal(((System.Data.DataRowView)(node.Item)).Row.ItemArray[2].ToString());

(The value column is has index of 2 in the ItemsArray, did it work for you with Row.ItemArray[5] ?! )

Ok I managed to get this look:

which I believe is what you are aiming at - so far so good.

In order to keep on the same track let us discuss from now on:

I see that groupedRow.ChildGroupRows collection is empty, but following your code it seems that you want to call the same function SetGroupText:

   foreach (GroupedRecord groupedChildRow in groupedRow.ChildGroupRows)
   {
      SetGroupText(groupedChildRow, e);
   }

Even if this collection is not empty at that point, I doubt that the rows inside will be of the GroupedRecord class, which is expected since you did not grouped based on a column from 2nd level band yet. Also, the columns structure in next level band is different and this approach will fail.

I suggest that before calling the SetGroupText method to check on what column (from which level band does it come ? ) user is trying to group and based on that values to access the proper grouped row and change its text.

Hi Hristo,

Thank you very much for your assistance.

Attached is the modified zip. I simplified the data for WHDG and added a new column called "Value".

Steps to try:

1. Group using "Value" column. It should show group header with the sum of value in the grouped "Value" column along with the properly grouped row data (Sorry for the naming if that's confusing).
2. Uncomment the line in default.aspx.cs, line 121. Does not need to uncomment the whole commented lines.
3. Try reloading the page and do step 1, grouping using "Value" column. It will show the correct group header but lost the grouped row data.

Trying to access child group rows from a grouped row seems to be the problem. Not quite sure why. I have also tested this on v13.1 and the still the same issue.

Thank you,

Charles

Hello Charles,

Thank you for the code shared. It looks ok and I cannot assume what could be wrong and I need to test it. Since I am not quite sure on your scenario I am attaching a sample of WHDG with two level data and grouping enabled. Please modify it to use your code and demonstrate what you have achieved and what is the issue you are struggling with.

I will be glad to investigate and suggest a possible solution for you.

Hi Hristo,

Thanks for the quick response. I will submit the idea.

I've tried implementing custom grouping, unfortunately it seems only working for 1st level of grouping.

If I tried to access the 2nd level group or deeper, I get the group row text exactly like what I wanted but it does not show any row data.

Would you please advise if there's anything wrong with the code below?

protected void SetGroupText(GroupedRecord groupedRow)
      {
         decimal valTotal = 0;
         int valRowCount = 0;
         groupedRow.Rows.Reset();
         while (groupedRow.Rows.MoveNext())
         {
            ContainerGridRecord row = (ContainerGridRecord)groupedRow.Rows.Current;
            WHDGListNode node = row.DataItem as WHDGListNode;
            TransactionInfo info = (TransactionInfo)node.Item;
            valTotal += info.Amount;
            valRowCount++;
            if (groupedRow.ChildGroupRows.Count > 0)
            {
               foreach (GroupedRecord groupedChildRow in groupedRow.ChildGroupRows)
               {
                  SetGroupText(groupedChildRow);
               }
            }
         }
         string colName = uiTransactionsGrid.Columns[groupedRow.ColumnGroupedBy.Key].Header.Text;
         groupedRow.Text = colName + " : " + groupedRow.Value.ToString() + "  Count: " + valRowCount.ToString() + "  Total: " + valTotal;
      }

      protected void uiTransactionsGrid_GroupedRowInitialized(object sender, GroupedRowEventArgs e)
      {
         ContainerGrid grid = sender as ContainerGrid;
         foreach (GroupedRecord groupedRow in grid.GroupedRows)
         {
            SetGroupText(groupedRow);
         }         
      }

Basically whenever I try to access "groupedRow.ChildGroupRows" in SetGroupText method, the grid will only show grouped row headers without any row data.

If I remove any reference accessing "groupedRow.ChildGroupRows", it works fine but the 2nd level group header text is not as expected (it uses the format defined in GroupedRowTextMask instead).

Thanks,

Charles