How to Prevent Automatic Convert to Tablix?
Hello. We have a lot of reports (.rdl files) that need to work on both SQL Server 2005 Reporting Services AND SQL Server 2008 R2 Report Services. We have a reports project (.rptproj) that contains all the .rdl files. This project is a Visual Studio 2008 (aka SQL Server Business Intelligence Development Studio), and everything is checked into TFS 2010. The problem is when I check out/try to edit one of the .rdl files, Visual Studio is automatically converting the report to use a tablix control. This is not acceptable since that same .rdl file still needs to work backward compatible to SQL Server 2005, which doesn't support the tablix control. (And, by the way, this scenario works because we tested the same .rdl files on both versions of SQL Server Reporting Services.) So, how can I prevent this automatic conversion to a tablix control? We wan the report design to stay the same when we check it out for edit. Thanks.
May 26th, 2012 4:10pm
Hi There SSRS 2008 and SSRS 2005 works on entirely different schema. If you would like to publish your rdl to the SSRS 2008 you have to convert it by using BIDS 2008. To work around this you can have the copy of your report project and convert that project inside BIDS 2008 and deploy that on SSRS 2008. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
May 26th, 2012 4:23pm
If you have any question please let me know.
May 27th, 2012 2:21am