Excel export | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Excel export

Hi, when I export report that has for example 4 pages to Excel format, I get an Excel file with 4 sheets. These sheets are called: Sheet1, Sheet2, Sheet3 and Sheet4. Is there any way to change it, so the exported or sent by subscription file has the names of the sheets related for example to page content.
I think thru Export option of the Report it is not possible
You may use Dts script to do this See if this helps you
www.sqldts.com Madhivanan Failing to plan is Planning to fail