[Solved] GridView Totals template

[Rama]

Hi,

I'm planning to do the totals/aggregate function at code behind. do you've any sample codes for this?

My code:

  GridViewDataColumn gridColumn =   new GridViewDataColumn{Header = key};
                 Binding bin = new Binding(string.Format("Key.Attributes[{0}]", key));
                 gridColumn.DataMemberBinding = bin;
                 TraderMeasureSeriesGrid.Columns.Add(gridColumn);

I would like to attach  AggregateFunctions from code behind. how can I set this?

<telerik:GridViewDataColumn.AggregateFunctions>

         <telerik:SumFunction Caption="Sum: "  SourceField="TotalCost" FunctionName="Sum" />                      
    </telerik:GridViewDataColumn.AggregateFunctions>

Also, How can i Set footer and header template?

                          <telerik:GridViewDataColumn.Footer>

                              <telerik:RadButton Content="Show smallest UnitPrice" Click="Button_Click" Margin="5,0" />

                           </telerik:GridViewDataColumn.Footer>

                            <telerik:GridViewDataColumn.GroupHeaderTemplate>

                                <DataTemplate>

                                    <TextBlock Foreground="Green" Text="{Binding Group.Key}" />

                                </DataTemplate>

                            </telerik:GridViewDataColumn.GroupHeaderTemplate>

Thanks in advance,

[Vlad]

Hello,

 You can set it exactly in the same way as in XAML. Just create desired function and add it in the column aggregate functions. 

Greetings,
Vlad
the Telerik team

[Rama]

Thanks for the quick reply but AggregateFunction is abstract class and I can't find  a way to create new AggregateFunction in code behind. do you've any example?

Thanks

[Vlad]

Hello,

You should create SumFunction exactly as in XAML.

Best wishes,
Vlad
the Telerik team

[Rama]

Hi Vlad,

I tried all possible scenarios hence posted this question. if it's same as xaml, can you attach code snippet? we're evaluating Telerik versus DevExpress controls. you quick response will be appreciated.

Thanks

[Vlad]

Hello,

 Here is the code - extremely simple as you can see:

var column = new GridViewDataColumn();
column.AggregateFunctions.Add(new SumFunction() { SourceField = "YourSourceFiled" });

Kind regards,
Vlad
the Telerik team

[Rama]

Thanks again for your quick response. I'll test this now.

[Rama]

Hi Vlad,

When I do the following I get zero sum:

   gridColumn.AggregateFunctions.Add(new SumFunction() {SourceField = measure,FunctionName = "Sum", SourceFieldType = Type.GetType("System.Int32")});

do you know why? no exception no error simply zero. Please note that I'm not using any other celltemplate, footer or header templates:

   GridViewDataColumn gridColumn = new GridViewDataColumn {Header = measure};
                gridColumn.DataMemberBinding = bin;
                    gridColumn.AggregateFunctions.Add(new SumFunction() {SourceField = measure,FunctionName = "Sum", SourceFieldType = Type.GetType("System.Int32")});
                TraderMeasureSeriesGrid.Columns.Add(gridColumn);

Please let me know how to debug Aggregate functions like above to check where I'm going wrong.

Thanks

[Rama]

Hi, Please note that my data is valid and contains all integers so it's not a data issue

[Rama]

Resolved myself. it needs same databinding path as Binding.