[Solved] Subtotals on gridview

[Jackie]

I populate the radgrid dynamically using C#. Is there a way to use the subtotals/totals when the columns are not bound in the xaml. All the examples and forums show columns being bound in the xaml.

[Vanya Pavlova]

Hi Jacqueline,

 

There is no problem to refer aggregates in code behind. There are various ways to refer an aggregate function in code-behind for a particular column:

CountFunction f = new CountFunction();
( ( GridViewDataColumn )this.radGridView.Columns[ "ID" ] ).AggregateFunctions.Add( f );

 
You may do the same for grouping aggregates. Please refer to our online docs for further info. 

Greetings,
Vanya Pavlova
the Telerik team

[Jackie]

That code works when working with the count function. When I try to use the SumFunction:

SumFunction s = new SumFunction();

s.Caption =

"Sum: ";

((

GridViewDataColumn)this.rgvResults.Columns["Weight"]).AggregateFunctions.Add(s);

I get the attached error. I am using Silverlight 3, Visual Studio 2008 on a Windows 7 64bit.

Thank you

[Vanya Pavlova]

Hi Jacqueline,

 

Generally you may perform sum operation only to numeric types. What is the data type of the property to which this column is bound to? Regarding the version you are currently using I would want to inform you that Telerik support for Silverlight 3 has been obsoleted. Would it be convenient to you to upgrade to the latest version of RadControls/Silverlight?

 

Best wishes,
Vanya Pavlova
the Telerik team

[Jackie]

All the fields that I am trying to sum are decimal fields or interger fields. I will check into upgrading to the newest version.

[Jackie]

Upgrading is currently not an option due to the fact that it requires Visual Studio 2010, which would mean we would also need to upgrade Blend, Silverlight, Telerik Controls.

I continued to try different things, even by switching all the fields to numeric it still throws the same error.

Thanks

[Jackie]

Any word on this yet? It is still error when I use any fuction but Count.
Thanks,
Jackie