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

Mr_FulanoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DeathraceCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mr_FulanoAuthor Commented:
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
0
Mr_FulanoAuthor Commented:
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

0
Mr_FulanoAuthor Commented:
Your links helped.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.