Completed
Last Updated: 08 Jul 2014 12:37 by Tanvir
ADMIN
Created by: Ivan Todorov
Comments: 7
Category: PivotGrid
Type: Feature Request
23
It should be possible to persist the current configuration of RadPivotGrid so that when the settings are loaded, the settings of the RadPivotGrid should appear as when they were saved. This includes the column/row/filter/aggregate descriptors, the width/height of the resized rows/columns and the applied filters.
Completed
Last Updated: 18 Sep 2013 19:32 by Jesse Dyck
ADMIN
Created by: Stefan
Comments: 3
Category: PivotGrid
Type: Feature Request
22
ADD. RadPivotGrid - add export to excel functionality
Completed
Last Updated: 18 Feb 2013 08:54 by ADMIN
ADMIN
Created by: Stefan
Comments: 0
Category: PivotGrid
Type: Feature Request
10
ADD. RadPivotGrid - add localization provider
Completed
Last Updated: 11 Jan 2017 13:11 by ADMIN
RadPivotGrid Implement logic when the user clicks on a cell to get the underlying data
Completed
Last Updated: 28 Jul 2020 09:02 by ADMIN
The group description now has AutoShowSubTotals property determining whether subtotals will be generated for the description:

this.radPivotGrid1.RowGroupDescriptions.Add(new DateTimeGroupDescription
{
    PropertyName = "OrderDate",
    Step = DateTimeStep.Quarter,
    GroupComparer = new GroupNameComparer(),
    AutoShowSubTotals = false
});
Completed
Last Updated: 03 Jan 2017 13:00 by ADMIN
ADMIN
Created by: Dess | Tech Support Engineer, Principal
Comments: 0
Category: PivotGrid
Type: Feature Request
6
Until the feature gets implemented create a custom PivotFieldListVisualItem and translate each of the items individually:

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
 
        this.radPivotFieldList1.RowLabelsControl.CreatingVisualListItem += ListControl_CreatingVisualListItem;
        this.radPivotFieldList1.ColumnLabelsControl.CreatingVisualListItem += ListControl_CreatingVisualListItem;
        this.radPivotFieldList1.ReportFiltersControl.CreatingVisualListItem += ListControl_CreatingVisualListItem;
        this.radPivotFieldList1.ValuesControl.CreatingVisualListItem += ListControl_CreatingVisualListItem;
    }
 
    private void ListControl_CreatingVisualListItem(object sender, CreatingVisualListItemEventArgs args)
    {
        args.VisualItem = new MyPivotFieldListVisualItem(this.radPivotFieldList1.ViewModel);
    }
}
 
public class MyPivotFieldListVisualItem : PivotFieldListVisualItem
{
    public MyPivotFieldListVisualItem(FieldListViewModel viewModel)
        : base(viewModel) { }
 
    protected override void CreateChildElements()
    {
        base.CreateChildElements();
 
        CommandBarDropDownButton btn = this.GetType().BaseType
            .GetField("button", BindingFlags.Instance | BindingFlags.NonPublic)
            .GetValue(this) as CommandBarDropDownButton;
 
        if (btn != null)
        {
            btn.DropDownMenu.PopupOpening += DropDownMenu_PopupOpening;
        }
    }
 
    private void DropDownMenu_PopupOpening(object sender, System.ComponentModel.CancelEventArgs args)
    {
        foreach (RadItem item in ((RadDropDownMenu)sender).Items)
        {
            // Validate and localize each of the items
            if (item is RadMenuItem)
            {
                item.Text = "MyText";
            }
        }
    }
}
Completed
Last Updated: 27 Mar 2013 14:20 by Jesse Dyck
ADMIN
Created by: Ivan Todorov
Comments: 1
Category: PivotGrid
Type: Feature Request
5
Implement "Calculated Fields" support in RadPivotGrid
Unplanned
Last Updated: 15 Aug 2017 09:41 by Markus
Currently the AdomdDataProvider supports only AdomdClient version 10.0 which supports Microsoft SQL Server 2008. Add support for newer versions.
Unplanned
Last Updated: 11 May 2022 06:07 by ADMIN
ADMIN
Created by: Dimitar
Comments: 2
Category: PivotGrid
Type: Feature Request
5
One should be able to move the selected cell and scroll with the arrow keys. The attached project features a solution for moving the currently selected cell using the arrow keys.
Completed
Last Updated: 11 Dec 2015 14:55 by ADMIN
Add the ability to export to OpenXML format, specifically ".xlsx".
Completed
Last Updated: 05 Jun 2014 07:07 by Jesse Dyck
ADMIN
Created by: Peter
Comments: 1
Category: PivotGrid
Type: Feature Request
3
Add support for custom calculated items.
For example: Users should be able to calculate the subtotal for the given column based on other columns subtotals.
Unplanned
Last Updated: 02 Oct 2020 07:54 by ADMIN
Created by: Chris
Comments: 1
Category: PivotGrid
Type: Feature Request
3

Hello,

I am using the pivot grid control would like to know if it is possible to add a start and end to the grouping?

My pivot grid looks like this: I would like the user to be able to specify a start and end for the grouping.

Excel has this option:

 

How can I replicate this functionality?

Unplanned
Last Updated: 15 Aug 2017 09:36 by ADMIN
Currently, you can only copy the contents of the data cells to the clipboard and it is not possible to include the column/row header names.
Completed
Last Updated: 21 Jul 2015 10:12 by ADMIN
ADMIN
Created by: Dimitar
Comments: 1
Category: PivotGrid
Type: Feature Request
3
Add the ability to export in pdf format.
Unplanned
Last Updated: 05 Dec 2023 23:11 by FEAP
ADMIN
Created by: Ivan Todorov
Comments: 1
Category: PivotGrid
Type: Feature Request
3
Add functionality which will allow the end users to edit the aggregated data. The new values should be passed back to the business logic of the application which will decide how to divide the new value across underlying records.
Unplanned
Last Updated: 15 Aug 2017 10:08 by ADMIN
Unplanned
Last Updated: 15 Aug 2017 09:41 by ADMIN
ADMIN
Created by: Peter
Comments: 0
Category: PivotGrid
Type: Feature Request
2
AutoSizeRows property which allows autosizing both header rows and data rows.
Unplanned
Last Updated: 15 Aug 2017 09:36 by ADMIN
ADD. RadPivotGrid - add ability to filter by more than one condition - composite filters
1 2 3