CODEWITHSUNDEEP
excelreporting-servicesssrs-2008reportingservices-2005
Alex R.
Alex R.

Reputation: 4754

SSRS Excel Export

We migrated our old SSRS 2005 reports to 2008. Now, when we try to export the reports to Excel, we noticed that the Sheet naming convention has changed.

In 2005, it will be like this:

Document Map | Sheet 1 | Sheet 2 | Sheet 3...

Now, it is showing:

Document Map | Sheet 2 | Sheet 3 | Sheet 4...

Is this a default feature? Is there a way to revert this to the old scheme? I have tried changing the tab names, but probably the noob-ness of my SSRS skills is preventing me to do so.

Upvotes: 1

Views: 1036

Answers (1)

Jamie F
Jamie F

Reputation: 23789

In SSRS 2008R2 you can control the tab names by using the Page name property. You should be able to use these to recreate the old naming convention. But this will only work in 2008r2.

SSRS 2012 will be changing the export to Excel functionality again as it will now use .xlsx. So you should avoid relying on a solution that depends on the tab names of Excel. If this is for some data interchange, then maybe look at SSIS instead?

Upvotes: 1

Related Questions