Grouping by Related fields

Hi,

We are developing a software product that needs advanced grouping and summary capabilities. We have looked into Syncfusion Essential Grouping and it seems to be very much what we need with one important exception. It seems not to respond to the changes in child data nodes. Let me explain what we do step by step:

1. Create two BindingLists of some objects.
2. Add relation (RelationKind.ForeignKeyReference) between these two lists.
3. Add Grouping Column that works using this relation with
m_oEngine.TableDescriptor.GroupedColumns.Add("OurCustomRelation.AuxilaryName");
4. Expand all records by calling
m_oEngine.Table.ExpandAllRecords();
5. Iterate through m_oEngine.Table.NestedDisplayElements collection, everything is fine so far.
6. Change the value of some property for one of the elements in child collection.
7. Send ListChange event from child list.
8. We expect that data will be automatically regrouped.
9. When we iterate one more time through m_oEngine.Table.NestedDisplayElements we see old result, for us this is not correct.
10. If we send ListChange event on parent list all works fine, but it can be difficult sometimes to send such event.

We use Syncfusion 4.4.0.51 and Visual Studio 2005

Best regards,
Sergey Tikhomirov
Senior Developer

Hi Sergey,

I am not sure of what be might be causing this strange behavior without a working sample. I have tested this issue in the attached sample with Essentail studio V.4.x. I was not able to reproduce the issue. Maybe I am not following the steps that you are doing. Please post us a sample showing this problem or modify the attached samples to reproduce the problem, which will help me to find the issue and resolve this.

Sample : CollectionWithRelatedMasterGrouping.zip

Thanks for your patience.

Best regards,
Haneef

Hi,

We've modified your example to show you workflow that we think works incorrect.
Press "Make Test" button for execute this workflow.
In comments in this function we've wrote expected result.

Best regards,
Sergey Tikhomirov
Senior Developer


CollectionWithRelatedMasterGrouping.zip

Hi Sergey,

My apologizes for the delay caused on this issue.

Before calculating summary count in a AuxilaryList, try setting the Table.TableDirty to true. Here is a code snippet.

ChangeAuxilaryData(1, "16");

m_oEngine.Table.SummariesDirty = true;
m_oEngine.Table.TableDirty = true;

iCountAfterAuxilaryListChange = CalculateNestedSummaryCount();

Please refer to the attached sample for modification.
CollectionWithRelatedMasterGrouping.zip

Thanks for you interest in Syncfusion Product.

Best regards,
Haneef