Export report to multiple Excel worksheets

[Joe]

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!

[Katia]

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

[Keith]

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.

 

[Nasko]

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