Approved
Last Updated: 17 May 2019 06:57 by ADMIN
Created by: Kasim
Comments: 3
Category: PivotGrid
Type: Bug Report
1

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>

Pending Review
Last Updated: 16 Aug 2018 13:33 by Chris
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
Completed
Last Updated: 28 Jun 2019 04:27 by ADMIN
Created by: Tom
Comments: 3
Category: PivotGrid
Type: Feature Request
0
Hi I have a straightforward feature request: I would like to be able to "get" the row/column "filter" values the user has selected server-side. Basically need a public property or some type of getter. Currently on the PivotGrid, the row/column "Filter" "Includes/Excludes" can be "set" programmatically, but user selected values can't be easily gotten.

I would use it in a couple ways: 

1) to display context to the user for the numbers in the grid. (e.g., show the user the active filter values responsible for the numbers they are seeing in the PivotGrid Detail). 

2) I need the filter values to close Ticket 1168787.

A Telerik employee make a nice sample project to do drill-through functionality: https://www.telerik.com/blogs/how-to-implement-drill-down-functionality-in-telerik-s-pivotgrid-for-asp.net-ajax-part-2

But the PivotGrid counts and RadGrid detail data records returned are not in agreement because selected PivotGrid filters aren't applied to the detail returned in the RadGrid. I need to do that. I need to be able to mimic a drill through action into the detail records that make up the data counts. If I click a cell that says "100" (orders, 2018 year included) I need 100 orders returned in the detail. Not 7000 orders (all order years, unfiltered).

In that ticket, I'm trying to mimic the functionality similar to an SSAS "drillthrough action" (like many cube browsers have built in, e.g., RANET OLAP), except here with a regular SQL data source. This way I can drill into the detail records that make up the numbers displayed to the user in the PivotGrid. However, as it stands, the counts and detail will not be congruent until I can get the filter values selected by the user and apply them accordingly to the data set for the detail RadGrid. The BI users expect to be able to drill into the data and I need to provide it.

Thank you,

Tom


Pending Review
Last Updated: 03 May 2018 18:04 by Imported User
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 ");
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.
Approved
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"
            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;
    }
Approved
Last Updated: 23 Nov 2016 13:49 by ADMIN
Pending Review
Last Updated: 14 Nov 2016 13:21 by Subrat
Approved
Last Updated: 10 Oct 2016 11:49 by ADMIN
ADMIN
Created by: Angel Petrov
Comments: 0
Category: PivotGrid
Type: Feature Request
0

			
Declined
Last Updated: 28 Mar 2019 16:23 by ADMIN
Created by: jose antonio
Comments: 1
Category: PivotGrid
Type: Bug Report
0
When setting datasource if the data is a dynamic type it wont render anything.

My type is IEnumerable<dynamic>

Cheers
Completed
Last Updated: 30 Sep 2016 12:48 by ADMIN
PivotGrid: setting cell.CssClass to some class does not work for total cells but it does for data cells.
Declined
Last Updated: 09 Jun 2016 15:00 by ADMIN
Created by: Surya
Comments: 1
Category: PivotGrid
Type: Feature Request
0
We are able to bind the data from OLAP cube by using ADOMD data provider and XMLA data provider. How do we access multiple cubes from RadPivotGrid?
Approved
Last Updated: 01 Jun 2016 11:26 by ADMIN
ADMIN
Created by: Daniel
Comments: 0
Category: PivotGrid
Type: Feature Request
0

			
Completed
Last Updated: 20 Sep 2016 06:29 by ADMIN
ADMIN
Created by: Maria Ilieva
Comments: 0
Category: PivotGrid
Type: Feature Request
2

			
Pending Review
Last Updated: 21 Sep 2015 17:31 by Praveen
Hi Team,

Using Persisting Pivot Settings : Filter Settings is being saved in filter window after clicking cancel button
(Ex : http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/applicationscenarios/persisting-radpivotgrid-settings/defaultcs.aspx?product=persistenceframework)

1. Click on any filter icon in Pivot Grid (CategoryName filter icon)
2. Deselect first item from the list in pop up window (like Beverages)
3. Click Cancel
4. Filter is not applied on Pivot Grid which is perfect
5. Click on same filter icon (CategoryName filter icon) 
6. Observe that it is still showing first item as not selected (though the filter was cancelled and is not present on grid as well)

Expected : When we click cancel on Filter Window, the changes done should be removed.
Pending Review
Last Updated: 15 Jan 2016 12:22 by Mehmet
Created by: Brent Hetland
Comments: 1
Category: PivotGrid
Type: Feature Request
0
One of my PivotGridColumnField's is a smalldatetime field from SQL Server.

In the PivotGrid column header labels I want the dates to be formatted as MMM-yy,  like Aug-15.

I can accomplish that for the detail columns (the non-aggregate columns) by setting the DataFormatString="{0:MMM-yy}"

But that format string is NOT applied to the label of the column total header.  The aggregate column header label still reads:  "08/01/2015 00:00:00 Total"

If you allow a custom format to the detail column headers, it would be logical to assume I want that same custom format used in the aggregate column header.  So in my example, that label should display:   Aug-15 Total

I was told in the Forum that I'd have to parse that column header string in the  CellDataBound Event to get the date portion and then format it and use that to set the header text.  That is a very UGLY solution.

I don't want to strip the word "Total" out of that string and then then convert the date that remains to a string in the date format I want. 

Thanks,
Brent
Pending Review
Last Updated: 23 Jul 2015 18:51 by ADMIN
ADMIN
Created by: Lance | Technical Support Engineer, Principal
Comments: 0
Category: PivotGrid
Type: Feature Request
1
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: 17 Jul 2015 11:53 by ADMIN
1 2 3 4