[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Passing a Parameter to a Report in ReportViewer

Posted on 2009-07-08
4
Medium Priority
?
719 Views
Last Modified: 2012-05-07
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

0
Comment
Question by:Mr_Fulano
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 9

Accepted Solution

by:
Deathrace earned 2000 total points
ID: 24811729
0
 

Author Comment

by:Mr_Fulano
ID: 24818749
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
 

Author Comment

by:Mr_Fulano
ID: 24820613
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
 

Author Closing Comment

by:Mr_Fulano
ID: 31601354
Your links helped.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question