Tuesday, September 15, 2015

Deploy your SSRS reports to Report Server through BIDS/Report Builder/SQL Server Data Tools

After you finish your SSRS report, you need to deploy it to let other users to use it. You can use the built-in deployment features in SQL Server Data Tools (SSDT) to publish the reports to a report server.

Before you can publish a report, you must have permission to do so. Permission is determined through role-based security that is defined by your report server administrator. Publishing operations are typically granted through the Publisher role.

SQL Server Data Tools (SSDT) provides project configurations for managing report publication. The configuration specifies the location of the report server, the version of SQL Server Reporting Services installed on the report server, whether the data sources published to the report server are overwritten and so forth.

Right click on Solution of your project name upon Solution Explorer, and choose Properties, following window will popup.


By default, SQL Server Data Tools (SSDT) provides three project configurations: DebugLocal, Debug, and Release. The default configuration is DebugLocal. You typically use the DebugLocal configuration to view reports in a local preview window, the Debug configuration to publish reports to a test server, and the Release configuration to publish reports to a production server.

Right click on your project name upon Solution Explorer, and choose Properties, following window will popup.


Go to the report server URL to check whether Report server URL is working fine or not.

Right click on your project name upon Solution Explorer, choose Deploy,
To verify whether report deployed successfully or not, go to Report server URL click on the My Report folder link and run the report.


Source:
https://msdn.microsoft.com/en-ca/library/ms159270(v=sql.120).aspx
http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html



No comments:

Post a Comment