GetUnderlyingData is not a member of LocalDataSourceProvider

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

i had overwrite the method ,

but i can't get the filter items in the group descriptions.

i can see the property in watch window but can't access it by code.

please help, is there a way to get the collection items of groupFilter.condition.items

thanks

Hello, Dana,   

According to the provided information, it is not clear enough the exact condition that you apply to the filter. However, note that the SetCondition offers a public Items collection:

            PropertyGroupDescriptionBase description = (PropertyGroupDescriptionBase)this.radPivotGrid1.RowGroupDescriptions[0];
            LabelGroupFilter filter = new LabelGroupFilter();
            SetCondition condition = new SetCondition();
            condition.Comparison = SetComparison.Includes;
            condition.Items.Add("UK");
            condition.Items.Add("France");
            filter.Condition = condition;
            description.GroupFilter = filter;

I have attached my sample project for your reference. Please give it a try and see how it works for your case. 

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

hi dess,

thanks for your quick respons.

i understand how to set filter to group,

but my problem is when user set filter and then i'm trying to get a drilldown view 

by getting all conditions for select statment on datasource.

i still don't understand how to get a filtered items if user set filter ontime.

please help

Hello, Dana,   

If I understand your requirement correctly, you want to extract the displayed data in RadPivotGrid after the end-user applied a filter in a version back in 2015. 

I would like to note that the introduced drill down functionality in RadPivotGrid in R1 2017 includes a very complex internal DrillDownEngine. To be honest, it is not an easy task to be integrated in an older version. Hence, the GetUnderlyingData method of the LocalDataSourceProvider is not just a single method which code can be copy-pasted. It involves a completely new engine which extracts the relevant data in parallel processing. 

The possible solution that I can suggest is to upgrade to at least R1 2017 in order to benefit from the new drill down functionality.

An alternative approach that I can suggest is to use a RadGridView instead of RadPivotGrid which provides a simpler way of extracting the filtered rows. Additional information about the filtering in RadGridView is available in the following section of the online documentation:

https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/basic-filtering
https://docs.telerik.com/devtools/winforms/controls/gridview/rows/rows-vs-childrows

If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik