This is a migrated thread and some comments may be shown as answers.

Export report to multiple Excel worksheets

3 Answers 144 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Joe
Top achievements
Rank 1
Joe asked on 15 Mar 2018, 04:07 PM

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!

3 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 20 Mar 2018, 11:20 AM
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
0
Keith
Top achievements
Rank 1
answered on 19 Jun 2018, 06:53 PM

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.

 

0
Nasko
Telerik team
answered on 22 Jun 2018, 01:44 PM
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
Tags
General Discussions
Asked by
Joe
Top achievements
Rank 1
Answers by
Katia
Telerik team
Keith
Top achievements
Rank 1
Nasko
Telerik team
Share this question
or