There is always a message regarding upgrading the ssrs project when opening what I presume is a 2008 SSRS project in what I presume is 2008R2 BIDS/VS. (It's very hard to understand the versions of the rdl file and what it wants to upgrade to, so I'm
assuming here) But we don't want to upgrade - the production server is running 2008 reports. So I want SQL 2008 BIDS/VS on my machine to open the 2008 report project and not be prompted to upgrade. Is this possible? Seems to be a hullava headache.
Running sql server 2008 feature install the flag for BIDS is already selected (and grayed out). So what do I run or install in order to open a 2008 report project on my machine with 2008R2 BIDS/VS already installed? Any solid help appreciated.
In SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS) is Microsoft Visual Studio 2008 with additional project types that are specific to SQL Server business intelligence. Both Reporting Services 2008 version of BIDS and
Reporting Services 2008 R2 version of BIDS are integrated in Visual Studio 2008.
If we install SSRS 2008 R2 on our machine (the machine has been installed SSRS 2008), the version of BIDS will automatic upgrade to BIDS 2008 R2. So, we will use BIDS 2008 R2 to design reports, view reports, and so on.
Reporting Services 2008 R2 version of BIDS supports working with both SQL Server 2008 and SQL Server 2008 R2 reports, and we can use Reporting Services 2008 R2 version of BIDS deploy either version of reports or Report Server projects.
Introducing Business Intelligence Development Studio
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.