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

SQL Server Reporting Services Expressions Tips and Tricks

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