Running a SSRS Report from a Windows Form Video

By:   |   Updated: 2017-08-10   |   Comments   |   Related: > Reporting Services Development


Enter your business email address to
get free SQL Server tips.

Problem / Solution

SSRS reports can be run 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, a reference must be added to your Visual Studio toolbox; once in your toolbox, it can be added to a form where you then 1) set the URL of the report server and 2) set the report folder and file location. Additionally, the report's parameters can be initiated, set, and passed programmatically to the report itself. 

Read Companion Tip

Click Here

Last Updated: 2017-08-10

get scripts

next tip button

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

View all my tips

Comments For This Article


Recommended Reading

Working With Multi-Select Parameters for SSRS Reports

SQL Server Reporting Services Using Multi-value Parameters

Resolving the Maximum Request Length Exceeded Exception in SQL Server Reporting Services

Multi-detail reports using sub reports in SQL Server Reporting Services

Multiple Row Grouping Levels in SSRS Report

get free sql tips
agree to terms