Wednesday, September 16, 2015

Deploy your SSRS reports to Report Server through Report Manager

Deploying your SSRS reports using Report Manager has various difference than using BIDS/SSDT. Its admin centered not developer centered. With BIDS, you can set data source directory and report directory within project properties. Using Report Manager, however, you need to create those directories by yourself.
  • First, Go to Report Manager URL using Reporting Services Configuration Manager. e.g. http://SERVERNAME/reports.

  • Second, Click the New Folder button, following screen will popup.
  • Third, Fill the Name textbox, e.g. Report Manager Deployment Example and click OK. The Report Manager now displays the new folder. 

  • Fourth, Click on the folder Report Manager Deployment Example to enter the folder, and then click on the above New Data Source button to create and configure your data source as follows. 

The following are the main points about creating a data source:
  1. You have to enter the connection string; there is no helper dialog
  2. The Connect using option selected is Windows integrated security; this means the report executes using the Windows credentials of the caller; the caller must have at least read permission on the database
  3. The Credential stored securely in the report server option along with checking Use as Windows credentials when connecting to the data source is a good choice when you don't want to give the users running the report read permission on the database; rather you specify User name as DOMAIN\USERNAME and give just that account read permission on the database
  • Fifth, After clicking OK to finish creating your data source, click the Upload File button to deploy a report. Fill in the dialog as shown below by navigating to the report that you want to deploy. I navigated to the folder where our BIDS project was saved and picked the file ReportDesignerExample.rdl (reports are stored in XML files with a .RDL extension): 
  • After clicking OK to deploy the report, you can click on the report in the Report Manager to run it.  

Resouce:
http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html
https://www.mssqltips.com/sqlservertutorial/247/report-manager/

No comments:

Post a Comment