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

Multiple Page Excel Report

2 Answers 294 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brendon
Top achievements
Rank 1
Brendon asked on 19 Nov 2012, 05:43 PM
Hi. I'm currently using ActiveReports and considering switching to Telerik Reporting. One of the issues I am having is the ability to create an Excel report with multiple pages (sheets). The number of pages is unknown until the dataset is created. ActiveReports handles this, but with a restriction, when you export to XLS you cannot name the workbook sheets. Would Telerik Reporting allow me to do everything I can do already plus what I am missing?

1) Multiple reports combined inside a single export (workbook), XLS only
2) Each report has its own unique name and should be used as the sheet name

Thanks.

2 Answers, 1 is accepted

Sort by
0
Accepted
Steve
Telerik team
answered on 21 Nov 2012, 08:26 AM
Hello Brendon,

Excel in its nature is not a page oriented document format, so we're not sure whether you're not using Excel worksheet as reference to a page. To put it simply, the entire Telerik Report is rendered into a single worksheet when exported to Excel, there is no paging involved. To answer your questions:
  • You can combine multiple Telerik Reports by using a Report Book. When exporting the ReportBook to Excel, each report will occupy a separate worksheet in the Excel workbook.
  • Each worksheet of the Excel workbook will have the name of the respective report.

The above information can be found in the ReportBook Page Settings, Sizes and Naming and Design Considerations for Excel Rendering help articles.

Kind regards,
Steve
the Telerik team

HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Brendon
Top achievements
Rank 1
answered on 29 Nov 2012, 02:59 AM
Went ahead and downloaded the trial. Wired up a couple of reports inside a ReportBook and all works as expected. Each Report is exported as an individual sheet inside of a workbook in Excel. Awesome. Thanks.
Tags
General Discussions
Asked by
Brendon
Top achievements
Rank 1
Answers by
Steve
Telerik team
Brendon
Top achievements
Rank 1
Share this question
or