Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
45
How do I customize Group Summary Row
posted

I am using group summary to display average of fields on the grouped summary row and the values are shown the same way as the regular row. Values are aligned with the main column header.

I am doing this in xamdatagrid using  sumDefinition.DisplayArea = SummaryDisplayAreas.TopFixed;

 

Problem: In addition to my grouped summary rows, I get a grand summary shown as the top row in the grid. I do not want to show this grand summary row. \

At least can I Make this  grand summary row height to zero.

FYI: The other approach I used:

I tried using xamdatagrid using  sumDefinition.DisplayArea = SummaryDisplayAreas.InGroupByRecords and found out that it will remove the grand summary row the way I want while keeping the grouped summary rows. However, the grouped average rows are changed now with an added line on the top of each average rows which shows the count of number of records in the group. I do not want to see this. I simply want to show the averages (see below grouped by type which I typed using Excel, I can't get xamdatagrid it to show like this.).

Col-1

Col-2

Col-3

Col-4

Type

15

1.5

150

1500

1

10

1

100

1000

1

20

2

200

2000

1

35

3.5

350

3500

2

30

3

300

3000

2

40

4

400

4000

2