asked on

Passing a Parameter to a Report in ReportViewer

Hi, I'm using VB 2005, WinForms. I have a ReportViewer on one of my Forms which allows me to print a list of items from my DataTable. Currently, I'm getting a list of ALL my items in that DataTable. However, I need to pass a parameter to only show one type of item. In my case it would be the item with ProductID = 67. This parameter will change depending on what the user wants to view.

I can easily do this in a DataGridView by using BindingSource.Filter, but I don't know how to do it in a report in ReportViewer. Can someone explain how parameters are passed to a report "programmatically." By that I mean, I need to pass the variable to the report (in this case 67 as the ProductID) via code and the report should show only those items that are of that product ID type.

I know how to use parameters using the Wizard, but that creates a static report, which does not interact with the users.

In the code snippet below is the code I'm using to generate the report.

Thanks,
Fulano

Dim dtReport As DataTable = DirectCast(reportBS.DataSource, System.Data.DataTable)
Dim frm As New frmSelectedProduct
frm.ReportViewer1.Reset()
frm.ReportViewer1.LocalReport.ReportPath = "../../SelectedProductReport.rdlc"
frm.ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("DataSet1_DataTable1", dtReport))
frm.ShowDialog()

Open in new window

ASKER CERTIFIED SOLUTION

Deathrace

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Fulano

ASKER

Hi Deathrace, I reviewed your sites, and they did add some value, but I'm not there yet. I still haven't figured out how to pass a parameter to my reports. Your links did help me with the reports themselves, but I'm still stuck on the parameter issue, which is a huge problem for what I need to do.

Thanks,
Fulano

Mr_Fulano

ASKER

Hi Deathrace, (interesting name...)

I figured it out...its not straight forward by far, if this is the first time you do this and its definitely VERY poorly documented. However, here's the solution for passing a variable or parameter from a Textbox to the report. You can enter any number in your productsID list and get a report of only that product.

You also have to add a Parameter into your report from the Reports menu option and you have to set a Filter in your report to that parameter.

Thanks for your help!
Fulano

Dim frm As New Form2
Dim parameter As Microsoft.Reporting.WinForms.ReportParameter() = New Microsoft.Reporting.WinForms.ReportParameter(0) {}
parameter(0) = New Microsoft.Reporting.WinForms.ReportParameter("ProductID", Me.TextBox1.Text)
frm.ReportViewer1.LocalReport.SetParameters(parameter)
frm.ShowDialog()

Open in new window

Mr_Fulano

ASKER

Your links helped.