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>
Unplanned
Last Updated:
23 Nov 2016 13:49
by ADMIN
ADMIN
Created by:
Konstantin Dikov
Comments:
0
Category:
PivotGrid
Type:
Feature Request
Unplanned
Last Updated:
21 Oct 2020 15:37
by ADMIN
Created by:
Serdar
Comments:
1
Category:
PivotGrid
Type:
Feature Request
It will be useful to have sorting feature in PivotGridAggregateField. For example as in attachment one may want to sort the grades of students as me :) Looking forward to have sorting feature in new releases.
Unplanned
Last Updated:
22 Sep 2016 09:28
by Trilochan
ADMIN
Created by:
Konstantin Dikov
Comments:
2
Category:
PivotGrid
Type:
Feature Request
Unplanned
Last Updated:
01 Jun 2020 16:23
by ADMIN
Created by:
Marcin
Comments:
2
Category:
PivotGrid
Type:
Feature Request
I have a scenario in my web application where I need possibility to sort values in RadPivotGrid by field existing in datasource, but is not displayed in RadPivotGrid. For Example I have flats that should be sorted in order defined in field sort_order, I can add this field to RadPivotGrid, but I don't want to show it to user. This approach works perfectly with standard RadGrid, but unfortunately does not work with RadPivotGrid. Flats are sorted by their names, with is wrong from my point of view.
Unplanned
Last Updated:
14 Jun 2021 13:56
by ADMIN
ADMIN
Created by:
Angel Petrov
Comments:
1
Category:
PivotGrid
Type:
Feature Request
Unplanned
Last Updated:
29 Apr 2014 16:03
by Benoit
ADMIN
Created by:
Angel Petrov
Comments:
2
Category:
PivotGrid
Type:
Feature Request
Unplanned
Last Updated:
08 Jan 2021 12:44
by ADMIN
Created by:
Julian
Comments:
0
Category:
PivotGrid
Type:
Feature Request
When adding a calculated column to give you something like the Avg Price. The column appears across the whole pivot grid. So say you have your totalprice and qty showing for different stores. So the grid groups by stores. When you add the grandtotal calculation you get a new column added to each store. I don't want the avg price added to each store .. I only want to see the average price in the grand totals section to the right? Thanks.
Unplanned
Last Updated:
18 Jun 2020 15:05
by ADMIN
Created by:
Chris
Comments:
0
Category:
PivotGrid
Type:
Feature Request
Would be good if ajax pivotgrid filter window supported OLAP dimension hierarchies The Filter window / popup, doesn't seem to respect an OLAP dimension hierarchy. It just shows a flat list at top level (for example case of date hierarchy just shows year). See attached for a date hierarchy example in three different cube browsers, each with the same OLAP SSAS backend. Browsers are a) ajax pivot grid, b) kendo pivot grid and c) excel The Ajax version just shows flat list, whereas kendo pivot and excel show the hierarchy Thanks Chris
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:
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
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.
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:
23 Mar 2015 08:11
by ADMIN
ADMIN
Created by:
Maria Ilieva
Comments:
0
Category:
PivotGrid
Type:
Feature Request
Unplanned
Last Updated:
03 Nov 2020 11:18
by ADMIN
ADMIN
Created by:
Viktor Tachev
Comments:
1
Category:
PivotGrid
Type:
Feature Request
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>
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.
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;
}