Toggling Feature not exported with the data

10 posts, 1 answers
  1. Parth
    Parth avatar
    19 posts
    Member since:
    Aug 2010

    Posted 13 Dec 2011 Link to this post


    I have a crosstab report with expand/collapse functionality (toggling in Telerik). When I export the data the toggling (grouping in excel) is not exported with the data. Is there a way to do this ? I want to export the report with all the functionalities.

    Find the attached image file for more information.

    Thanks,
    Parth
  2. Elian
    Admin
    Elian avatar
    435 posts

    Posted 14 Dec 2011 Link to this post

    Hello Parth,

    As stated in our Excel Rendering Considerations, the interactivity in excel formats is limited to:
    Microsoft Excel 2007 and above format supports hyperlinks, which are rendered as Excel hyperlinks in the cell in which the text is rendered. Microsoft Excel 97-2003 format does not support any interactive features.
    So in short, drill-down actions are not supported in excel.

    Best wishes,
    Elian
    the Telerik team

    Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

  3. DevCraft banner
  4. Sunny
    Sunny avatar
    18 posts
    Member since:
    Jan 2007

    Posted 17 Feb 2012 Link to this post

    I am trying to create the same drill down but don't know how to have the expand collapse fearture. Can you please help a little. It's not explained in the video either.

    Many thanks,
    Sana
  5. Steve
    Admin
    Steve avatar
    10941 posts

    Posted 17 Feb 2012 Link to this post

    Hello Sana,

    Check the following links and video:

    Greetings,
    Steve
    the Telerik team
    Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
  6. Pratap
    Pratap avatar
    6 posts
    Member since:
    Jan 2015

    Posted 15 Jul 2015 in reply to Elian Link to this post

    Hello Elian,

                      I am facing the same problem and i am using Telerik reporting Q1 2015. Is it possible to export report to excel 2007 for getting toggling feature in Q1 2015.

  7. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 17 Jul 2015 Link to this post

    Hello Pratap,

    Reports are rendered in Excel based on the Design Considerations for Excel Rendering(includes descriptions of both XLS and XLSX formats), where the native Excel groups (collapse/expand regions) are not supported.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  8. Daniel
    Daniel avatar
    4 posts
    Member since:
    Oct 2015

    Posted 26 Oct 2015 in reply to Stef Link to this post

    Hi Stef,

     We have some drill down reports created in Telerik stand alone report designer and we have hosted it in ASP.net web application using telerik Reportviewer control. When we export the report into excel the entire results are exported, but our client want to have the collapsed/aggregated records and the details separately when exporting to excel as they are displayed in the report. The + symbol is not appearing in the excel. I have given the screenshots.

    Thanks,

    Daniel

  9. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 26 Oct 2015 Link to this post

    Hello Daniel,

    Drill-down actions are not supported in Excel format. For more details, please check my previous post in the thread.

    Regards,
    Stef
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  10. Daniel
    Daniel avatar
    4 posts
    Member since:
    Oct 2015

    Posted 27 Oct 2015 in reply to Stef Link to this post

    Hi Stef,

     Thanks for the information. Do we have an option to expand all the group of a drill down report from a single user event like, expand-all option. Currently when drill down is collapsed and when we export data to excel only the collapsed data is exported.

    I am exploring this option because if user has 100 groups and he wants to export the entire dataset then it will be difficult for the user to expand all the drill down groups to export the data.

    Thanks,

    Daniel

  11. Answer
    Daniel
    Daniel avatar
    4 posts
    Member since:
    Oct 2015

    Posted 27 Oct 2015 in reply to Daniel Link to this post

    Hi Stef,

     I have implemented the expand all option in Telerik report designer by adding a check box and Checkbox properties -> action ->selecte toggle visibility option ->Edit toggle targets to expand and display the drill down details.

    thanks,

    Daniel

Back to Top
DevCraft banner