Error while applying aggregate to the sharepoint list's calculated column

[Swapnil]

HI,
      I am showing sharepoint List's record in telerik radgrid & also showing group footer aggregate & Radgrid's footer aggregate,Its working fine.But aggregates not working on sharepoint list's calculated column (datatype -number).
           Another problem is I have Sharepoint list column named Amount whose datatype is text I want to aggregate it ...It actually contains the numbers.......
        Following is the event log...............

Log Name:      Application
Source:        ASP.NET 2.0.50727.0
Date:          9/20/2013 11:16:13 AM
Event ID:      1309
Task Category: Web Event
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      PRASHANT-PC
Description:
Event code: 3005 
Event message: An unhandled exception has occurred. 
Event time: 9/20/2013 11:16:13 AM 
Event time (UTC): 9/20/2013 5:46:13 AM 
Event ID: 4734b834495a4bde96c7dabba3b5d0d4 
Event sequence: 7 
Event occurrence: 1 
Event detail code: 0 
 
Application information: 
    Application domain: /LM/W3SVC/1824670420/ROOT-2-130241295584824445 
    Trust level: WSS_Minimal 
    Application Virtual Path: / 
    Application Path: C:\inetpub\wwwroot\wss\VirtualDirectories\42916\ 
    Machine name: PRASHANT-PC 
 
Process information: 
    Process ID: 7272 
    Process name: w3wp.exe 
    Account name: PRASHANT-PC\PRASHANT 
 
Exception information: 
    Exception type: TargetInvocationException 
    Exception message: Exception has been thrown by the target of an invocation. 
 
Request information: 
    Request URL: http://prashant-pc:42916/_layouts/Diary.aspx 
    Request path: /_layouts/Diary.aspx 
    User host address: 192.xxx.x.xxx
    User: PRASHANT-PC\PRASHANT
    Is authenticated: True 
    Authentication Type: NTLM 
    Thread account name: PRASHANT-PC\PRASHANT 
 
Thread information: 
    Thread ID: 15 
    Thread account name: PRASHANT-PC\PRASHANT 
    Is impersonating: False 
    Stack trace:    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Telerik.Web.UI.GridBoundColumn.GetAggregate(IEnumerable enumerable, IQueryable queryable, String fieldName, Type dataType, GridAggregateFunction func)
   at Telerik.Web.UI.GridBoundColumn.ApplyAggregates35(TableCell cell, String footerText)
   at Telerik.Web.UI.GridGroupFooterItem.Initialize(GridColumn[] columns)
   at Telerik.Web.UI.GridItem.SetupItem(Boolean dataBind, Object dataItem, GridColumn[] columns, ControlCollection rows)
   at Telerik.Web.UI.GridItemBuilder.CreateGroupFooterItem(GridGroupingContext group)
   at Telerik.Web.UI.GridItemBuilder.HandleGrouping(GridGroupingContext group, GridEnumerableBase enumerable, Boolean& isGroup, Boolean& isGroupFooter)
   at Telerik.Web.UI.GridItemBuilder.CreateItems(GridGroupingContext group)
   at Telerik.Web.UI.GridTableView.CreateItems(IEnumerator enumerator, GridColumn[] columns, ControlCollection controls)
   at Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
   at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at Telerik.Web.UI.GridTableView.PerformSelect()
   at Telerik.Web.UI.GridTableView.DataBind()
   at Telerik.Web.UI.RadGrid.DataBind()
   at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
   at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details: 

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="ASP.NET 2.0.50727.0" />
    <EventID Qualifiers="32768">1309</EventID>
    <Level>3</Level>
    <Task>3</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-09-20T05:46:13.000000000Z" />
    <EventRecordID>51354</EventRecordID>
    <Channel>Application</Channel>
    <Computer>PRASHANT-PC</Computer>
    <Security />
  </System>
  <EventData>
    <Data>3005</Data>
    <Data>An unhandled exception has occurred.</Data>
    <Data>9/20/2013 11:16:13 AM</Data>
    <Data>9/20/2013 5:46:13 AM</Data>
    <Data>4734b834495a4bde96c7dabba3b5d0d4</Data>
    <Data>7</Data>
    <Data>1</Data>
    <Data>0</Data>
    <Data>/LM/W3SVC/1824670420/ROOT-2-130241295584824445</Data>
    <Data>WSS_Minimal</Data>
    <Data>/</Data>
    <Data>C:\inetpub\wwwroot\wss\VirtualDirectories\42916\</Data>
    <Data>PRASHANT-PC</Data>
    <Data>
    </Data>
    <Data>7272</Data>
    <Data>w3wp.exe</Data>
    <Data>PRASHANT-PC\PRASHANT</Data>
    <Data>TargetInvocationException</Data>
    <Data>Exception has been thrown by the target of an invocation.</Data>
    <Data>http://prashant-pc:42916/_layouts/Diary.aspx</Data>
    <Data>/_layouts/Diary.aspx</Data>
    <Data>192.xxx.x.xx</Data>
    <Data>PRASHANT-PC\PRASHANT</Data>
    <Data>True</Data>
    <Data>NTLM</Data>
    <Data>PRASHANT-PC\PRASHANT</Data>
    <Data>15</Data>
    <Data>PRASHANT-PC\PRASHANT</Data>
    <Data>False</Data>
    <Data>   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct&amp; sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Telerik.Web.UI.GridBoundColumn.GetAggregate(IEnumerable enumerable, IQueryable queryable, String fieldName, Type dataType, GridAggregateFunction func)
   at Telerik.Web.UI.GridBoundColumn.ApplyAggregates35(TableCell cell, String footerText)
   at Telerik.Web.UI.GridGroupFooterItem.Initialize(GridColumn[] columns)
   at Telerik.Web.UI.GridItem.SetupItem(Boolean dataBind, Object dataItem, GridColumn[] columns, ControlCollection rows)
   at Telerik.Web.UI.GridItemBuilder.CreateGroupFooterItem(GridGroupingContext group)
   at Telerik.Web.UI.GridItemBuilder.HandleGrouping(GridGroupingContext group, GridEnumerableBase enumerable, Boolean&amp; isGroup, Boolean&amp; isGroupFooter)
   at Telerik.Web.UI.GridItemBuilder.CreateItems(GridGroupingContext group)
   at Telerik.Web.UI.GridTableView.CreateItems(IEnumerator enumerator, GridColumn[] columns, ControlCollection controls)
   at Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
   at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
   at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   at Telerik.Web.UI.GridTableView.PerformSelect()
   at Telerik.Web.UI.GridTableView.DataBind()
   at Telerik.Web.UI.RadGrid.DataBind()
   at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
   at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
</Data>
  </EventData>
</Event>

      

[Tsvetoslav]

Hi Swapnil,

RadGrid is not tailored to work with SharePoint Lists. It can get you to a certain point but it's good only as far as it goes.
 
Regards,
Tsvetoslav
Telerik