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

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.

Hello Charles,

It seems that you need to check if ChildGroupRows exist as follows:

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

Please try this and let me know if you have further questions on the matter.

Hi Hristo,

Thanks a lot!

That solved the grouping issue.

I was pretty sure I did check the HasChildGroupRows property initially, but since it always return true even for 1st column grouping, I changed it to use Count.

Thanks again!

Charles

Hello Charles,

Thank you for your feedback.

I am glad this helped. Please let me know if you have any further questions on the matter.