Telerik Report - groups for columns

1 Answer 49 Views
General Discussions Report Designer - Web
Ionut
Top achievements
Rank 1
Ionut asked on 20 Dec 2021, 12:53 PM | edited on 20 Dec 2021, 12:56 PM

Hy,

I creating a new telerik report and I want this report to export in excel. This new report has a table where a define my columns but I want my last 3 columns when I make a excel export (I select the option Excel Worksheet, see the PNG img for more info) to be in a group.  Is there an option from telerik report to make the excel export create this group?

I also attached an excel file to see how I want my output (that +/- is my group, when I press + it show my columns and when I press - it hide my columns).

If you need more details, please let me know.

 

 

 

 

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 23 Dec 2021, 07:54 AM

Hello Ionut,

Generally, the required functionality would be achieved in a report with the Drilldown/Toggle Visibility Action. Unfortunately, our Excel rendering doesn't support actions other than Navigate to URL - see Excel Rendering Interactivity. For that reason, the generated XLSX file cannot have the Excel column groups embedded.

As a workaround, you may use a third-party tool to manipulate the rendered XLSX report before sending it to the user. For example,  with Telerik Document Processing you may add the required grouping as explained in the SpreadProcessing  - Grouping article.

We have two feature requests on similar requirements that you may want to vote for:

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
General Discussions Report Designer - Web
Asked by
Ionut
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or