We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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

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" />

3 Replies

SV Srinivasan Vasu Syncfusion Team July 14, 2017 05:28 AM UTC

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> 
 
  
Please refer the below UG Link: 
Regards,
Srinivasan
 
 
 
 
 
 



JT Jay Timmins July 14, 2017 08:48 AM UTC

Thanks for the thorough and informative reply!



SV Srinivasan Vasu Syncfusion Team July 15, 2017 05:51 PM UTC

Hi Jay, 
  
Thanks for your update. 
  
Please let us know if you need further assistance on this. 
  
Regards,
Srinivasan 


Loader.
Up arrow icon