Unplanned
Last Updated:
12 Oct 2023 10:31
by ADMIN
Desislava
Created on:
06 Oct 2023 13:14
Category:
PivotGrid
Type:
Bug Report
RadPivotGrid: Incorrect filter results when a Value Filter is applied from child to parent group
To reproduce the problem, use the following setup for RadPivotGrid:
public RadForm1()
{
InitializeComponent();
DataTable table = new DataTable();
table.Columns.Add("Name", typeof(string));
table.Columns.Add("Salary", typeof(int));
table.Columns.Add("Title", typeof(string));
table.Rows.Add("John",1200,"Accountant");
table.Rows.Add("Ana", 800, "Accountant");
table.Rows.Add("Sam", 2500, "Manager");
table.Rows.Add("Tom", 1300, "Manager");
this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "Title"});
this.radPivotGrid1.RowGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "Name" });
this.radPivotGrid1.AggregateDescriptions.Add(new PropertyAggregateDescription() { PropertyName = "Salary", AggregateFunction = AggregateFunctions.Sum });
this.radPivotGrid1.DataSource = table;
}
Follow the steps:
1. Filter the child group ("Name") >> Salary>1000.
This is the result of the applied filter:
2. Filter the parent group ("Title") >> Salary>1500.
After applying the filter, the observed result is that the Accountant group is still displayed even though it should be filtered and hidden (like in Excel):
Observed result:
Expected result:
3 comments
ADMIN
Dess | Tech Support Engineer, Principal
Posted on:
12 Oct 2023 10:31
SANDRO
Posted on:
06 Oct 2023 17:38
ADMIN
Dess | Tech Support Engineer, Principal
Posted on:
06 Oct 2023 13:27