Problem in export to Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem in export to Excel

I have a Sql Report (on my SQL report server) My report contain many table, each table get it’s vales (detail) from different DataSet. When I export the report result to Excel file it’s been cutting to many pages in one sheet. Is it any option to separate the report to more then one sheet while export it to Excel file? I must to know!
As an alternative, why dont you try this?
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Create an Excel file with many sheets and do the query using sheetname as specified in that link
Madhivanan Failing to plan is Planning to fail
Hi, you can do this :
xls.sheet.fittopage=true
XlS.Cells.Font.Size = 9
XlS.PageSetup.PrintGridlines = True
xlS.PageSetup.FitToPagesWide = 1
XlS.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape more over you can refer www.planet-source-code.com for more code examples Regards hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
]]>