Exporting a report to Excel

I am trying to export a report for SQL Reporting Services Report to
Excel. Unfortunately the number of rows in my report are greater that
the maximum allowable 65536 rows in an Excel sheet. Does anyone have a
workaround that would allow for a SQL Reporting Services Report to be
exported to Excel spread out over multiple sheets to make up for the
65536 row limitation?If you have groups in your report, you can set the Group page break options
on the grouping ans sorting tab. When exporting to Excel, each group becomes
a separate
worksheet in the workbook file. I don't recall what the worksheet limit is.
The one problem is that you cannot title each page, so they come out as
sheet1, sheet2, ... sheet(n)
"jbaldwin00@.gmail.com" wrote:
> I am trying to export a report for SQL Reporting Services Report to
> Excel. Unfortunately the number of rows in my report are greater that
> the maximum allowable 65536 rows in an Excel sheet. Does anyone have a
> workaround that would allow for a SQL Reporting Services Report to be
> exported to Excel spread out over multiple sheets to make up for the
> 65536 row limitation?
>sql