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