Completed
Last Updated: 10 Nov 2014 11:23 by ADMIN
To reproduce:

Open the demo application and navigate to Pivot -> Printing. Move the Aggregates descriptor next to the Product one and remove the Promotions descriptor. Click PrintPreview and you will see that the Product descriptor will not be visible
Completed
Last Updated: 24 Sep 2012 05:45 by ADMIN
To reproduce show a message box in the MouseDown event of the control and move the mouse over the data cells
Completed
Last Updated: 24 Sep 2012 05:46 by ADMIN
ADMIN
Created by: Stefan
Comments: 0
Category: PivotGrid
Type: Bug Report
0
FIX. RadPivotGrid - MouseUp is not fired for data cells
Completed
Last Updated: 27 Mar 2014 11:18 by ADMIN
ADMIN
Created by: Dess | Tech Support Engineer, Sr.
Comments: 0
Category: PivotGrid
Type: Bug Report
0
When a class implements ICustomTypeDescriptor or has a custom TypeDescriptor, the "Field chooser" in the RadPivotGrid displays the correct property display name, but the RadPivotFieldList does not.
Completed
Last Updated: 05 Jun 2014 07:07 by ADMIN
User is not able to open the Filter Popup Dialog when filter items contains DBNULL Workaround: Replace the DBNULL values with empty strings in your datatable.
Completed
Last Updated: 31 Mar 2014 10:16 by ADMIN
To reproduce: - Set the text of a GroupElement in the GroupElementFormatting event handler.
- Start the grid and resize a column for example.
- You will notice the the text is reverted to its original value.

Workaround:
- Use the following CustomGroupElement class: public class CustomGroupElement : PivotGroupElement { protected override void SynchronizeProperties() { base.SynchronizeProperties(); this.Text = "test"; } protected override Type ThemeEffectiveType { get { return typeof(PivotGroupElement); } } }
- you can replace the default element with the custom one in GroupElementCreating event handler: Private Sub radPivotGrid1_GroupElementCreating(sender As Object, e As PivotGroupElementCreatingEventArgs) e.GroupElement = New CustomGroupElement() End Sub
Completed
Last Updated: 15 Feb 2014 11:03 by ADMIN
To reproduce:

1. Open QSF => Pivot => Printing example2. Click Print settings button3. Choose layout type  - Compact4. Click Preview button and will see that there is exception

WORKAROUND:

radPivotGrid1.PrintStyle = new MyPrintStyle();        

        
Completed
Last Updated: 07 Nov 2012 03:08 by ADMIN
When RadPivotGrid is in CompactLayout mode and there is a RadChartView bound to the grid and when the selection in the grid changes, in some cases a null reference exception will be thrown.
Completed
Last Updated: 07 Nov 2012 03:11 by ADMIN
Due to an exception in the data engine, no data is displayed if there are DBNull values in the data source.
Completed
Last Updated: 08 Jan 2013 03:42 by ADMIN
If there are many row descriptions and the total width of the row headers area is larger than the width the of the control, the vertical scroll is not visible. The same applies for the horizontal scroll and the column headers area.
Completed
Last Updated: 23 Jan 2013 02:30 by ADMIN
To workaround, also add a handler to the AggregatesPositionElementCreating event.
Completed
Last Updated: 28 Mar 2014 07:12 by ADMIN
To reproduce:
- Add a pivot grid and a field list to a blank form.
- Populate the pivot grid with LocalDataSourceProvider 
- Show and close the form several times and collect the garbage.
- The memory is freed properly.
- Bind the controls and show and close the form several times again.
- After the garbage collection the memory is not freed.
Completed
Last Updated: 12 Jun 2014 10:34 by ADMIN
To reproduce:
- Change some cell properties and export the grid.
- You will notice that the the changed properties are not exported. 
Completed
Last Updated: 09 Feb 2015 11:16 by ADMIN
To reproduce:

Create a RadPivotGrid with some data and export it by following the article http://www.telerik.com/help/winforms/pivotgrid-export-to-excel.html Set the following settings to the exporter:

exporter.ShowGridLines = true;
exporter.ExportVisualSettings = true;
exporter.HeaderCellsFont = new System.Drawing.Font("Arial", 8);
exporter.DataCellsFont = new System.Drawing.Font("Arial", 8);
exporter.GridLinesColor = Color.Black;
exporter.CellBackColor = Color.White;
exporter.SheetName = this.ClientManager.CubeEngine.Title;
exporter.ExportFlatData = false;


Also subscribe to the PivotExcelCellFormatting event use the following code:

e.Cell.TextAlignment = ContentAlignment.MiddleRight;
e.Cell.DrawBorder = true;
e.Cell.BorderColor = Color.Black;
e.Cell.DrawText = true;
e.Cell.DrawFill = true;


You will see that the exported cells will not have borders, nor their font will be changed. Additionally, if you set a specific ForeColor, BackColor, it is not applied as well.
Completed
Last Updated: 27 Nov 2018 11:43 by Bailey
I came across an exception when trying to use the Report Filter area with data that contains blank (DBNull) values.  It looks like the control tries to build a distinct list of values to show in the filter's drop-down, but throws an exception if one of the values is blank.  I attached a ZIP file with a Visual Studio project that demonstrates the issue, and included a Word file to describe how to reproduce the error.  

Any assistance is greatly appreciated.  Thank you.


Drew White
Developer
CRMCulture, LLC

Email:         dwhite@CRMCulture.com
Web:          http://www.crmculture.com
Completed
Last Updated: 01 Oct 2014 13:00 by ADMIN
One cannot copy cells from collapsed row groups.
Declined
Last Updated: 23 Jul 2014 14:00 by ADMIN
DECLINED: The cells remain bold because there is no explicit setting for the Font property in the default state of the PivotCellElement. When one sets a style for a given element state, this setting will also remain for other states if they don't have an explicit setting for the same property. This is how our theming mechanism works. To resolve the issue, just set the Font property of the PivotCellElement in its default state in Visual Style Builder.

To reproduce:

Open ControlDefaultTheme in VisualStyleBuilder, go to RadPivotGrid -> RadPivotGridElement -> PivotCellElement and set bold font for the PivotCellElement.GrandTotalRow. Bind RadPivotGrid and set the properties AutoExpandColumnHeaders to false and AutoExpandRowHeaders to false. Start the application and expand the rows. You will see that the cells will be incorrectly formatted.
Completed
Last Updated: 23 Jul 2014 13:08 by ADMIN
To reproduce:

Bind a RadPivotGrid and set the theme to Breeze. You will see that there are no filtering buttons.

Workaround:

Use the following code to set an image to the buttons:

protected override void OnLoad(EventArgs e)
{
    base.OnLoad(e);

    List<PivotFilterFunctionButton> elements = this.FindAllElements<PivotFilterFunctionButton>(this.pivot.PivotGridElement);
    Image img = Image.FromFile(@"filter.png");
    foreach (PivotFilterFunctionButton item in elements)
    {
        item.Image = img;
    }
}

public List<T> FindAllElements<T>(RadElement parent)
    where T : RadElement
{
    List<T> list = new List<T>();
    this.FindAllElementsCore(parent, list);
    return list;
}

private void FindAllElementsCore<T>(RadElement parent, List<T> list)
    where T : RadElement
{
    if (parent is T)
    {
        list.Add(parent as T);
        return;
    }

    foreach (RadElement item in parent.Children)
    {
        FindAllElementsCore<T>(item, list);
    }
}

The image can be downloaded below.


Completed
Last Updated: 20 Oct 2014 14:19 by ADMIN
To reproduce: 

1. Drag and drop RadPivotGrid.
2. On FormLoad call BestFitRowHeaders() method 
3. When run the project, an exception is thrown
Completed
Last Updated: 03 Jun 2016 06:01 by ADMIN
Workaround: use custom context menu

 public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            MyPivotGridContextMenu menu = new MyPivotGridContextMenu(this.radPivotGrid1.PivotGridElement);
            this.radPivotGrid1.PivotGridElement.ContextMenu = menu;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            this.productsTableAdapter.Fill(this.nwindDataSet.Products);

            LocalDataSourceProvider dataProvider = new LocalDataSourceProvider();

            dataProvider.ItemsSource = nwindDataSet.Products;

            dataProvider.BeginInit();
            dataProvider.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "CategoryID", GroupComparer = new GroupNameComparer() });
            dataProvider.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "ProductName", GroupComparer = new GroupNameComparer() });
            dataProvider.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "ProductID" });
            dataProvider.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "UnitPrice", AggregateFunction = AggregateFunctions.Sum });
            dataProvider.EndInit();

            this.radPivotGrid1.DataProvider = dataProvider;
        }
    }

public class MyPivotGridContextMenu : PivotGridContextMenu
{
    public MyPivotGridContextMenu(RadPivotGridElement pivotGridElement)
        : base(pivotGridElement)
    { }


    protected override void OnCollapseAllMenuItemClick(object sender, EventArgs e)
    {
        PivotGroupElement groupElement = this.Context as PivotGroupElement;

        if (groupElement != null)
        {
             RadPivotGridElement pivotGridElement = this.GetType().BaseType
                .GetField("pivotGridElement", BindingFlags.Instance | BindingFlags.NonPublic)
                .GetValue(this) as RadPivotGridElement;

            pivotGridElement.SuspendLayout(true);

            if (groupElement.Data.Axis == PivotAxis.Rows)
            {
                foreach (PivotGroupNode node in pivotGridElement.GetRowGroups())
                {
                    node.Expanded = false;
                }
            }
            else
            {
                foreach (PivotGroupNode node in pivotGridElement.GetColumnGroups())
                {
                    node.Expanded = false;
                }
            }

            pivotGridElement.ResumeLayout(true, true);
            pivotGridElement.UpdateAfterExpandCollapse();
        }
    }
}