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

Toggling Feature not exported with the data

14 Answers 198 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Parth
Top achievements
Rank 1
Parth asked on 13 Dec 2011, 07:51 PM

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

14 Answers, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 14 Dec 2011, 11:48 AM
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!

0
Najah
Top achievements
Rank 1
answered on 17 Feb 2012, 10:55 AM
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
0
Steve
Telerik team
answered on 17 Feb 2012, 11:02 AM
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 >>
0
Pratap
Top achievements
Rank 2
answered on 15 Jul 2015, 12:53 PM

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.

0
Stef
Telerik team
answered on 17 Jul 2015, 03:03 PM
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
0
Daniel
Top achievements
Rank 1
answered on 26 Oct 2015, 10:21 AM

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

0
Stef
Telerik team
answered on 26 Oct 2015, 03:44 PM
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
0
Daniel
Top achievements
Rank 1
answered on 27 Oct 2015, 02:41 PM

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

0
Accepted
Daniel
Top achievements
Rank 1
answered on 27 Oct 2015, 02:55 PM

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

0
Tyler
Top achievements
Rank 1
answered on 10 Apr 2020, 06:17 PM
Has there been any change in this functionality?  I see the last post was from 2015.  I would like to export to excel with the toggle feature.
0
Todor
Telerik team
answered on 15 Apr 2020, 12:55 PM

Hello Tyler,

The functionality hasn't been modified. You may check the Expand/Collapse All Toggle Visibility Actions Simultaneously KB article for a workaround.

Regards,
Todor
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Tyler
Top achievements
Rank 1
answered on 15 Apr 2020, 02:27 PM

Thank you Todor,

I am looking to export to excel with grouping.  I have found ways to expand collapse all in a table in a much simpler way than the article.  (I added the action toggle to the highest level / header of the table).  I was researching and found that there is an ExportBegins event that may be used to accomplish this.  In Args, there is a handled property that if true will prevent further execution.  Is there a way we can use this to manually group excel ranges in a report?  We would basically build the workbook manually.  Is there a .cs file available that we could examine to accomplish this?

 

 

0
Tyler
Top achievements
Rank 1
answered on 15 Apr 2020, 10:50 PM

Hi Todor,

As a work around to exporting to excel with grouping, we would like to export to excel with filtering enabled on all header rows of a table.  What is the easiest way to go about this?  I am not looking to filter data in the report but to apply the excel filter when exporting.

0
Todor
Telerik team
answered on 20 Apr 2020, 09:38 AM

Hello Tyler,

Indeed, the Report Viewer's exportBegin event handler you may cancel report export if the required document format is Excel. Then, you may use the ReportProcessor to render the report in Excel format, and modify the Excel document as required before sending it to the client. See Exporting a report to a single document format for sample code and details on programmatic report export.

Regards,
Todor
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Tags
General Discussions
Asked by
Parth
Top achievements
Rank 1
Answers by
Elian
Telerik team
Najah
Top achievements
Rank 1
Steve
Telerik team
Pratap
Top achievements
Rank 2
Stef
Telerik team
Daniel
Top achievements
Rank 1
Tyler
Top achievements
Rank 1
Todor
Telerik team
Share this question
or