This is a migrated thread and some comments may be shown as answers.

Error when binding to Aggregate SumFunction

12 Answers 365 Views

GridView

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

tungnt185 asked on 02 Dec 2009, 11:55 AM

Hello Telerik team,
I've error when I'm using Aggregate function in Column Grid.

    
            <telerikGridView:GridViewDataColumn HeaderTextAlignment="Center" TextAlignment="Right" DataMemberBinding="{Binding EmployeeDeduction}"> 
        
                                    <telerikGridView:GridViewDataColumn.AggregateFunctions> 
        
                                        <telerikData:SumFunction FunctionName="EmployeeDeduction" SourceField="EmployeeDeduction" ResultFormatString="{}{0:c}" /> 
        
                                    </telerikGridView:GridViewDataColumn.AggregateFunctions> 
        
            </telerikGridView:GridViewDataColumn>

The error message like below in stack trace. When I use Count Function everything work fine but when I use Sum,Min,Max function error occurs. My EmployeeDeduction has data type is Money in SQL server 2008. I think it's a bug of Aggregate Sum function in Q3.

    
            Message: Unhandled Error in Silverlight Application 
        
            Code: 4004     
        
            Category: ManagedRuntimeError        
        
            Message: System.ArgumentException: Invalid property or field - 'EmployeeDeduction' for type: Entity 
        
               at Telerik.Windows.Data.Expressions.MemberAccessTokenExtensions.CreateMemberAccessExpression(IMemberAccessToken token, Expression instance) 
        
               at Telerik.Windows.Data.Expressions.ExpressionFactory.MakeMemberAccess(Expression instance, String memberName) 
        
               at Telerik.Windows.Data.Expressions.ExpressionFactory.MakeMemberAccess(Expression instance, String memberName, Boolean liftMemberAccessToNull) 
        
               at Telerik.Windows.Data.Expressions.PropertyAccessExpressionBuilder.CreateMemberAccessExpression() 
        
               at Telerik.Windows.Data.Expressions.EnumerableSelectorAggregateFunctionExpressionBuilder.CreateMemberSelectorExpression() 
        
               at Telerik.Windows.Data.Expressions.EnumerableSelectorAggregateFunctionExpressionBuilder.CreateAggregateExpression() 
        
               at Telerik.Windows.Data.EnumerableSelectorAggregateFunction.CreateAggregateExpression(Expression enumerableExpression) 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.<ProjectionPropertyValueExpressions>b__3(AggregateFunction f) 
        
               at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext() 
        
               at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) 
        
               at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.CreateProjectionInitExpression() 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.CreateAggregateFunctionsProjectionMemberBinding() 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.<CreateMemberBindings>d__0.MoveNext() 
        
               at System.Linq.Buffer`1..ctor(IEnumerable`1 source) 
        
               at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) 
        
               at System.Linq.Expressions.ReadOnlyCollectionExtensions.ToReadOnlyCollection[T](IEnumerable`1 sequence) 
        
               at System.Linq.Expressions.Expression.MemberInit(NewExpression newExpression, IEnumerable`1 bindings) 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.CreateSelectBodyExpression() 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilder.CreateSelectExpression() 
        
               at Telerik.Windows.Data.Expressions.GroupDescriptorExpressionBuilderBase.CreateQuery() 
        
               at Telerik.Windows.Data.QueryableExtensions.Aggregate(IQueryable source, IEnumerable`1 aggregateFunctions) 
        
               at Telerik.Windows.Controls.GridView.GridViewDataControl.CreateAggregateResults() 
        
               at Telerik.Windows.Controls.GridView.GridViewDataControl.CalculateAggregates() 
        
               at Telerik.Windows.Controls.GridView.GridViewDataControl.<>c__DisplayClass37.<Bind>b__36() 
        
               at Telerik.Windows.Controls.CursorManager.PerformTimeConsumingOperation(FrameworkElement frameworkElement, Action action) 
        
               at Telerik.Windows.Controls.GridView.GridViewDataControl.Bind(Object newValue) 
        
               at Telerik.Windows.Controls.GridView.GridViewDataControl.OnApplyTemplate() 
        
               at System.Windows.FrameworkElement.OnApplyTemplate(IntPtr nativeTarget)      
        
            Line: 57 
        
            Char: 13 
        
            Code: 0

12 Answers, 1 is accepted

answered on 23 Feb 2010, 01:53 PM

I am following "Telerik RadChart for Silverlight - Integration - Grouping and Aggregation" example. Only difference is I am using dynamic data from database intead of fixed data in the example. I can see data correctly in teleric gridview but when i try to bind same data in chart ( RadChart1.ItemsSource = RadGridView1.ItemsSource;), it is giving me following runtime exception.

"An unhandled exception ('Unhandled Error in Silverlight Application
Code: 4004
Category: ManagedRuntimeError
Message: System.ArguementException: Invalid property or field - 'propertyName' for type: AggregateFunctionGroup.

Please let me know if you have any idea about the solution.

answered on 06 Apr 2010, 10:25 PM

Hi,

I had the same issue. I had telerik grid bound to a collection of INotifyPropertyChanged objects. Collection was of type IEnumerable<INotifyPropertyChanged> but contained custom objects that implemented INotifyPropertyChanged interface and had extra properties. One of those properties was selected to get Summary aggregate function result. It failed exactly the same way described on the start of this thread.

To fix it, I had to bind data grid explicitly to IEnumerable<MyTypeThatContainsProperty>. After that everything works fine. Since I had a lot of possible types bound to grid, I created ValueConverter that converts my generic IEnumerable<INotifyPropertyChanged> into specific IEnumerable<> of any type required but, of course, this approach adds some restrictions.

I think the root cause is the fact (MAY BE) that when databinding is performed the property is taken from the GenericArgument collection of the items source's type instead of the object stored in the collection itself. Probably for better performance.

Hope this information will help others.

answered on 21 Jun 2010, 05:13 PM

Hello,

I have the same problem. When I try to use an aggregate function that needs to access to a field...

The binding for the grid is

ItemsSource="{Binding ElementName=beneficiaryDomainDataSource, Path=Data}"

The datasourc is

<riaControls:DomainDataSource AutoLoad="True" d:DesignData="{d:DesignInstance domain:Beneficiary, CreateList=true}" Height="0" LoadedData="beneficiaryDomainDataSource_LoadedData" Name="beneficiaryDomainDataSource" QueryName="GetBeneficiariesQuery" Width="0" SubmittedChanges="beneficiaryDomainDataSource_SubmittedChanges">

<riaControls:DomainDataSource.DomainContext>

<domain:SoContext />

</riaControls:DomainDataSource.DomainContext>

</riaControls:DomainDataSource>

When I remove the datasource and use this in the page constructor to load my data it is working:

LoadOperation<Beneficiary> op = this._context.Load(this._context.GetBeneficiariesQuery());

grdBeneficiaire.ItemsSource = op.Entities;

But this is not an acceptable solution for me as it is less practical to use and also it is much slower...

Any work around?

I find this feature does not work as advertised or I did not understand how to use it...

If someone sent a sample to support, what was the answer?

Thanks...