SQL Server Performance Forum – Threads Archive

Export to Excel

When I Export a report to Excel I get a separate worksheet for each page on the report.
I need to Export all the data in ONE worksheet. Is it possible to do this with a simple setting? Thanks

---

Hi,
Setting pagebreaks in your table will cause a new sheet for every pagebreak when exported to Excel. thanks

---

]]>