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

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

1 Answer 30 Views
Sharepoint Integration
This is a migrated thread and some comments may be shown as answers.
Swapnil
Top achievements
Rank 1
Swapnil asked on 19 Sep 2013, 01:05 PM
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>

      

1 Answer, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 24 Sep 2013, 11:34 AM
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
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Sharepoint Integration
Asked by
Swapnil
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Share this question
or