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





download


Recommended Reading

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

Working With Multi-Select Parameters for SSRS Reports

Add a Date Range Dataset in SQL Server Reporting Services





get free sql tips
agree to terms


Learn more about SQL Server tools