SQL Server Reporting Services: SQL Server Reporting Services 2005 to 2008 or higher version require re-write reports?

Hello Folks,

I have SQL Server Reporting Services 2005 but due to some requirement i.e. renaming excel worksheet/tab doesn't support 2005 as it does support 2008 R2 only.

Could you please confirm in case I upgrade from SQL Server Reporting Services 2005 to 2008 or higher version then, do I need to re-write all reports OR no impact?

Could you please provide URLs for example?

Best Regards,
Mohit Pandit
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hello Mohit.

You can upgrade from SSRS 2005 to a higher version without having to recreate or re-write your reports. At my workplace, we have upgraded from SSRS 2005 to 2008 to 2008R2, etc. We have had to make only a few small adjustments to a handful of reports.

As Microsoft mentions in the SQL 2012 version of an MSDN article on upgrading reports: "On first use, the report server tries to upgrade existing published reports and report snapshots to the new report definition schema, requiring no specific action on your part. When a user views a report or a report snapshot, or when the report server processes a subscription, the upgrading attempt occurs. The report definition is not replaced but continues to be stored on the SQL Server 2012 report server in its original schema. If a report cannot be upgraded, the report runs in backward-compatibility mode."

That quote is found here: https://msdn.microsoft.com/en-us/library/ms143674(v=sql.110).aspx. The automated upgrade of existing reports (as described in the article) has worked very well for us (note that you can use the "Other Versions" link at that URL to see information specific to all the various SSRS versions).

Another MSDN article that is very helpful is "Upgrade and Migrate Reporting Services," here: https://msdn.microsoft.com/en-us/library/ms143747(v=sql.110).aspx.

Finally, we have always found the Upgrade Advisor to be very helpful: https://msdn.microsoft.com/en-us/library/d85b0833-ddeb-42e3-9397-97ea60d521b7(v=sql.110).

Good luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MohitPanditAuthor Commented:
Thanks much
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.