Reporting Services export to Excel with Multiple Worksheets

by

To late for the original asker of the question, but with SQL Server 2008 R2 this is now possible:

Set the property “Pagebreak” on the tablix or table or other element to force a new tab, and then set the property “Pagename” on both the element before the pagebreak and the element after the pagebreak. These names will appear on the tabs when the report is exported to Excel.

Read about it here: http://technet.microsoft.com/en-us/library/dd255278.aspx

More Related Contents:

  1. SSRS multi-value parameter using a stored procedure
  2. Compare SQL Server Reporting Services to Crystal Reports [closed]
  3. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  4. Does the iif function compute both paths in SSRS or is it short-circuited?
  5. SSRS Expression Divide by Zero Error
  6. When to use RDLC over RDL reports?
  7. SSRS 2005 Set SimplePageHeaders on the report instead of the server?
  8. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  9. SSRS – How to build a simple multi-column report?
  10. SSRS – How to continue data to next column?
  11. SSRS distinct lookupset function
  12. SSRS Conditional Formatting Switch or IIF
  13. How to combine aggregates within a group with aggregates across groups within SSRS
  14. Pivot a table in reporting services?
  15. Access Page number in report body In SSRS
  16. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  17. hide/remove header and footer
  18. Passing multiple values for a single parameter in Reporting Services
  19. How to get rid of blank pages in PDF exported from SSRS
  20. Passing parameter via url to sql server reporting service
  21. Add alternating row color to SQL Server Reporting services report
  22. Changes to parameter not showing on Report Server after deployment
  23. Fast query runs slow in SSRS
  24. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  25. Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0
  26. SSRS report definition is newer than Server
  27. Passing a parameter via URL to SQL Server Reporting Services
  28. how to remove time from datetime
  29. How to get total of top 10 sales in SSRS 2012
  30. Passing Credentials to Sql Report Server 2008

Leave a Comment