Report Viewer Parameters in Visual Studio 2010 – No Code

15 Apr 2011

Report Viewer Parameters in Visual Studio 2010 – No Code

Hi Folks,

I’ve been trying since a long time finding an article of how to pass parameters to a Report Viewer control in Visual Studio 2010, but most of the articles needs lots of code to be written.

But, now I have found the way to create a report and pass parameters easily with only 1 line of code, yes I am serious 1 line of code!! 🙂

And below I will describe the steps with screen shots:
1- You need to create a new Visual Studio Web Site:

2- Then you will have an empty web site.

3- Now, I will create a new database with one table with three columns (ID, Name, City):

Then fill it with some data:

Now I will create a data set for the Contacts table:

Now I will Rebuild the web site:

Now, we need to add reference to Microsoft.ReportViewer.WebForms:
Make sure to select Version 10.0.0.0

Now, I will create a report:

Save the report.

Now, I will start to build the page of the report:
– Add a DropdownList and a Button:

– Drop a Script Manager control into the page:

– Drop a ReportViewer control:

– Choose the Report we created before, and an ObjectDataSource will be created directly:

– On the Click event of the button write the only Code you need to write to refresh the report:
ReportViewer1.LocalReport.Refresh()

Congratulations!! the web site is ready and the report takes the parameter and refreshes.

Happy programming!
Saed

10 thoughts on “Report Viewer Parameters in Visual Studio 2010 – No Code”

testdomain on March 17, 2013 at 5:08 PM said:

F*ckin’ amazing things here. I’m very glad to see your post. Thanks a lot and i am looking forward to contact you. Will you kindly drop me a e-mail?

Reply ↓
- saedshaar on March 17, 2013 at 6:39 PM said:
  
  I am glade you like it… You can contact me on saedshaar@gmail.com
  
  Reply ↓
Nizam on April 4, 2013 at 2:13 PM said:

very nice…..thanks

Reply ↓
Rick Szasz on July 26, 2013 at 12:08 AM said:

This post was awesome! Step by Step process that worked the first time.

Thanks
Rick

Reply ↓
Renga Iyengar on May 2, 2014 at 5:11 PM said:

Hi.. Quite an Interesting post.. Can it work for Winforms ?

Reply ↓
Yong on September 28, 2014 at 3:45 PM said:

I read a lot of interesting content here.
Probably you spend a lot of time writing, i know how to save you a lot of work, there is an online tool that creates high quality,
SEO friendly posts in minutes, just search in google – laranitas free content
source

Reply ↓
- saedshaar on September 28, 2014 at 6:51 PM said:
  
  Thank you very much for your suggestion … I will try doing that once I go back to blogging 🙂
  
  Reply ↓
lolo on August 2, 2015 at 11:43 AM said:

Thank you saed. But what if we have more than one parameters?

Reply ↓
lolo on August 2, 2015 at 12:05 PM said:

Thank you Saed. What if we have more than one parameter?

Reply ↓
Seven lavide on September 2, 2016 at 2:34 AM said:

I used to use and old way to create my apps (Visual Basic 6) and I use VBA a lot. But I wanted to create something more sophisticate. I just began to use VS and MySql. I was almost giving up when I found your post. This is what I was needing to move on. Thank you a million.

Reply ↓

Saed Al Shaar Dev Tips and Tricks

.NET and SharePoint from a different angle!