How to create a summary row for for an indexer bound property

[Jay Timmins]

There is a small mention in the documentation but I'm not sure it's related to this:

If I have a column bound to an indexer property, can I not have a summary for that column?

Using the below definitions doesn't give me a summary:

//indexer bound column

<sf:GridNumericColumn MappingName="ListPriceByFrame[0]"/>

 

//summary column

 <sf:GridSummaryColumn Name="SubTot"

                                              Format="'Subtotal : {Sum:c}'"

                                              MappingName="ListPriceByFrame[0]"

                                              SummaryType="DoubleAggregate" />

[Srinivasan Vasu]

Hi Jay,
 

Thanks for contacting Syncfusion support. 

We have checked your query and we have prepared a sample as per your provided details. If the data operations are not working as expected while using indexer in the Underlying Collection, set GridColumn.UseBindingValue as true.  

 

Please refer the below code example 

 

<Syncfusion:SfDataGrid.Columns> 

                <Syncfusion:GridTextColumn MappingName="C1" 

                                           UseBindingValue="True" 

                                           HeaderText="C1"></Syncfusion:GridTextColumn> 

                <Syncfusion:GridNumericColumn MappingName="C2" 

                                              UseBindingValue="True"></Syncfusion:GridNumericColumn> 

                <Syncfusion:GridNumericColumn MappingName="C3[0]" 

                                              UseBindingValue="True" 

                                              ></Syncfusion:GridNumericColumn> 

            </Syncfusion:SfDataGrid.Columns> 

            <Syncfusion:SfDataGrid.GroupSummaryRows> 

                <Syncfusion:GridSummaryRow ShowSummaryInRow="False"> 

                    <Syncfusion:GridSummaryRow.SummaryColumns> 

                        <Syncfusion:GridSummaryColumn Name="PriceAmount" 

                                              Format="'Amount - {Sum:c}'" 

                                              MappingName="C3[0]" 

                                              SummaryType="DoubleAggregate" /> 

                    </Syncfusion:GridSummaryRow.SummaryColumns> 

                </Syncfusion:GridSummaryRow> 

            </Syncfusion:SfDataGrid.GroupSummaryRows> 

 

  

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample1747288833.zip 

Please refer the below UG Link: 

https://help.syncfusion.com/wpf/sfdatagrid/data-binding#limitations-when-binding-indexer-property
https://help.syncfusion.com/wpf/sfdatagrid/data-binding#binding-indexer-properties 

Regards,
Srinivasan 

 

 

 

 

 

[Jay Timmins]

Thanks for the thorough and informative reply!

[Srinivasan Vasu]

Hi Jay, 

  

Thanks for your update. 

  

Please let us know if you need further assistance on this. 

  

Regards,
Srinivasan