Excel Tabs

2 posts, 0 answers
  1. Wyatt
    Wyatt avatar
    31 posts
    Member since:
    Aug 2009

    Posted 05 Feb 2016 Link to this post

    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.

  2. Nasko
    Nasko avatar
    944 posts

    Posted 08 Feb 2016 Link to this post

    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.

    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
Back to Top