Passing textbox text in form to RDLC header[Answered] RSS

• • Reply
  kimloong888

  Member

  1 Points

  11 Posts

  Passing textbox text in form to RDLC header

  Sep 18, 2013 04:32 AM|kimloong888|LINK

  Good days to all,

  I'm using vb.net. In aspx form, i got 2 textbox (start date and end date) and 1 reportviewer.

  I'm binding dynamic dataset to rdlc where i directly takes the start date and end date text in my SQL query without using the parameters.

  Now i would like to show the start date and end date value in RDLC header.

  It is highly appreciated if any of you can give some idea, how to display start date and end date value in RDLC header.

  Thank you very much.

• • Reply
  Amy Peng - M...

  Star

  14544 Points

  1481 Posts

  Re: Passing textbox text in form to RDLC header

  Sep 18, 2013 09:49 PM|Amy Peng - MSFT|LINK

  Hi,

  Please try add one or more parameters to the report (Report-->Report Parameters + Add) 

  In the header, add text boxes and use the parameters to set their values:

  e.g. ="Invoice No.: " & Parameters!InvoiceNumber.Value

  And then add them to your LocalReport:

   Code Snippet

  ReportParameter[] parameters = new ReportParameter[4];

  parameters[0] = new ReportParameter("StartDate", reportView.StartDate.ToString("MMM-dd-yyyy"));

  parameters[1] = new ReportParameter("EndDate", reportView.EndDate.ToString("MMM-dd-yyyy"));

  report.SetParameters(parameters);

  reports.Add(new InvoiceReport(report, reportView));

  Best Regards.

   

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!