Telerik Report - groups for columns

[Ionut]

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.

 

 

 

 

[Todor]

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:

• Grouping Report Export to excel Expand and collapse option is missing in Excel
• Export Crosstab to Excel with grouping

Regards,
Todor
Progress Telerik