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& 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)
</Data>
</EventData>
</Event>
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& 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)
</Data>
</EventData>
</Event>