Export report to multiple Excel worksheets

4 posts, 0 answers
  1. Joe
    Joe avatar
    15 posts
    Member since:
    May 2016

    Posted 15 Mar 2018 Link to this post

    I'm using the standalone Report Designer, and I'm trying to export my report to Excel with each order line item on a separate sheet. My report has orders, and each order has one or more line items. Basically, our customer wants to see separate reports on each tab showing the order header data and the line item data.

    I've seen suggestions to use the Report Book feature, but we're using the standalone designer, and the report book feature seems to be a programmatic solution. I need a solution I can implement in the designer.

    Thanks!

  2. Katia
    Admin
    Katia avatar
    693 posts

    Posted 20 Mar 2018 Link to this post

    Hi Joe,

    ReportBook support was added in Standalone designer in R1 2017 release. To start creating ReportBook, choose a ReportBook report template instead of the usual template you use for creating reports. Designer will also let you to add Table of Contents (TOC) for ReportBook (it is optional).

    Using ReportBook is currently the only option to export report content on multiple sheets in Excel document. Each report in a ReportBook will occupy a separate worksheet in the Excel workbook.


    Regards,
    Katia
    Progress 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
  3. Keith
    Keith avatar
    11 posts
    Member since:
    Feb 2016

    Posted 19 Jun 2018 in reply to Katia Link to this post

    I’m writing hoping that this is not the only option, or another option may be offered in a future release.

    For example, let’s say we wanted to generate an employee payment history report where the Excel export had each employee on a different worksheet.  I am by no means an expert on Telerik Reporting, so please correct me if I’m wrong, but if my understanding is correct, that would mean multiple (and unnecessary) hits to the DB.

    The first DB hit would return the employees to report on.  If there are 100 employees, it would mean 100 Payment History InstanceReportSources would be added to a Report Book.  Then, when the Report Book is generated, each of the 100 Payment History reports would hit the DB with its given employee ID.

    Is this the way it’s supposed to work?

    Why couldn’t the Payment History report be configured to create a new Excel sheet based on a grouping of the employee ID?   That would require only 1 hit to the DB.

    Again, if I’m missing something or if there’s a better way, please educate me.

     

  4. Nasko
    Admin
    Nasko avatar
    1067 posts

    Posted 22 Jun 2018 Link to this post

    Hello Keith,

    At the moment, the only option to export a report in multiple Excel sheets is by using a Report Book. We understand this can be improved and this is why the corresponding item in our Ideas & Feedback portal has been approved - Add the ability to generate separate tabs for Excel Output. Which feature request is included in the roadmap is decided by a lot of factors and it is hard to come up with an estimate, but we take into consideration the number of likes in the feedback portal.

    Regards,
    Nasko
    Progress 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
Back to Top