SQL Server Performance

Export to Excel

Discussion in 'SQL Server 2005 Reporting Services' started by albertA, Mar 19, 2007.

  1. albertA New Member

    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
  2. mahimam New Member

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

    thanks

Share This Page