Last Updated: 24 Sep 2014 09:01 by Bill
Last Updated: 04 May 2015 11:25 by ADMIN
Last Updated: 20 Sep 2016 06:30 by ADMIN
Last Updated: 08 Sep 2014 14:11 by ADMIN
Last Updated: 09 Mar 2015 07:01 by Grant
Last Updated: 29 Aug 2014 13:22 by ADMIN
Won't Fix
Last Updated: 24 Jun 2015 08:32 by ADMIN
Last Updated: 21 Jan 2015 12:01 by ADMIN
If you call Page.DataBind() in the Page_Load event handler of a page that has a RadPivotGrid on it that has an event handler for OnNeedDataSource, the OnNeedDataSource event isn't raised when the page is loaded. This behavior is different than that of other controls such as RadGrid. In my opinion it is confusing and the behavior should be the same. You may have other controls on the page that you want to data bind. So, I think it is reasonable that you should be able to call DataBind() and use advanced binding with RadPivotGrid at the same time. Also, I noticed that if you don't call DataBind(), the OnNeedDataSource event is raised twice.

Please see the Visual Studio 2012 project that I attached to this bug report for example code. Set break points in the NeedDataSource event handlers for the RadPivotGrid and RadGrid controls and run the application in debug mode to see the behavior. Comment and uncomment the call to DataBind() in Page_Load().
Last Updated: 06 Nov 2013 16:35 by ADMIN
Created by: Angel Petrov
Comments: 1
Category: PivotGrid
Type: Bug Report

Last Updated: 15 Jul 2015 12:21 by Debajyoti
Created by: Pavlina
Comments: 1
Category: PivotGrid
Type: Bug Report

Last Updated: 18 Oct 2018 09:37 by Lee
RadPivotGrid returns wrong results when a null-values-containing column is filtered.

Steps to reproduce:
1. Run the following code

2. Click the filter button on the second column and try to filter by "1" value

Result: the blank results only are shown.

<telerik:RadPivotGrid RenderMode="Lightweight" ID="TManagerGrid" runat="server" AllowFiltering="true"
                <telerik:PivotGridRowField DataField="NUM" UniqueName="NUM" ZoneIndex="10" SortOrder="Ascending">
                <telerik:PivotGridRowField DataField="SOURCE_LINE_ITEM" UniqueName="SOURCE_LINE_ITEM" ZoneIndex="11" SortOrder="Ascending">
                <telerik:PivotGridRowField DataField="SORTORDER" UniqueName="SORTORDER" ZoneIndex="12" SortOrder="Ascending">
                <telerik:PivotGridAggregateField DataField="NUM">

    protected void TManagerGrid_NeedDataSource(object sender, Telerik.Web.UI.PivotGridNeedDataSourceEventArgs e)
        TManagerGrid.DataSource = GetData();

    protected DataTable GetData()
        DataTable tbl = new DataTable();
        tbl.Columns.Add(new DataColumn("NUM"));
        tbl.Columns.Add(new DataColumn("SOURCE_LINE_ITEM"));
        tbl.Columns.Add(new DataColumn("SORTORDER"));

        tbl.Rows.Add(new object[] { "aa", 1, 20 });
        tbl.Rows.Add(new object[] { "bb", null, 30});
        tbl.Rows.Add(new object[] { "cc", 2, 50 });

        return tbl;
Pending Review
Last Updated: 19 Jan 2018 10:26 by ADMIN
The full stract trace of the error can be found in the attached file.
Last Updated: 17 May 2019 06:57 by ADMIN
Created by: Kasim
Comments: 3
Category: PivotGrid
Type: Bug Report

The code in the ASPx file is 

 <DataCellStyle CssClass="cfDataCell" Width="9%"/>

The expected output in the client browser is

 <tr style="height: 35px;">
        <td class="rpgDataCell cfDataCell" style="width:9%;">823</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">2,488</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">7,518</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">10,851</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">13,017</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">13,069</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">13,253</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">12,799</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">9,861</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">4,543</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">2,038</td>
        <td class="rpgDataCell cfDataCell" style="width:9%;">592</td>

However the generated Html is as below:

 <tr style="height: 35px;">
        <td class="rpgDataCell" style="width:9%;">823</td>
        <td class="rpgDataCell" style="width:9%;">2,488</td>
        <td class="rpgDataCell" style="width:9%;">7,518</td>
        <td class="rpgDataCell" style="width:9%;">10,851</td>
        <td class="rpgDataCell" style="width:9%;">13,017</td>
        <td class="rpgDataCell" style="width:9%;">13,069</td>
        <td class="rpgDataCell" style="width:9%;">13,253</td>
        <td class="rpgDataCell" style="width:9%;">12,799</td>
        <td class="rpgDataCell" style="width:9%;">9,861</td>
        <td class="rpgDataCell" style="width:9%;">4,543</td>
        <td class="rpgDataCell" style="width:9%;">2,038</td>
        <td class="rpgDataCell" style="width:9%;">592</td>

Last Updated: 22 Oct 2014 06:55 by ADMIN
Last Updated: 17 Mar 2015 09:35 by Elena
When try to expand inner group I get an error: System.InvalidOperationException: Sequence contains no elements.

Stack trace:
[InvalidOperationException: Sequence contains no elements]
   System.Linq.Enumerable.First(IEnumerable`1 source) +309
   Telerik.Web.UI.RadPivotGrid.AddRemoveCollapsedGroupIndexBySlot(PivotGridGroupSlot groupSlot, BaseLayout layout, HashSet`1 indexes, Boolean defaultExpanded) +287
   Telerik.Web.UI.RadPivotGrid.HandleExpandCollapse() +332
   Telerik.Web.UI.RadPivotGrid.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +484
   System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +67
   System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +123
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +33
   System.Web.UI.WebControls.DataBoundControl.PerformSelect() +138
   Telerik.Web.UI.RadPivotGrid.PerformSelect() +49
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30
   Telerik.Web.UI.RadPivotGrid.DataBind() +106
   Telerik.Web.UI.PivotGridExpandCollapseEventArgs.ExecuteCommand(Object source) +727
   Telerik.Web.UI.RadPivotGrid.OnBubbleEvent(Object source, EventArgs args) +205
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.PivotGridItem.OnBubbleEvent(Object source, EventArgs args) +121
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +114
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +159
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

Note. This happens only whe I try to expand second level in group. ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded properties ot PivotGrid is set to "false" by default.
Last Updated: 11 Sep 2014 07:45 by ADMIN
Summarize By Settings dialogue is not supported with OLAP functionality.
1 2