This is a migrated thread and some comments may be shown as answers.

GetUnderlyingData is not a member of LocalDataSourceProvider

5 Answers 97 Views
PivotGrid and PivotFieldList
This is a migrated thread and some comments may be shown as answers.
DANA
Top achievements
Rank 1
Veteran
DANA asked on 30 Jan 2020, 08:51 AM

i'm using 2015 version and can't find GetUnderlyingData Method under LocalDataSourceProvider class.

receving error - "GetUnderlyingData  is not a member of  LocalDataSourceProvider ".

please help, how can i add it or how can i override it?

5 Answers, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 30 Jan 2020, 01:58 PM
Hello, Dana,   

The GetUnderlyingData method of the LocalDataSourceProvider was introduced in R1 2017 along with the drill down functionality: https://docs.telerik.com/devtools/winforms/controls/pivotgrid/drilldown 
It is not available in older versions. Feel free to upgrade to at least this version in order to benefit from it.

I would like to note that we strive to encourage our customers to upgrade to as latest version as possible. Thus, they can benefit from all the improvements and new features introduced in the several years versions gap.  

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
DANA
Top achievements
Rank 1
Veteran
answered on 03 Feb 2020, 09:01 AM

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

 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 03 Feb 2020, 01:46 PM

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
DANA
Top achievements
Rank 1
Veteran
answered on 03 Feb 2020, 03:29 PM

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

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 04 Feb 2020, 11:48 AM
   

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

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
PivotGrid and PivotFieldList
Asked by
DANA
Top achievements
Rank 1
Veteran
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
DANA
Top achievements
Rank 1
Veteran
Share this question
or