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

2 posts, 0 answers
  1. Swapnil
    Swapnil avatar
    96 posts
    Member since:
    Aug 2013

    Posted 19 Sep 2013 Link to this post

    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>

          

  2. Tsvetoslav
    Admin
    Tsvetoslav avatar
    1823 posts

    Posted 24 Sep 2013 Link to this post

    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.

Back to Top