Unplanned
Last Updated:
13 Jul 2021 13:40
by ADMIN
Created by:
Alan
Comments:
1
Category:
PivotGrid
Type:
Bug Report
Hi,
At first I received the same error in this thread and applied the fixed as suggested. This works ok until I Edit Fields in the Designer. On saving the changes the OLAP settings are placed back into the code. I am then required to delete the code to fix this problem. I am constantly back-and-forth using Edit Fields while building my application.
I don't see this as a Feature Request as suggested in the thread, rather a Bug based on this behavior.
https://www.telerik.com/forums/pivotgrid-problem
<OlapSettings>
<XmlaConnectionSettings Encoding="utf-8"></XmlaConnectionSettings>
</OlapSettings>
Completed
Last Updated:
24 Sep 2014 09:01
by Bill
ADMIN
Created by:
Kostadin
Comments:
2
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
04 May 2015 11:25
by ADMIN
ADMIN
Created by:
Pavlina
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
20 Sep 2016 06:30
by ADMIN
ADMIN
Created by:
Angel Petrov
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Unplanned
Last Updated:
18 Oct 2018 09:37
by Lee
ADMIN
Created by:
Vessy
Comments:
1
Category:
PivotGrid
Type:
Bug Report
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"
OnNeedDataSource="TManagerGrid_NeedDataSource"
ShowFilterHeaderZone="true">
<Fields>
<telerik:PivotGridRowField DataField="NUM" UniqueName="NUM" ZoneIndex="10" SortOrder="Ascending">
</telerik:PivotGridRowField>
<telerik:PivotGridRowField DataField="SOURCE_LINE_ITEM" UniqueName="SOURCE_LINE_ITEM" ZoneIndex="11" SortOrder="Ascending">
</telerik:PivotGridRowField>
<telerik:PivotGridRowField DataField="SORTORDER" UniqueName="SORTORDER" ZoneIndex="12" SortOrder="Ascending">
</telerik:PivotGridRowField>
<telerik:PivotGridAggregateField DataField="NUM">
</telerik:PivotGridAggregateField>
</Fields>
</telerik:RadPivotGrid>
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;
}
Unplanned
Last Updated:
18 Jun 2020 16:35
by ADMIN
ADMIN
Created by:
Eyup
Comments:
1
Category:
PivotGrid
Type:
Bug Report
The full stract trace of the error can be found in the attached file.
Declined
Last Updated:
21 Jan 2015 12:01
by ADMIN
Created by:
Jon
Comments:
1
Category:
PivotGrid
Type:
Bug Report
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().
Completed
Last Updated:
06 Nov 2013 16:35
by ADMIN
ADMIN
Created by:
Angel Petrov
Comments:
1
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
20 Jan 2014 12:17
by ADMIN
ADMIN
Created by:
Deyan Enchev
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
08 Sep 2014 14:11
by ADMIN
ADMIN
Created by:
Konstantin Dikov
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
09 Mar 2015 07:01
by Ian
ADMIN
Created by:
Venelin
Comments:
2
Category:
PivotGrid
Type:
Bug Report
Declined
Last Updated:
29 Aug 2014 13:22
by ADMIN
ADMIN
Created by:
Angel Petrov
Comments:
1
Category:
PivotGrid
Type:
Bug Report
Completed
Last Updated:
15 Jul 2015 12:21
by Debajyoti
ADMIN
Created by:
Pavlina
Comments:
1
Category:
PivotGrid
Type:
Bug Report
Won't Fix
Last Updated:
24 Jun 2015 08:32
by ADMIN
ADMIN
Created by:
Kostadin
Comments:
2
Category:
PivotGrid
Type:
Bug Report
Unplanned
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>
</tr>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>
</tr>
Completed
Last Updated:
25 Feb 2021 16:04
by ADMIN
Release 2021 R1 SP1
Created by:
Daniel
Comments:
1
Category:
PivotGrid
Type:
Bug Report
When the EnableConfigurationPanel is enabled for the PivotGrid and is being rendered without having data bound to it, the "System.NullReferenceException: Object reference not set to an instance of an object." exception will be thrown.
To replicate the problem, add the following PivotGrid declaration to the page without binding data to it:
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" EnableConfigurationPanel="true">
</telerik:RadPivotGrid>
Unplanned
Last Updated:
28 Jun 2021 13:43
by ADMIN
Created by:
Valerio
Comments:
1
Category:
PivotGrid
Type:
Bug Report
When the scrolling is enabled and Skin set to Bootstrap, the rows are misaligned:
Unplanned
Last Updated:
08 Jul 2021 06:02
by ADMIN
Created by:
Amit
Comments:
0
Category:
PivotGrid
Type:
Bug Report
When defining more than 11 PivotGridColumnField(s), an error is thrown: "An item with the same key has already been added."
Set up to reproduce:
<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" EmptyValue="No data" AllowPaging="true" PageSize="10"
OnNeedDataSource="RadPivotGrid1_NeedDataSource">
<Fields>
<telerik:PivotGridRowField DataField="ShipCountry" UniqueName="ShipCountry">
</telerik:PivotGridRowField>
<telerik:PivotGridAggregateField DataField="Freight" UniqueName="Freight">
</telerik:PivotGridAggregateField>
<telerik:PivotGridColumnField DataField="ShipCountry1" UniqueName="ShipCountry1"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry2" UniqueName="ShipCountry2"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry3" UniqueName="ShipCountry3"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry4" UniqueName="ShipCountry4"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry5" UniqueName="ShipCountry5"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry6" UniqueName="ShipCountry6"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry7" UniqueName="ShipCountry7"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry8" UniqueName="ShipCountry8"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry9" UniqueName="ShipCountry9"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry10" UniqueName="ShipCountry10"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry11" UniqueName="ShipCountry11"></telerik:PivotGridColumnField>
<telerik:PivotGridColumnField DataField="ShipCountry12" UniqueName="ShipCountry12"></telerik:PivotGridColumnField>
</Fields>
</telerik:RadPivotGrid>C#
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{
(sender as RadPivotGrid).DataSource = OrdersTable();
}
private DataTable OrdersTable()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("OrderID", typeof(int)));
dt.Columns.Add(new DataColumn("OrderDate", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Freight", typeof(decimal)));
dt.Columns.Add(new DataColumn("ShipCountry", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry1", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry2", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry3", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry4", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry5", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry6", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry7", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry8", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry9", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry10", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry11", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry12", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry13", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry14", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry15", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry16", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry17", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry18", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry19", typeof(string)));
dt.Columns.Add(new DataColumn("ShipCountry20", typeof(string)));
dt.PrimaryKey = new DataColumn[] { dt.Columns["OrderID"] };
for (int i = 0; i < 70; i++)
{
int index = i + 1;
DataRow row = dt.NewRow();
row["OrderID"] = index;
row["OrderDate"] = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0).AddHours(index);
row["Freight"] = index * 0.1 + index * 0.01;
row["ShipCountry"] = "Country " + index;
row["ShipCountry1"] = "Country " + index;
row["ShipCountry2"] = "Country " + index;
row["ShipCountry3"] = "Country " + index;
row["ShipCountry4"] = "Country " + index;
row["ShipCountry5"] = "Country " + index;
row["ShipCountry6"] = "Country " + index;
row["ShipCountry7"] = "Country " + index;
row["ShipCountry8"] = "Country " + index;
row["ShipCountry9"] = "Country " + index;
row["ShipCountry10"] = "Country " + index;
row["ShipCountry11"] = "Country " + index;
row["ShipCountry12"] = "Country " + index;
row["ShipCountry13"] = "Country " + index;
row["ShipCountry14"] = "Country " + index;
row["ShipCountry15"] = "Country " + index;
row["ShipCountry16"] = "Country " + index;
row["ShipCountry17"] = "Country " + index;
row["ShipCountry18"] = "Country " + index;
row["ShipCountry19"] = "Country " + index;
row["ShipCountry20"] = "Country " + index;
dt.Rows.Add(row);
}
return dt;
}
Unplanned
Last Updated:
07 Oct 2022 12:45
by Raul
Created by:
Raul
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Steps to reproduce:
Use the following live demo - https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx
1. Open the filter dialog for the Year field residing in the ColumnFields and filter by selecting a single Year. (e.g. 2010)
2. Move the Year field to the Filter Fields and Update the Layout
As result, the 2010 filter is not applied anymore but opening the Filter Window keeps the same filter value still selected.
Demonstrating the issue in a basic sample - http://somup.com/c36ilGveZL
Declined
Last Updated:
17 Mar 2015 09:35
by Elena
Created by:
Roman
Comments:
1
Category:
PivotGrid
Type:
Bug Report
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.