Greetings, I developed a report in SSRS 2008 R2... and now I want to publish it on SSRS 2008. Is there anything that I should bare in mind before publishing the same? Or R2 reports has got full backward compatibility with SSRS 2008? Any reference is appreciated Cheers!Microsoft Techie

Hi, if BIDS is used to develop the project, you can go to the project properties and under deployment, you can set the property named TargetServerVersion to SQL Server 2008. Setting this property would ensure that when deploying, it would validated to check if your report is compatible with the version you are releasing to. On the other hand if you want to totally avoid adding features while desiging that are not supported by SSRS 2008, then it might help knowing the new features in SSRS 2008 R2 and rightly avoid add any of those. Details on new features of SSRS 2008 R2 can be found at http://msdn.microsoft.com/en-us/library/ms170438.aspx Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

You need to have a read of the following link on SSRS 2008 R2 breaking changes to see whther your report can be deployed to SSRS 2008 http://msdn.microsoft.com/en-us/library/ms143380.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: http://mrwharty.wordpress.com/ Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker