This is a migrated thread and some comments may be shown as answers.
Excel Tabs
1 Answer 17 Views
This is a migrated thread and some comments may be shown as answers.
Wyatt
Top achievements
Rank 1
Wyatt asked on 05 Feb 2016, 04:42 PM

I know that I can output reports to separate Excel tabs using a Report Book, but that's not a good solution when data dynamically determines how many tabs your report should output.  For example, I have an invoice report that outputs in the following group hierarchy.

[1] Invoice Summary (new tab)
[1 to Many] Facility/Department
    Summary (new tab)
    Detail (new tab)

Ideally, there would be a report property to export Excel in a mode similar to the Web output, where only explicit page breaks result in new tabs.  I cannot believe that isn't a more common request.  My clients constantly want summary data paired with detail data.  If they said data is in the same Excel tab, converting the detail data to a table, de-merges and re-sizes all the columns, which is a difficult to use, ugly mess.

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 08 Feb 2016, 04:05 PM
Hello Wyatt,

Currently, the Report Book is the only option to create multiple worksheets in Excel. You can vote for the described feature in our Ideas & Feedback portal.

Regards,
Nasko
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
Asked by
Wyatt
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or