Progress® Telerik® UI for ASP.NET AJAX Feedback Portal

Unplanned

Last Updated: 18 Apr 2024 09:59 by omti

Bug about click the pagination button.

Created by: omti

Comments: 0

Category: PivotGrid

Type: Bug Report

Bug about click the pagination button.

When the RadPivotGrid is Ajaxified from the RadAjaxManager, the paging functionality doesn't work as intended.

Steps to reproduce:

Have an Ajaxified PivotGrid
Change the page size (from 10 to 20)
Click the go to next/previous page or first/last page button

Unplanned

Last Updated: 25 Jan 2024 16:33 by Raul

Showing and then hiding a field before the update will still show the field after the update

Created by: Raul

Comments: 0

Category: PivotGrid

Type: Bug Report

Showing and then hiding a field before the update will still show the field after the update

The issue can be replicated in the OLAP and KPIs Support demo.

Steps to replicate the issue:

Add an item to the "Row Fields" by checking the checkbox of the item in the "All Fields" panel
Remove the item from the "Row Fields" by unchecking the checkbox of the item in the "All Fields" panel
Click the Update button
After the PostBack the PivotGrid will display the Item in the "Row Fields" despite it was removed soon after adding it.

Unplanned

Last Updated: 07 Oct 2022 12:45 by Raul

Unexpected behavior when moving filtered field from Column Fields to Filter Fields

Created by: Raul

Comments: 0

Category: PivotGrid

Type: Bug Report

Unexpected behavior when moving filtered field from Column Fields to Filter Fields

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

Unplanned

Last Updated: 08 Jul 2021 06:02 by ADMIN

RadPivotGrid getting Error Message - An item with the same key has already been added

Created by: Amit

Comments: 0

Category: PivotGrid

Type: Bug Report

RadPivotGrid getting Error Message - An item with the same key has already been added

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: 13 Jul 2021 13:40 by ADMIN

PivotGrid - OLAP Encoding error

Created by: Alan

Comments: 1

Category: PivotGrid

Type: Bug Report

PivotGrid - OLAP Encoding error

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>

Anyway, hoping you can consider this request. Alan

Unplanned

Last Updated: 28 Jun 2021 13:43 by ADMIN

Row height misaligned when scrolling is enabled and Bootstrap Skin

Created by: Valerio

Comments: 1

Category: PivotGrid

Type: Bug Report

Row height misaligned when scrolling is enabled and Bootstrap Skin

When the scrolling is enabled and Skin set to Bootstrap, the rows are misaligned:

Completed

Last Updated: 25 Feb 2021 16:04 by ADMIN

Release 2021 R1 SP1

NullReferenceException is thrown if EnableConfigurationPanel is set to True and no data is bound to the PivotGrid

Created by: Daniel

Comments: 1

Category: PivotGrid

Type: Bug Report

NullReferenceException is thrown if EnableConfigurationPanel is set to True and no data is bound to the PivotGrid

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>

Completed

Last Updated: 03 Jun 2020 16:50 by ADMIN

Release R2 2020 SP1

Filter Window Values Cutoff

Created by: Fernando

Comments: 1

Category: PivotGrid

Type: Bug Report

Filter Window Values Cutoff

The appearance problem can be seen on http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx.

Click on the filter icon for Product name, you will find that the save and cancel buttons are off-screen. And if you hover over Label Filters or Value Filters the window is not wide enough to fit the popout menus that show:

Unplanned

Last Updated: 17 May 2019 06:57 by ADMIN

RadPivotGrid DataCellStyle CssClass not getting applied

Created by: Kasim

Comments: 3

Category: PivotGrid

Type: Bug Report

RadPivotGrid DataCellStyle CssClass not getting applied

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: 18 Jun 2020 16:35 by ADMIN

ADMIN

RadPivotGrid bound with OLAP throws an exception if more than one fields are dropped in the filter zone

Created by: Eyup

Comments: 1

Category: PivotGrid

Type: Bug Report

RadPivotGrid bound with OLAP throws an exception if more than one fields are dropped in the filter zone

The full stract trace of the error can be found in the attached file.

Unplanned

Last Updated: 18 Oct 2018 09:37 by Lee

ADMIN

Wrong results are returned when a null-values-containing column is filtered

Created by: Vessy

Comments: 1

Category: PivotGrid

Type: Bug Report

Wrong results are returned when a null-values-containing column is filtered

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: 02 Jun 2017 15:43 by ADMIN

ADMIN

In lightweight, only sort icon triggers sorting, instead of the whole field, making it impossible to sort after natural sorting is applied.

Created by: Vasil

Comments: 0

Category: PivotGrid

Type: Bug Report

In lightweight, only sort icon triggers sorting, instead of the whole field, making it impossible to sort after natural sorting is applied.

Unplanned

Last Updated: 08 Nov 2016 16:57 by ADMIN

ADMIN

PivotGrid saved persistence settings are not correct if Date Field have multi dimentions like Year/Month/Week etc.

Created by: Vasil

Comments: 0

Category: PivotGrid

Type: Bug Report

PivotGrid saved persistence settings are not correct if Date Field have multi dimentions like Year/Month/Week etc.

Declined

Last Updated: 28 Mar 2019 16:23 by ADMIN

dynamic pivot

Created by: jose antonio

Comments: 1

Category: PivotGrid

Type: Bug Report

dynamic pivot

When setting datasource if the data is a dynamic type it wont render anything.

My type is IEnumerable<dynamic>

Cheers

Completed

Last Updated: 17 Jul 2015 11:53 by ADMIN

ADMIN

RadPivotGrid throws an exception if a filtered PivotGridColumnField is dropped in the filter zone

Created by: Angel Petrov

Comments: 0

Category: PivotGrid

Type: Bug Report

RadPivotGrid throws an exception if a filtered PivotGridColumnField is dropped in the filter zone

Completed

Last Updated: 06 Aug 2015 05:31 by ADMIN

ADMIN

When a CellStyle-Width is set for the PivotGridRowField and scrolling is enabled a white area appears inside the content zone

Created by: Angel Petrov

Comments: 0

Category: PivotGrid

Type: Bug Report

When a CellStyle-Width is set for the PivotGridRowField and scrolling is enabled a white area appears inside the content zone

Completed

Last Updated: 16 Jul 2015 07:54 by ADMIN

ADMIN

In some skins the filter icon in the pivot contains an additional dot.

Created by: Angel Petrov

Comments: 0

Category: PivotGrid

Type: Bug Report

In some skins the filter icon in the pivot contains an additional dot.

Won't Fix

Last Updated: 24 Jun 2015 08:32 by ADMIN

ADMIN

RadPivotGrid export throws an error when using a GetDataItem() in tempaltes.

Created by: Kostadin

Comments: 2

Category: PivotGrid

Type: Bug Report

RadPivotGrid export throws an error when using a GetDataItem() in tempaltes.

Won't Fix

Last Updated: 05 Jun 2015 10:19 by ADMIN

ADMIN

When the column name was composed with Chinese words "Multiple controls with the same ID 'rc_' were found. FindControl requires that controls have unique IDs" error is thrown

Created by: Pavlina

Comments: 0

Category: PivotGrid

Type: Bug Report

When the column name was composed with Chinese words "Multiple controls with the same ID 'rc_' were found. FindControl requires that controls have unique IDs" error is thrown

The asp framework generates these IDs and we don't have control on them.

Won't Fix

Last Updated: 14 Sep 2021 12:11 by ADMIN

ADMIN

RadPivotGrid selected measure is with wrong title in "AGGREGATE FIELDS" box when Olap data source is used

Created by: Pavlina

Comments: 0

Category: PivotGrid

Type: Bug Report

RadPivotGrid selected measure is with wrong title in "AGGREGATE FIELDS" box when Olap data source is used