C# ReportParameter类代码示例

        private void Form2_Load(object sender, EventArgs e)
        {
            var resultSet2 =FacilityBLL.getOrderDetail(2);
            this.reportViewer1.LocalReport.ReportEmbeddedResource = "Annon.Report.Report2.rdlc";
            var ordersInfo = FacilityBLL.getFirstOrderInfo(2);
            try
            {
                ReportParameter rp = new ReportParameter("Latitute", ordersInfo.SiteAltitude.ToString()+"m");
                ReportParameter rpTag = new ReportParameter("CustomerName", string.IsNullOrEmpty(ordersInfo.CustCont) ? "无" : ordersInfo.CustCont);
                ReportParameter rpProjectName = new ReportParameter("ProjectName", ordersInfo.JobName);
                ReportParameter rpProjectNo = new ReportParameter("ProjectNo", ordersInfo.JobNo);
                ReportParameter rpSeller = new ReportParameter("AnnonContact", ordersInfo.AAonCont);
                ReportParameter rpOrderDate = new ReportParameter("DealDate", ordersInfo.DealDate == null ? "无" : ordersInfo.DealDate);
                ReportParameter rpJobDes = new ReportParameter("JobDescription", ordersInfo.JobDescription);
                ReportParameter rpCustomerNote = new ReportParameter("CustomerNote", ordersInfo.CustNotes );
                this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp, rpTag, rpProjectName, rpProjectNo, rpSeller, rpOrderDate,rpJobDes,rpCustomerNote });
                this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", resultSet2));
                this.reportViewer1.RefreshReport();
                this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
                this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.PageWidth;
            }
            catch (Exception ee)
            {

            }
        }

 public void setRptXraySummaryView(DateTime dateStart, DateTime dateEnd)
 {
     try
     {
         ReportDataSource rds = new ReportDataSource("xraySummary", getXraySummaryView(dateStart, dateEnd));
         //MessageBox.Show("bbbb");
         rV1.LocalReport.DataSources.Add(rds);
         //rV1.LocalReport.ReportPath = "d:\\source\\reportBangna\\reportBangna\\report\\xraysummary.rdlc";
         rV1.LocalReport.ReportPath = System.Environment.CurrentDirectory + "\\report\\xraysummary.rdlc";
         ReportParameter reportParaHeader1 = new ReportParameter();
         reportParaHeader1.Name = "header1";
         reportParaHeader1.Values.Add("aaaaaa");
         rV1.LocalReport.SetParameters(reportParaHeader1);
         ReportParameter reportParaHeader2 = new ReportParameter();
         reportParaHeader2.Name = "header2";
         reportParaHeader2.Values.Add("bbbbbbbb");
         rV1.LocalReport.SetParameters(reportParaHeader2);
         ReportParameter reportParaHeader3 = new ReportParameter();
         reportParaHeader3.Name = "header3";
         reportParaHeader3.Values.Add("cccccccc");
         rV1.LocalReport.SetParameters(reportParaHeader3);
     }
     catch (Exception ex)
     {
         MessageBox.Show("error " + ex.Message);
     }
 }

        private void geraRelatorio()
        {
            lDtPesquisa = (DataTable)Session["ldsRel"];
            if (lDtPesquisa.Rows.Count > 0)
            {

                string periodo = Request.QueryString["periodo"].ToString();
                InstituicoesBL instBL = new InstituicoesBL();
                Instituicoes inst = new Instituicoes();

                InstituicoesLogoBL instLogoBL = new InstituicoesLogoBL();
                InstituicoesLogo instLogo = new InstituicoesLogo();

                ReportDataSource rptDatasourceInstituicao = new ReportDataSource("DataSet_Instituicao", instBL.PesquisarDsBL().Tables[0]);
                ReportDataSource rptDatasourceInstituicaoLogo = new ReportDataSource("DataSet_InstituicaoLogo", instLogoBL.PesquisarDsBL().Tables[0]);
                ReportDataSource rptDatasourceMovEstoque = new ReportDataSource("DataSet_MovimentacaoEstoque", lDtPesquisa);

                ReportParameter[] param = new ReportParameter[1];
                param[0] = new ReportParameter("periodo", periodo);

                rptMovestoque.LocalReport.SetParameters(param);
                rptMovestoque.LocalReport.DataSources.Add(rptDatasourceInstituicao);
                rptMovestoque.LocalReport.DataSources.Add(rptDatasourceInstituicaoLogo);
                rptMovestoque.LocalReport.DataSources.Add(rptDatasourceMovEstoque);

                rptMovestoque.LocalReport.Refresh();
                //Session["ldsRel"] = null;
            }
            else
            {
                divRelatorio.Visible = false;
                divMensagem.Visible = true;
                lblMensagem.Text = "Este relatorio não possui dados.";
            }
        }

 private void DoanhThuMonAn_Load(object sender, EventArgs e)
 {
     this.monAnTableAdapter.Fill(this.coffeeManagementDataSet.MonAn, dtpTuNgay.Value, dtpDenNgay.Value.AddHours(12));
     _para = new ReportParameter("TitleParameter", "Từ ngày: " + dtpTuNgay.Value.ToString("dd/MM/yyyy") + " Đến ngày: " + dtpDenNgay.Value.ToString("dd/MM/yyyy"));
     reportViewer1.LocalReport.SetParameters(_para);
     this.reportViewer1.RefreshReport();
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //提取数据
                string queryWord = "";

                if (Request.QueryString["queryWord"] != null && Request.QueryString["queryWord"].Trim() != "" && Request.QueryString["queryWord"].Trim() != "null")
                    queryWord = Request.QueryString["queryWord"].Trim();

                YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage();
                ynPage.SetPageSize(500); //pageRows;
                ynPage.SetCurrentPage(1); //pageNumber;

                List<AscmSupplier> listAscmSupplier = AscmSupplierService.GetInstance().GetList(ynPage, "", "", queryWord, null);
                ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
                ReportViewer1.LocalReport.ReportPath = Server.MapPath("SupplierReport.rdlc");
                ReportDataSource rds1 = new ReportDataSource();
                rds1.Name = "DataSet1";
                rds1.Value = listAscmSupplier;
                ReportViewer1.LocalReport.DataSources.Clear();//好像不clear也可以
                ReportViewer1.LocalReport.DataSources.Add(rds1);

                string companpyTitle = "美的中央空调";
                string title = companpyTitle + "供应商";

                ReportParameter[] reportParameters = new ReportParameter[] {
                    new ReportParameter("ReportParameter_Title", title),
                    new ReportParameter("ReportParameter_ReportTime", "打印时间：" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"))
                };
                ReportViewer1.LocalReport.SetParameters(reportParameters);
                ReportViewer1.LocalReport.Refresh();
            }
        }

    protected void Page_PreRender(object sender, EventArgs e)
    {
        ReportParameter[] reportParameters = new ReportParameter[1];

        reportParameters[0] = new ReportParameter("ReportYear", DateTime.Now.Year.ToString());
        rvSales.ServerReport.SetParameters(reportParameters);
    }

    protected void btnViewreport_Click(object sender, EventArgs e)
    {
        /////Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            string vardate;
            string vardate1;

            string[] tempdate = txtFromDate.Text.ToString().Split(("/").ToCharArray());
            vardate = tempdate[2] + "-" + tempdate[1] + "-" + tempdate[0];
            string[] tempdate1 = txttoDate.Text.ToString().Split(("/").ToCharArray());
            vardate1 = tempdate1[2] + "-" + tempdate1[1] + "-" + tempdate1[0];

            ReportParameter[] Param = new ReportParameter[2];
            Param[0] = new ReportParameter("from", vardate);
            Param[1] = new ReportParameter("to", vardate1);

            ReportViewer1.ShowCredentialPrompts = false;
            ReportViewer1.ServerReport.ReportServerCredentials = new ReportClass.ReportCredentials(ConfigurationSettings.AppSettings["Credentials"].ToString().Split('\\')[0], ConfigurationSettings.AppSettings["Credentials"].ToString().Split('\\')[1], "");
            ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
            ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(ConfigurationSettings.AppSettings["ReportServerURL"].ToString());
            ReportViewer1.ServerReport.ReportPath = "/BESTREPORT/categorycalls";
            ReportViewer1.ServerReport.SetParameters(Param);
            ReportViewer1.ServerReport.Refresh();
        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }

        private void HY_PurchasingdetailsReport_Load(object sender, EventArgs e)
        {
            HY_Invoicing.HY_Purchasingstatus hypur;//实例化传值窗体
            hypur = (HY_Invoicing.HY_Purchasingstatus)this.Owner;
            string aa = hypur.GetMainvalue;//单号传值
            string sup = hypur.HYSupplier;//供应商传值
            string model = hypur.ModelID;//模号

            HY_BLL.HY_StorageBLL hystorfobll = new HY_StorageBLL();
            string sql = "select * from HY_ProcurementInfo where c_DID='" + aa + "' and c_Supplier='"+sup+"'";
            DataSet ds = hystorfobll.ExecuteQueryDataSet(sql);
            this.reportViewer1.LocalReport.ReportEmbeddedResource = "LL.Main.HY_Report.HY_ProcurementInfoReport.rdlc";
            this.reportViewer1.LocalReport.DataSources.Clear();
            this.reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("HY_ProcurementInfo", ds.Tables[0]));
            //设置打印布局模式,显示物理页面大小
            this.reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
            //缩放模式为百分比,以100%方式显示
            this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
            this.reportViewer1.ZoomPercent = 100;

            ReportParameter rp = new ReportParameter("content", sup);
            this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
            ReportParameter rp1 = new ReportParameter("cgID", aa);
            this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 });
            ReportParameter mod = new ReportParameter("modelID", model);
            this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { mod });

            // TODO: 这行代码将数据加载到表“hYMISDataSet.HY_ProcurementInfo”中。您可以根据需要移动或移除它。
            //this.HY_ProcurementInfoTableAdapter.Fill(this.DataSet1.HY_ProcurementInfo, aa);
            this.reportViewer1.RefreshReport();
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            string vardate;
            string vardate1;

            vardate = DateTime.Now.ToString();

            vardate1 = DateTime.Now.ToString();

            ReportParameter[] Param = new ReportParameter[2];
            Param[0] = new ReportParameter("from", vardate);
            Param[1] = new ReportParameter("to", vardate1);

            ReportViewer1.ShowCredentialPrompts = false;
            ReportViewer1.ServerReport.ReportServerCredentials = new ReportClass.ReportCredentials(ConfigurationSettings.AppSettings["Credentials"].ToString().Split('\\')[0], ConfigurationSettings.AppSettings["Credentials"].ToString().Split('\\')[1], "");
            ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
            ReportViewer1.ServerReport.ReportServerUrl = new System.Uri(ConfigurationSettings.AppSettings["ReportServerURL"].ToString());
            ReportViewer1.ServerReport.ReportPath = "/BESTREPORT/categorycalls";
            ReportViewer1.ServerReport.SetParameters(Param);
            ReportViewer1.ServerReport.Refresh();

        }
    }

    public void LoadReport(int agentId, DateTime fromDate, DateTime toDate)
    {
        //Reset report viewer control
        reportViewer.Reset();

        //Initializes report viewer and set report as embedded resource
        Common.SetReportEmbeddedResource(reportViewer, "TCESS.ESales.CommonLayer.Reports.ConsolidatedBookingandSaleReport.rdlc");

        //Set datasource for cash collection report
        IList<DispatchReportDTO> lstDispatchReportRpt = ESalesUnityContainer.Container.Resolve<IReportService>()
            .GetDispatchReport(Convert.ToInt32(agentId), Convert.ToDateTime(fromDate),
            Convert.ToDateTime(toDate));
        ReportDataSource CashCollectionDataSource = new ReportDataSource("dsConsBookingSale", lstDispatchReportRpt);
        reportViewer.LocalReport.DataSources.Add(CashCollectionDataSource);
        string agentName = "";
        if (agentId > 0)
        {
            AgentDTO _agentName = ESalesUnityContainer.Container.Resolve<IAgentService>().GetAgentByAgentId(agentId);
            agentName = _agentName.Agent_Name;
        }
        else
        {
            agentName = "ALL";
        }
        //Set report parameters
        ReportParameter fromDt = new ReportParameter("FromDate", Convert.ToDateTime(fromDate).ToString("dd/MM/yyyy"));
        ReportParameter toDt = new ReportParameter("ToDate", Convert.ToDateTime(toDate).ToString("dd/MM/yyyy"));
        ReportParameter agent = new ReportParameter("agent", Convert.ToString(agentName));
        reportViewer.LocalReport.SetParameters(new ReportParameter[] { fromDt, toDt, agent });
    }

        internal void LoadParametros(DateTime fechaini, DateTime fechafin, DataTable tmpClientes, Boolean Agrupado)
        {
            this.WindowState = FormWindowState.Maximized;
            // TODO: This line of code loads data into the 'Promowork_dataDataSet.EmpresasActual' table. You can move, or remove it, as needed.
            this.EmpresasActualTableAdapter.FillByEmpresa(this.Promowork_dataDataSet.EmpresasActual, VariablesGlobales.nIdEmpresaActual);

            try
               {
               this.ResumenFacturasClientesTableAdapter.FillbyCliente(this.Promowork_dataDataSet.ResumenFacturasClientes, tmpClientes, fechaini, fechafin);
            }
            catch (SqlException ex)
            {
                ErroresSQLServer.ManipulaErrorSQL(ex, this.Text);
            }

            ReportParameter[] Parametros = new ReportParameter[3];
            //Establecemos el valor de los parámetros
            Parametros[0] = new ReportParameter("FechaIni", Convert.ToString(fechaini));
            Parametros[1] = new ReportParameter("FechaFin", Convert.ToString(fechafin));
            Parametros[2] = new ReportParameter("Agrupado", Convert.ToString(Agrupado));
            //Pasamos el array de los parámetros al ReportViewer
            this.reportViewer1.LocalReport.SetParameters(Parametros);

            this.reportViewer1.RefreshReport();
        }

        private void anteprimaStampaBilancioLoad(object sender, EventArgs e)
        {
            // Set Processing Mode
            _reportViewer = new ReportViewer {ProcessingMode = ProcessingMode.Local};
            
            // Set RDL file
            _reportViewer.LocalReport.ReportEmbeddedResource = "Gipasoft.Stabili.UI.StatoPatrimoniale.Reports.DettaglioPartitario.rdlc";

            // Supply a DataTable corresponding to each report dataset
            _reportViewer.LocalReport.DataSources.Add(new ReportDataSource("MovimentoContabileBilancioDTO", _partitario));

            // Add the reportviewer to the form
            Controls.Add(_reportViewer);
            _reportViewer.Dock = DockStyle.Fill;

            _reportViewer.LocalReport.EnableExternalImages = true;

            var parameterCondominio1 = new ReportParameter("condominio1", _reportParameters.DescrizioneCondominio[0]);
            var parameterCondominio2 = new ReportParameter("condominio2", _reportParameters.DescrizioneCondominio[1]);
            var parameterCondominio3 = new ReportParameter("condominio3", _reportParameters.DescrizioneCondominio[2]);
            var parameterCondominio4 = new ReportParameter("condominio4", _reportParameters.DescrizioneCondominio[3]);
            var parameterCodiceCondominio = new ReportParameter("codiceCondominio", _reportParameters.CodiceCondominio);
            var parameterEsercizio = new ReportParameter("esercizio", _reportParameters.DescrizioneEsercizio);
            var parameterAzienda = new ReportParameter("azienda", _reportParameters.DescrizioneAzienda);
            var parameterGriglia = new ReportParameter("griglia", _reportParameters.VisualizzaGriglia.ToString());
            var parameterNote = new ReportParameter("note", _reportParameters.Note);

            var parameterIntestazioneStudio = new ReportParameter("intestazioneStudio", _reportParameters.IntestazioneStudio);
            var parameterViaStudio = new ReportParameter("viaStudio", _reportParameters.ViaStudio);
            var parameterCapStudio = new ReportParameter("capStudio", _reportParameters.CapStudio);
            var parameterLocalitaStudio = new ReportParameter("localitaStudio", _reportParameters.LocalitaStudio);
            var parameterLogo = new ReportParameter("logo", _documentService.SaveInLocalCache(new Gipasoft.Business.Interface.DocumentInfo() { Body = _aziendaService.GetLogo().LogoAzienda, FileName = "logo.jpg" }));

            string dataSituazione = "Fine esercizio";
            if (_reportParameters.DataSituazione != null)
                dataSituazione = _reportParameters.DataSituazione.Value.ToShortDateString();
            var parameterDataSituazione = new ReportParameter("dataSituazione", dataSituazione);

            _reportViewer.LocalReport.SetParameters(
                new [] 
                { 
                    parameterCondominio1, 
                    parameterCondominio2, 
                    parameterCondominio3, 
                    parameterCondominio4, 
                    parameterCodiceCondominio,
                    parameterEsercizio, 
                    parameterAzienda, 
                    parameterGriglia, 
                    parameterNote, 
                    parameterIntestazioneStudio,
                    parameterViaStudio,
                    parameterCapStudio,
                    parameterLocalitaStudio,
                    parameterLogo,
                    parameterDataSituazione
                });

            _reportViewer.RefreshReport();
        }

    private void RenderStatement(int penaltyID, int loanID)
    {
        try
        {
            ReportParameter rpPenaltyID = new ReportParameter("PenaltyID", penaltyID.ToString());
            ReportParameter[] parameters = new ReportParameter[] { };

            DataTable dtPenalty = LoansBLL.GetPenalty(penaltyID, loanID).Tables[0];
            ReportDataSource rdsPenalty = new ReportDataSource("PenaltyDS", dtPenalty);
            ReportDataSource[] sources = new ReportDataSource[] { rdsPenalty };
            byte[] bytes = Statements.RenderStatement("PenaltyNotice.rdlc", sources, parameters);

            // Variables
            string mimeType = string.Empty;

            // Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
            Response.Buffer = true;
            Response.Clear();
            Response.ContentType = mimeType;
            Response.AddHeader("content-disposition", "attachment; filename=" + "PenaltyNotice_" + penaltyID.ToString() + ".pdf");
            Response.BinaryWrite(bytes); // create the file
            Response.Flush(); // send it to the client to download
        }
        catch (Exception ex)
        {
        }
    }

        private void printReceipt(object sender, EventArgs e)
        {
            ReportDataSource source = new ReportDataSource();
            ReportViewer reportViewer = new ReportViewer();

            source.Name = "DataSet1";
            source.Value = null;

            ReportParameter p1 = new ReportParameter("test1", "ASV");
             //   reportViewer.Reset();
               // reportViewer.LocalReport.DataSources.Clear();
              reportViewer.LocalReport.ReportPath = "../../Reports/ReportReceipts.rdlc";
              ReportParameter rp = new ReportParameter();
              rp.Name = "id";
              rp.Values.Add(objectReceipt.Id);
              ReportParameter rp1 = new ReportParameter("contractid", objectReceipt.Contractid, true);
              ReportParameter rp2 = new ReportParameter("dateestablish", this.objectReceipt.Dateestablish, true);
              ReportParameter rp3 = new ReportParameter("billid", this.objectReceipt.Billid, true);
              ReportParameter rp4 = new ReportParameter("customername", this.objectReceipt.Customername, true);
              ReportParameter rp5 = new ReportParameter("total", this.objectReceipt.Total.ToString(), true);
              ReportParameter rp6 = new ReportParameter("reason", this.objectReceipt.Reason, true);
              ReportParameter rp7 = new ReportParameter("note", this.objectReceipt.Contents, true);
              ReportParameter[] parameter = new ReportParameter[] { rp, rp2, rp1, rp3, rp4, rp5, rp6, rp7 };
             // reportViewer.LocalReport.SetParameters(p);
              // reportViewer.LocalReport.DataSources.Add(source);

              ReportReceipts form = new ReportReceipts(parameter);
            form.Show();
        }

 protected void Page_Load(object sender, EventArgs e)
 {
     ReportParameter[] parameters = new ReportParameter[1];
     parameters[0] = new ReportParameter("para1","da");
     this.ReportViewer1.LocalReport.SetParameters(parameters);
     this.ReportViewer1.LocalReport.Refresh();
 }