I use WPF grid (10.3 version) to do summary, averages on certain columns. The issue is, the summary is displayed as part of the "group by" row and the users want to SORT on the summarized columns.
For example, the group by summary is shows as "Sales Person (Count 10) Orders Sum = 12345 Commission Sum = 45678".
The grid loses the column headers and also the users are unable to sort on the summarized trading volumes or commissions. I want to get the summary columns displayed "as is" under the column headers.
can some help with code samples, if this can be accomplished.
Thanks
Hello rgullapa,
I have been looking through your questions and I can suggest you set the LabelLocation property of the FieldLayoutSettings to SeparateHeader, so you can see the common fields header even when you groupby your XamDataGrid:
<igDP:XamDataGrid.FieldSettings> <igDP:FieldSettings AllowSummaries="True" SummaryDisplayArea="InGroupByRecords" AllowRecordFiltering="True"/> </igDP:XamDataGrid.FieldSettings> <igDP:XamDataGrid.FieldLayoutSettings> <igDP:FieldLayoutSettings LabelLocation="SeparateHeader" AutoGenerateFields="True" /> </igDP:XamDataGrid.FieldLayoutSettings>
If you need any further assistance on this matter, please feel free to ask.
Thanks for the reply, but your solution did not work for my requirement.
The issue is, when I do group by I loose the top columns header.
This is what I am looking for:
I need the column headers, so users can sort on the summarized columns, like they want to know, which sales person did more trading volume.
Please let me know if the question is not clear.
Thank you for the details and the screenshots. In order to achieve this design you can try:
<igDP:XamDataGrid.FieldLayoutSettings>
<igDP:FieldLayoutSettings HeaderPlacementInGroupBy="OnTopOnly" />
</igDP:XamDataGrid.FieldLayoutSettings>
Please let me know if you need any additional assistance on this.
I am just checking have you been able to resolve your issue? If you still need any assistance on the matter do not hesitate to ask.
In case the above suggestion helped you solve your issue please verify the thread as answered, so other users may take better advantage of it.