通过程序给ReportViewer 传递参数并显示报表

程序如下：

        Dim parm1 As Microsoft.Reporting.WebForms.ReportParameter = New Microsoft.Reporting.WebForms.ReportParameter
        parm1.Name = "ReportMonth"
        parm1.Values.Add("12")
        Dim parm2 As Microsoft.Reporting.WebForms.ReportParameter = New Microsoft.Reporting.WebForms.ReportParameter
        parm2.Name = "ReportYear"
        parm2.Values.Add("2003")
        Dim parm3 As Microsoft.Reporting.WebForms.ReportParameter = New Microsoft.Reporting.WebForms.ReportParameter
        parm3.Name = "EmpID"
        parm3.Values.Add("288")
        'Dim Parameters(1) As Microsoft.Reporting.WebForms.ReportParameter
        'Parameters(0) = parm
        'ReportViewer1.ShowCredentialPrompts = False
        ''ReportViewer1.ServerReport.ReportServerCredentials = New System.Net.NetworkCredential("userName", "password", "domain")
        ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
        ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/ReportServer")
        ReportViewer1.ServerReport.ReportPath = "/AdventureWorks Sample Reports/Employee Sales Summary"
        ReportViewer1.ServerReport.SetParameters(New Microsoft.Reporting.WebForms.ReportParameter() {parm1, parm2, parm3})
        ReportViewer1.ServerReport.Refresh()
        ReportViewer1.Visible = True

或

ReportParameter[] reportParam = new ReportParameter[1];
        reportParam[0] = new ReportParameter("UCODE", "1", false);
        ReportViewer1.ServerReport.SetParameters(reportParam);
        ReportViewer1.ShowParameterPrompts = false; 

http://bbs.youkuaiyun.com/topics/80469178

http://bbs.youkuaiyun.com/topics/340045439