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?
excelreporting-services
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?
Best Answer
Write the following expression to disable the page-break during export to excel :-