Delivering the Best IT to Your Business

Telephone01992 466877

Changing Sheet Names In Sql Server Reporting Services Excel Export

How To

This is possible in SQL 2008 R2 and above – but if your company is not going to move to this any time soon, then this is not a viable option. R2 is a separate product, and is chargeable as an upgrade – it's not a service pack release.

However, there is an alternative that looks quite promising:

Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT

This solution is not for the faint hearted - but is a viable alternative to a costly upgrade. Essentially you customise the report design, adding to it an edited xml style sheet template (XSLT). When you then run the report, it outputs with the sheet names that you defined.

Microsoft certified Small Business Specialist since 2008 Dell registered partner - business servers, desktops, laptops and tablets at a discount Member of the Hertfordshire Chamber of Commerce and local business community since 2000 Microsoft Partner since 2000

Follow us on Twitter