SQLTeam.com | Weblogs | Forums

Ssrs 2008 export to excel


#1

In a new ssrs 2008 report, I have a question about exporting to excel. In the report I am doing, there is a main table and there is a table with report parameters. I would like to be able to export the main table to one tab in excel and export the other table with report parameters to another tab in excel 2013. Thus can you tell me if this is an option in ssrs 2008? If so, can you tell me and/or point me to a link that will show how to export the main table to one tab in excel and the parameters table to another tab in excel?


#2

see here: https://technet.microsoft.com/en-us/library/dd255278.aspx
Use page breaks and different tab names for export.