Running a SSRS Report from a Windows Form Video

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


   Free MSSQLTips webinar - "Efficient Monitoring and Management of SQL Server" (click to register)



 
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




Get Started Now - Click here to get your free 14 day trial of SolarWinds Database Insights




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


Article Last Updated: 2017-08-10

Comments For This Article





download














get free sql tips
agree to terms