Unplanned
Last Updated:
03 Nov 2020 14:58
by ADMIN
ADMIN
Created by:
Lance | Senior Manager Technical Support
Comments:
0
Category:
PivotGrid
Type:
Feature Request
Currently, you have ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded available for the PivotGrid. I would like to request an ExpandedGroupsBehavior that allows you to set a particular level to expand to. To better explain this, the WPF PivotGrid has this. Here is a the documentation: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/expand-behavior.html Thank you
Completed
Last Updated:
20 Sep 2016 06:29
by ADMIN
ADMIN
Created by:
Maria Ilieva
Comments:
0
Category:
PivotGrid
Type:
Feature Request
Declined
Last Updated:
28 Jul 2016 12:46
by ADMIN
Created by:
Serdar
Comments:
1
Category:
PivotGrid
Type:
Feature Request
Hi Telerik Team, I want to make a hierachy in PivotGridColumnField as in screenshot (pivotgrid_desired.png). I made a GradeBook project. It holds Student Names, Exam Names,Parent Exam Names, and Grades as in ( gradebook.rar ) . My pivotgrid screenshot is in ( pivotgrid.png ). I googled and read PivotGrid online documents but I couldn't find how to make hierarchy in columns as (pivotgrid_desired.png). Looking forward for your solution. Thanks.
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;
}
Completed
Last Updated:
04 May 2015 11:25
by ADMIN
ADMIN
Created by:
Pavlina
Comments:
0
Category:
PivotGrid
Type:
Bug Report
Unplanned
Last Updated:
14 Jun 2021 14:22
by ADMIN
Created by:
Syed
Comments:
0
Category:
PivotGrid
Type:
Feature Request
1) want to Set Column Resize for Pivot grid same like Rad Grid. Is there any way to do Column resize at runtime same like Rad grid. Customer wants the pivot grid column should be resized at runtime same like the RAD Grid.Which will be more easy and user friendly for the Customers. 2) Need Key board Navigation in Pivot grid same like Radgrid. Customer want Keyboard Navigation for Pivot Grid same like rag Grid.its hard for the customers to use scrolling for every time to see the large no of columns . Is there any way to do Key board Navigation for the Pivot grid.
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:
12 Jul 2016 15:52
by ADMIN
Created by:
Ralph
Comments:
1
Category:
PivotGrid
Type:
Feature Request
I want to display multiple grand totals with different aggreagtes. For example I want to have 3 Aggregate rows which are displaying MIN of each field, MAX of each field and AVG of each field
Unplanned
Last Updated:
18 Jun 2020 16:20
by ADMIN
ADMIN
Created by:
Marin Bratanov
Comments:
2
Category:
PivotGrid
Type:
Feature Request
The aggregates functions highlighted in the attached screenshots have common names that are used in the industry and as such they are not localized. This feature request is so that their names can be localized through global resx files along with other strings in the RadPivotGrid control.
In the meantime, you can use the ItemDataBound event to change cell texts based on your requirements. You can find similar examples here: https://demos.telerik.com/aspnet-ajax/pivotgrid/examples/appearance/conditionalformatting/defaultcs.aspx
For example, to change the Sum aggregate name in the column header, you can do this:
else if (e.Cell is PivotGridColumnHeaderCell)
{
PivotGridColumnHeaderCell cell = e.Cell as PivotGridColumnHeaderCell;
cell.Text = cell.Text.Replace("Sum ", "custom ");
Unplanned
Last Updated:
03 Nov 2020 11:18
by ADMIN
ADMIN
Created by:
Viktor Tachev
Comments:
1
Category:
PivotGrid
Type:
Feature Request
Completed
Last Updated:
30 Sep 2016 12:48
by ADMIN
ADMIN
Created by:
Maria Ilieva
Comments:
0
Category:
PivotGrid
Type:
Feature Request
PivotGrid: setting cell.CssClass to some class does not work for total cells but it does for data cells.
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:
27 Nov 2019 18:44
by ADMIN
Created by:
Daniel
Comments:
1
Category:
PivotGrid
Type:
Feature Request
Will you be adding the export button features (ShowExportToCsvButton) to the RadPivotGrid like you have in the RadGrid control?
Unplanned
Last Updated:
11 Sep 2020 12:00
by ADMIN
Created by:
Paul
Comments:
0
Category:
PivotGrid
Type:
Feature Request
The RadGrid attachment shows the Data I need to present in the form of rows of Products each with a start date.
HOWEVER, I need to present the data "per start date" so basically the Date would be a Column Header, then each date would show the duration, start time, and price under each Start Date.
The PivotGrid attachment shows how I was able to take the same data and present it with the start date as a column but is not sufficient for my needs. I need to be able to Page by Start Date, so essentially a custom pager that keeps track of the Start Date and only shows like 3 days at a time. So in the screenshot you see Sept 9th through Sept 25, however I would like to have the pager control which rows are presented and then be able to page on the date column rather than showing the full month with a horizontal scrollbar.
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;
}
Completed
Last Updated:
20 Jan 2014 12:17
by ADMIN
ADMIN
Created by:
Deyan Enchev
Comments:
0
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:
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