Pass variable to SSRS report as parameter

I have 2 winforms The first has a button that opens the second with a reportviewer that opens an SSRS report with a single parameter (CaseNo). I want to be able to pass the CaseNo from C# to the SSRS report.

This is what I currently have but I am not sure how to modify it to pass the parameter to the report.

private void btnOpenSummary_Click(object sender, EventArgs e)
{
CaseSummRpt summRpt = new CaseSummRpt("Case_Summary", " / Security", lblCaseNo.Text);
summRpt.ShowDialog();
}

Report Viewer Form

public CaseSummRpt(string rptText, string rptFolder, string CaseNo)
{
InitializeComponent();
string rptName;
rptName = rptFolder + "/" + rptText;
reportViewer1.ServerReport.ReportServerUrl = new Uri("http://servername:8000/servername_server");
reportViewer1.ServerReport.ReportPath = rptName;
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Scott G5y ago
Thank you
Sachin Singh5y ago
ReportParameter[] param = new ReportParameter[1];
param[0] = new ReportParameter("Txtbox1", CaseNo);
reportViewer1.ServerReport.SetParameters(param);
this.reportViewer1.RefreshReport();