油王的菜鳥筆記

1. 在 xxx.rdlc 內, 參數 > 加入參數

2.加入了2個參數, 名稱為 ReportParameter1 及ReportParameter2

3. 拉出這2個參收加在報表上 .

4.在 XXX.aspx.cs 內,加入以下代碼:

using Microsoft.Reporting.WebForms;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Report_ClientListReport : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            string A = "你好:";
            string B =  "Terry";

            ReportParameter var1 = new ReportParameter("ReportParameter1", A);
            ReportParameter var2 = new ReportParameter("ReportParameter2", B);


            this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {var1,var2 });
            SqlDataSource1.SelectCommand = "Select * FROM ClientMaster";
            
            this.ReportViewer1.LocalReport.Refresh();


        }
    }
}

5.運行報表.