Using the ReportViewer control in VS2010 allows running of remote SQL reports from report server 2008 and above http://msdn.microsoft.com/en-us/library/bb885185.aspx. This is where I ran into my first issue since my remote report was in SQL 2005 Reporting Services. Anyway, here is how I went about executing a SQL 2005 Report from a web page within Visual Studio 2010. Hope this helps.
1. From VS2010, create a new ASP.NET web application. By default this will target .NET Framework 4.
2. We will work with the "Default.aspx" page here. Open the page’s source code and add the following code just under the "page" directive.
3. Add the following code where you want the report displayed. I have a report named "MyReport" under a folder "Reports".
4. In the project references, add the reference to "Microsoft.ReportViewer.WebForms 18.104.22.168 v22.214.171.1247".
5. In Web.Config, add the following within the "System.Web" section.
6. Run your web page in the browser and hope you see the report as I do.