Sounded like a bit of fun. Tussling with SSRS has always been a bit of a tiresome hunt around google finding caveat here, note there and undocumented feature after undocumented feature. So I thought I'd put somewhere what I have found. Firstly and this one is a biggy: SSRS R2 DOES NOT WORK WITH SharePoint 2007 This is really strange (or at least counter-intuitive) as we have SQL 2008 R2 so downloaded to accompanying SSRS R2. A few fruitless hours later... As SSRS R2 is for SharePoint 2010, instead of fixing SSRS R2 to work with SharePoint 2007 they fixed SSRS SP2 to work with SQL 2008 R2. This is shown in one section of the "fix-list" in SSRS SP2. Thanks. Anyways, here is another gotcha: If you have a multi-server environment (who doesn't?) then you need SSRS on each server...sounds ok, except the install doesn't care or ask about this so goes ahead and not only installs the binaries but activate the feature too. This causes all many of ...