Report.rdlc not displaying parameterized report

Question

I have created a windows application with a combo box filled with countries from NorthWnd database. A typed dataset is created which contains a method called GetCustomersByCountry() to fetch the records for a specific country selected from combo box.

A report1.rdlc is created to display the records.

The problem is when I select a country from Combo box, the report viewer is unable to display the records.

The following code is written in the selectedindex event of combobox.

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim adapter As New NorthWndTableAdapters.CustomersTableAdapter
        ReportViewer1.LocalReport.ReportPath = "Report1.rdlc"
        Dim rds As New ReportDataSource()
        rds.Name = "NorthWnd_Customers"
        rds.Value = adapter.GetCustomersByCountry(Combobox1.Text)
        ReportViewer1.LocalReport.DataSources.Add(rds)
        Me.ReportViewer1.RefreshReport()
    End Sub

But when I call the method GetCustomerByCountry("UK") it display the records.

Now, anyone can suggest me please why the reportviewer not display the records when I select a country from Combo Box.

Thanks

Master Billa · Answer

Hi From your description it seems that you want to pass value into your rdlc report right? Generally you can use ReportParameter to feed the parameters to your report. See the following code: int ParaId = 5; ReportParameter[] params = new ReportParameter[1]; params[0] = new ReportParameter(ParaId ParaId false); this.ReportViewer1.ServerReport.SetParameters(params); this.ReportViewer1.ServerReport.Refresh(); And after you've added the code you also need to define the parameter in the .rdlc file as well. With the .rdlc file open in Visual Studio go to the Report menu and select Report Parameters. To be consistent with the code you should add a parameter named ParaId and then click OK to close the window. Finally in your .rdlc report designer you should add a textbox and use expression editor (right-click the textbox and select expression) to set its value =Parameters! ParaId.Value Thanks.

leena dhillon · Answer

Hi you need to set the parameter of report.. LocalReport report=new LocalReport(); ReportParameter COUNTRYID = new ReportParameter(COUNTRYID COUNTRYID .ToString()); ReportParameter[] p = { COUNTRYID}; report.setParameter(p); Where COUNTRYID .ToString() is a local variable in class using getter setter method. and in rdlc report right click on page report parameter add COUNTRYID as integer.