Print Parameter in Report

Question

This is my VB.NET (2012) code to show report based on Combobox (cmbCustomer) selection, I want to print that parameter cmbCustomer.text on report.

Private Sub btnShow_Click(sender As Object, e As EventArgs) Handles btnShow.Click
        Me.rpt_customerByDateTableAdapter.Fill(Me.customerByDateDataSet.rpt_customerByDate,
        cmbCustomer.Text)
        Me.ReportViewer1.RefreshReport()
End Sub

score 0 · Accepted Answer · edited May 23 '17 at 10:32

0

Here's how, assuming you have already created a parameter in your rldc

Dim customer As String = cmbCustomer.text
Dim CustomerParam As New ReportParameter("yourCustomerParameter", customer)

Dim reportParameters() As ReportParameter = {CustomerParam}

Me.DataTable1TableAdapter.Fill(Me.customerByDateDataSet.rpt_customerByDate,
        cmbCustomer.Text)

Me.ReportViewer1.LocalReport.SetParameters(reportParameters)
Me.ReportViewer1.RefreshReport()

edited May 23 '17 at 10:32

Community

1
1

answered Feb 07 '13 at 08:13

spajce

7,044
5
29
44

Thanks very much for your help, I think Me.rpt_customerByDateTableAdapter.LocalReport.SetParameters(reportParameters) must be Me.ReportViewer1.LocalReport.SetParameters(reportParameters) – imsome1 Feb 07 '13 at 11:19

Print Parameter in Report

1 Answers1