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.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2012 4:23pm
If you have any question please let me know.
May 27th, 2012 2:21am