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> 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 >