Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Running a SSRS Report from a Windows Form Video


By:   |   Read Comments   |   Related Tips: > Reporting Services Development


Free MSSQLTips Webcast Today >> Optimize SQL Server Performance




 






Enter your 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 Update:


signup button

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





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools