GetUnderlyingData is not a member of LocalDataSourceProvider

6 posts, 0 answers
  1. DANA
    DANA avatar
    20 posts
    Member since:
    Dec 2010

    Posted 30 Jan 2020 Link to this post

    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?

  2. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    4178 posts

    Posted 30 Jan 2020 Link to this post

    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.
  3. DANA
    DANA avatar
    20 posts
    Member since:
    Dec 2010

    Posted 03 Feb 2020 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    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

     

  4. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    4178 posts

    Posted 03 Feb 2020 Link to this post

    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.
  5. DANA
    DANA avatar
    20 posts
    Member since:
    Dec 2010

    Posted 03 Feb 2020 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    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

  6. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    4178 posts

    Posted 04 Feb 2020 Link to this post

       

    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.
Back to Top