SQL Server Reporting Services ReportViewer Control for Windows Applications

By:   |   Comments (10)   |   Related: > Reporting Services Development


Can I run a SQL Server Reporting Services (SSRS) report from Windows applications? If yes, what are the pro's and con's of doing so?


SSRS functionality is certainly available in a Windows application; Visual Studio .Net is actually the key component needed to develop a fully functioning report application. The Visual Studio application actually uses the ReportViewer control for processing a report. The .Net ReportViewer control actually comes in two flavors; one of the controls is used for Windows Forms applications while the second control focuses on Web Forms. For this particular tip we will focus on the Windows Forms control. A few additional items need to be noted when dealing with the ReportViewer control. First, you can run the report in local processing mode or remote processing mode. Local processing mode renders the report all within the local machine / application and can be used when SSRS is not installed. However, with local processing, not all the SSRS functionality is available, and, as such, reports can only render a report in PDF, Excel, Word, or Image formats. To the contrary, remote processing provides the best of both worlds. You must have SSRS installed (not necessarily on the machine running the application) for remote processing mode. Furthermore, the SSRS server handles the report run and processing, and thus any functionality available in SSRS is available in remote processing mode of the control. The ReportViewer employs the power of the Report Server to achieve the display of a report.  For this particular tip, we are going to focus on using the remote processing mode for a windows form.

Windows Form ReportViewer

To get started with our example, we first need to setup our various tools. As we have used in many of my other tips, we will again use the AdventureWorks 2012 SQL Server database; the database is available on Codeplex at http://msftdbprodsamples.codeplex.com/releases/view/55330. Once you download and install the SQL Server database, we will subsequently use the SSRS 2012 sample reports which can be downloaded at http://advworks2012sssrs.codeplex.com/releases/view/106799. We will assume that you have installed and initialized the SSRS instance and it is up and running. For this example, we will use the Customers Near Stores report, which I have already deployed to the report server as shown below.  

SSRS Reports

Our first step is to open up Visual Studio. For this example, we will use Microsoft Visual Basic 2010 Express although you could use many of the various Visual Studio flavors to complete this task. However, in order to use the ReportViewer control we normally need to add a reference to the control in the toolbox. To achieve this step, as shown below, right mouse click on any part of the toolbox and select Choose Items.

Add To Toolbox

Next, you will need to scroll down the list of controls on the .Net Framework Components tab until you get to the ReportViewer components. You will notice that two controls exist; one is for WinForms and one for WebForms. You will also notice that there are multiple versions of the control. For use here, we only need the 10.0.0 version. However, depending on your Visual Studio version, you may have to select an alternate version.

Toolbox Items

Once we have the controls in place we are ready to design our form. So within VB Express, Open a New Project, and then add a new Windows Form, as shown below, by right mouse clicking on your project in the Solution Explorer and then Selecting Add > Windows Form.   


As illustrated in the next screen shot, once you have the Windows Form created, next open up the toolbox, scroll to the ReportViewer control, and then drag it onto your form.

Drag Report Viewer

We now need to set the ReportViewer Tasks settings. To get the Tasks setting box to show up, you will need to click on the very small arrow in the upper right corner of the control. Next, you need to Select <Server Report> under Choose Report; in the Report Server URL, enter the URL for your Report Server. For my example, this URL is http://localhost/reportserver_SQL2012; of course, your URL will be different. Finally, under Report Path, you will enter the full path to the report including folders, sub folders, and report name. Be sure to enter the leading slash "/".

Report views Settings

As you can see in the above screen print, you can actually design a report directly from the Task settings, although I prefer to have a report already completed. The very bottom option on the Tasks settings, Dock in Parent Container, will actually have the ReportViewer control maximize over top and cover the entire space of the Windows Form. It probably would be a good idea to resize the ReportViewer control to an appropriate size; otherwise, the report consumer may have to do a lot of scrolling. At this point, we have a full working ReportViewer implementation. If we build and run the project, we will get the following report. One item I should note is that this report had default values for each of the report parameters. Thus upon running the form, the report execution takes place and the report runs.

Sample Report

We can adjust the form to pass a parameter value to the ReportViewer control. In order to set the parameter and then re-run the report, we can add a simple textbox and then a button to refresh the report as shown below. For this particular report, we are going to adjust the Distance in miles parameter. In order to pass the parameter value, we need to find the exact parameter name from the report. For this report, the parameter name is "Radius".

textbox and button

In order to fully utilize the textbox and button, we do need to complete some quick coding to pass the parameter to the report.  As shown in the below code box, first we need to make sure we add a reference to Microsoft.Reporting.WinForms. 

Imports Microsoft.Reporting.WinForms

Public Class ReportViewer Form

Private Sub ReportViewer1_Load(sender As System.Object, e As System.EventArgs) Handles ReportViewer1.Load

Dim Dist As New ReportParameter
Dist.Name = "Radius" 'RDL Parameter Name
TextBoxDistance.Text = "200"
ReportViewer1.ServerReport.SetParameters(New ReportParameter() {Dist}) 'ReportViewer1.LocalReport.SetParameters(New ReportParameter() {Param1})

End Sub

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles RefreshReportButton.Click
Dim Dist As New ReportParameter
Dist.Name = "Radius" 'RDL Parameter Name
ReportViewer1.ServerReport.SetParameters(New ReportParameter() {Dist})
End Sub
End Class

Next, in the Reportviewer1_Load Sub, we need to add the above noted code. An explanation of each line of code is as follows:

  • Line 1 - Create the ReportParameter variable named Dist.
  • Line 2 - Set the name of the Dist variable to "Radius". Note this name needs to be the actual name of the parameter in the report.
  • Line 3 - Set the "default" number that shows in the text box to 200 (i.e. the Distance in Miles will default to 200 miles).
  • Line 4 - Set the Dist variable value to 200 (value in the textbox).
  • Line 5 - Sets the parameter value for the report to the Dist variable value.

Running the report with this first Sub would always set the Parameter for the Radius to 200. If we want to make the report interactive, we can add a second Sub attached to a button control which reads the textbox and refreshes the report when the button is clicked. This second sub does the following:

  • Line 1 - Create the ReportParameter variable named Dist.
  • Line 2 - Set the name of the Dist variable to "Radius". Note this name needs to be the actual name of the parameter in the report.
  • Line 3 - Clears the default or previous value of the Dist variable. 
  • Line 4 - Set the Dist variable value to the value in the textbox.
  • Line 5 - Set the parameter value for the report to the Dist variable value.
  • Line 6 - Refreshes the report.

Now, we have a working Windows application that calls the report and allows for setting the Distance parameter, as illustrated below. The second screen shot shows setting the parameter to 312.

Default Report

Report with parameter set

Our Windows Form now includes a fully functioning report server report. Of course, we could add list boxes and other controls to further enhance the report processing.


SSRS reports can be initiated from a Windows Form using the ReportViewer controls available in Visual Studio. The form can process in remote mode where the processing is handed over to an existing SSRS server or in local mode. Local mode had limited functionality whereas remote processing provides full SSRS functionality. In order to use the ReportViewer control, it most often must be added to your Visual Studio toolbox; once in your toolbox, it can be added to a form where you then set the URL of the report server, report folder and file location. Additionally, the report's parameters can be initiated, set, and passed programmatically to the report itself.

Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Wednesday, July 3, 2019 - 9:59:34 AM - Steve Back To Top (81665)

I've now foudn that the 403 error is gone, as I seem to have been specifying the URL data incorrectly. However, now the report viewer doesn't make any appearance at all. It's as if nothing actually happens when the code to "Show" that control executes. Here's the code that does the work, so if anyone knows what I may have done incorrectly, please let me know:

    Private Sub GetImpactButton_Click(sender As Object, e As EventArgs) Handles GetImpactButton.Click
        Dim VendorID As String, Vendor As String, strSQL As String, strPartsList As String, I As Integer, strNewPrices As String, strNewEffDates As String
        Dim strExcelRows As String
        VendorID = VendorID_TB.Text.ToString
        Vendor = VendorCB.Text.ToString
        strPartsList = ""
        strNewPrices = ""
        strNewEffDates = ""
        strExcelRows = ""
        I = 0
        For Each row As DataGridViewRow In DGV1.Rows
            I = I + 1
            If row.Cells(8).Value = 1 Then
                If (Not row.IsNewRow) And (Not row.Cells(0) Is DBNull.Value) Then
                    strPartsList = strPartsList & row.Cells(3).Value.ToString & ","
                    strNewPrices = strNewPrices & row.Cells(5).Value.ToString & ","
                    strNewEffDates = strNewEffDates & row.Cells(4).Value.ToString & ","
                    strExcelRows = strExcelRows & row.Cells(0).Value.ToString & ","
                End If
            End If
        strPartsList = Microsoft.VisualBasic.Left(strPartsList, Len(strPartsList) - 1)          ' & "'"
        strNewPrices = Microsoft.VisualBasic.Left(strNewPrices, Len(strNewPrices) - 1)          ' & "'"
        strNewEffDates = Microsoft.VisualBasic.Left(strNewEffDates, Len(strNewEffDates) - 1)    ' & "'"
        strExcelRows = Microsoft.VisualBasic.Left(strExcelRows, Len(strExcelRows) - 1)          ' & "';"
        Dim ErrorMessage As String
        'Set the processing mode for the ReportViewer to Remote  
        RV1.ProcessingMode = ProcessingMode.Remote
        Dim serverReport As ServerReport
        serverReport = RV1.ServerReport
        'Get a reference to the default credentials  
        Dim credentials As System.Net.ICredentials
        credentials = System.Net.CredentialCache.DefaultNetworkCredentials
        'Get a reference to the report server credentials  
        Dim rsCredentials As ReportServerCredentials
        rsCredentials = serverReport.ReportServerCredentials
        'Set the credentials for the server report  
        rsCredentials.NetworkCredentials = credentials
        'Set the report server URL and report path  
        serverReport.ReportServerUrl = New Uri("https://myservername/reportserver")
        serverReport.ReportPath = "/Reports/SFT/PURCHASING/SFT Price Change Impact Analysis"
        'Create the VendorID report parameter  
        Dim VendorIDParm As New ReportParameter()
        VendorIDParm.Name = "VendorID"
        'Create the PartList report parameter  
        Dim PartListParm As New ReportParameter()
        PartListParm.Name = "PartList"
        'Create the NewPriceList report parameter  
        Dim NewPriceListParm As New ReportParameter()
        NewPriceListParm.Name = "NewPriceList"
        'Create the NewEffectiveDates report parameter  
        Dim NewEffDatesParm As New ReportParameter()
        NewEffDatesParm.Name = "NewEffectiveDates"
        'Create the VendorID report parameter  
        Dim ExcelRowsParm As New ReportParameter()
        ExcelRowsParm.Name = "ExcelRows"
        'Set the report parameters for the report  
        Dim parmList As Generic.List(Of ReportParameter) = New Generic.List(Of ReportParameter)()
        'Refresh the report
        RV1.AutoSize = True
        RV1.Visible = True
        Exit Sub
End Sub 

Tuesday, July 2, 2019 - 2:25:26 PM - Steve Back To Top (81659)


I've been scouring the web searching for a solution to a "403 Forbidden" error I'm getting after setting up a VB.Net Windows Forms application to use a report viewer control, and I get that error when I try to do the .SetParameters part in VB code.   My SSRS server has a self-generated certificate installed, and I do already have that ceritificate installed on my laptop, but maybe I need to do the credentials part in such a way that it uses the locally installed cert?   I've made any of a number of changes to how I create the parameters, which is currently a Generic.List of ReportParameter.   Let me know if you need more details as I can easily post the code that is breaking...   and thanks in advance!

Friday, July 22, 2016 - 11:56:39 PM - AB Masud Back To Top (41956)


pls solved this problem in C#


Sunday, March 6, 2016 - 12:47:29 PM - scott murray Back To Top (40872)

 Maybe try something like:





Saturday, March 5, 2016 - 10:50:05 PM - Jose Morales Back To Top (40869)

Great tip and article Scott.


I have a question.  I have my reporting services running in another server, so how do I pass the login information to the reporte execution server?

When I or call a report from the remote server ( a dialog asking me for the credentials to login. 

How can I do this programmatically?


Thursday, November 12, 2015 - 11:21:59 AM - Scott Murray Back To Top (39056)

I would think you could set the focus in VB... sorry I am not a VB coders, so I am not sure exactly how to do it.. maybe this would help:



Thursday, November 12, 2015 - 10:26:17 AM - Cindy Back To Top (39055)

I have inherited an application that has several reports that use ReportViewer.  My experience with SSRS is basic, and nill with ReportViewer (this app was purchased from and modified by an outside contractor) since our inhouse apps do things differently.  

To make this question simpler, the problem facing me is that a report has several parameters.  Based on the value of one parameter (school district), a dropdown list is populated (from a SQL query) with the schools in that district.  What is happening is that when the request to populate the dropdown list is returned from the server, the focus is not on the dropdown list (or even the district).

Is there a way to save focus before sending the request to the server, and restoring it when it comes back?  If so, how can this be achieved?

Thank you for any help you can provide.


Thursday, October 9, 2014 - 12:11:49 PM - me Back To Top (34907)


Thursday, October 9, 2014 - 10:39:47 AM - Scott Back To Top (34906)

I would think the print functionality should work.. I have not tried to complete it programatically.

Thursday, October 9, 2014 - 8:34:17 AM - Faran Back To Top (34904)

Great tip Scott. In the local processing mode, should the Print functionality work? When I try that, Internet Explorer stops working. Cheers

get free sql tips
agree to terms