Reporting Services - Export Data to Excel In Only One Sheet

Question

Hello everyone,

I'm using SSRS 2005. In my report, I'm getting data to a table with paging(use with grouping). It's ok. But when I export data to Excel file, RS divide data within multiple sheet.

How can I get data in only one sheet while exporting to Excel?

Answer 1

It can't be done. Remove the page breaks, or live with it.

Answer 2

But when I remove page breaks, table cannot perform paging.

Answer 3

You may want to check out Aspose, a commercial rendering extension engine for SSRS. We've used it for exporting reports to Word with Korean characters and it works great. They provide good support as well.