Hi,
I have a webhierarchial grid. I need to show a summary(Sum) values based on the group by condition of all the other columns.
For ex: There are columns resource, resource type, role, task, Hours 1, hours 2, Hours 3, Charge 1, Charge 2, Charge 3.
When I group by Task: The Task group by row should show the sum values for hours 1, hours 2, hours 3, charge 1, charge 2, charge 3 on the exact below header text of each columns.
When I group by Role: the role group by row should sum values for hours 1, hours 2, hours 3, charge 1, charge 2, charge 3 on the exact below header of each column.
Please send me the samples.
Hello Agilan,
The WHDG group row architecture currently does not support the alignment of the grouped row text with the column headers. Regarding accessing the grouped rows through the group row, this is done via the GrouprecordEnumeration. Attached is a small sample illustrating that in practice.
Hope this helps. Please feel free to contact me with any questions.
Also please send me some examples for accessing Rowscollection object in grouped row.
Thanks Ivanov
I can access the groupedrow using rowscollection object. But i want the group row column values of all the other columns needs to be presented in the exact column header.
Something like I have columns- Name, ResourceType, Role, Month1, Month2, Month3, Month4, total Columns.
When I group by resource type. Then the group row needs to display - resource type (2) 100 120 100 100 420
The values of 100,120,100,100,420 will show exactly below the correct column headers. But the group row seems is not formatted.
Thank you for your reply.
I may be misunderstanding your requirement, however if you would like to access the data on a per-column basis, this can be done by accessing the grouped row'sRowscollection, which returns the row object in that group. The group row itself also contains a reference to the column used for grouping. Please let me know if I have misunderstood your question in any way.
Thanks Ivanov. I have already checked the custom group by link. One more question, it seems are group-by row is not presented based on the column hearder. All values are coming like a row. So we can't identify like a column wise separation of datas. The group-by row sum values should come just in the exact column header like summary row values.