That's correct, we are using SSRS 2008 R2, and it is indeed using VS 2008 as the shell for the BI tools.
Cheers, Jake From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of William Luu Sent: Tuesday, 14 June 2011 9:18 AM To: ozDotNet Subject: Re: Business Intelligence Development Studio (BIDS) vs VS2010 Hi Greg, You could always install BIDS locally by installing the SQL Server 2008 R2 Developer Edition? It's probably not installed by default, but I think it is available. We're currently still targetting SSRS 2005, so i'm not 100% sure on this. But my past research indicated that you can author SSRS 2008 R2 reports using Visual Studio 2008. From memory I think BIDS (for 2008 R2) is actually just VS 2008 with the addition of some Reporting Services add-ins. We currently author our SSRS 2005 reports in a copy of Visual Studio 2005 with the Reporting Services add-ins. Will On 14 June 2011 11:06, Greg Keogh <g...@mira.net<mailto:g...@mira.net>> wrote: Folks, after many months absence from the subject I have returned to the task of writing some SQL 2008 R2 server-side reports. I previously had to perform the onerous task of uninstalling SQL Server 2008 from my server then reinstalling SQL Server with Advanced Tools so I could get BIDS to write reports. I was fascinated to find that BIDS is actually a stripped-down version of VS2010 with just a report designer and facility to deploy, and I proved that it works to my satisfaction. But now I have to spend hours writing reports, and it looks like I have to sit at my server (jammed in the corner of the room with a small virtualised screen) so I can fire up BIDS to work with the *.rptproj projects. Web searches hint that VS2010 is unable to edit rptproj files and I see a few people complaining. I just want to check that this is in fact the way things are, and perhaps I'm not missing some productivity tricks other know about. Cheers, Greg