Retrieve reports from reporting server in Asp.Net (vs2005)

Include this namespace in you code behind:using System.Data.SqlClient;
Drop a ReportViewer control onto your asp page

Here is a snippit of code I use to refresh a report that has five parameters:
 ///refresh the report
            this.ReportViewer1.ServerReport.ReportServerUrl =
            new System.Uri("http://MyServer/reportserver");

            //while (this.ReportViewer1.ServerReport.IsDrillthroughReport)
            //{
            //    this.ReportViewer1.PerformBack();
            //}


                this.ReportViewer1.ServerReport.ReportPath = "/ReportFolder/ReportName";
           


            //this.ReportViewer1.ServerReport.ReportPath = strReport;

            Microsoft.Reporting.WebForms.ReportParameter[] RptParameters =
                new Microsoft.Reporting.WebForms.ReportParameter[5];

            //string strTime = System.DateTime.Now.ToShortTimeString();
            RptParameters[0] =
                new Microsoft.Reporting.WebForms.ReportParameter("account_ID", TheAccount.accountID.ToString());
            //RptParameters[1] =
            //   new Microsoft.Reporting.WebForms.ReportParameter("date", DropDownList2.Text.ToString());
            RptParameters[1] =
               new Microsoft.Reporting.WebForms.ReportParameter("statement_Date", DropDownList4.Text.ToString());
            RptParameters[2] =
                new Microsoft.Reporting.WebForms.ReportParameter("startdate", "6/30/2006".ToString());//this date doesn't matter its filler
            RptParameters[3] =
                new Microsoft.Reporting.WebForms.ReportParameter("enddate", DropDownList4.Text.ToString());
            RptParameters[4] =
                new Microsoft.Reporting.WebForms.ReportParameter("period", DropDownList2.Text.Substring(0, 1).ToString());

            this.ReportViewer1.ServerReport.SetParameters(RptParameters);

            this.ReportViewer1.ServerReport.Refresh();
            this.ReportViewer1.Visible = true;

Hi -

Sorry didn't realize you hadn't needed to connect to your server at all yet.   You'll need to set up a database connection: This shoudl come before the report server refresh code.

SqlConnection cn = new SqlConnection("Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=True");

First try taking the .com extension off your report server name in this line of code:

Me.ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://myreportname.com/reports2005")