1. Install the SSRS Service in SharePoint.\u00a0<\/strong> \nThis is best done through SharePoint 2013 Management Shell by running the following commands:.<\/pre>\nInstall-SPRSService<\/span><\/pre>\nInstall-SPRSServiceProxy<\/span><\/pre>\nget-spserviceinstance -all |where {$_.TypeName -like \u201cSQL Server Reporting*\u201d} | Start<\/span>-SPServiceInstance<\/pre>\nNote, you will not get a response or acknowledgement from the first two commands.\u00a0 If you are the kind of person who needs affirmation, let me tell you you’re doing fine.\u00a0 Here’s a screenshot. so far.![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.00.39-PM-300x148.jpg\")
<\/a><\/p>\n2. Create the SSRS Service Application in the SharePoint Administrators site.<\/strong><\/p>\nNow that the service is installed and available to SharePoint, you can log into the SharePoint Admministrator site as an Administrator to create the application.<\/p>\n
2.1\u00a0 Click to open ‘Application Management Group’<\/p>\n
2.2 Click to open ‘Manage Service Applications’<\/p>\n
2.3 Click ‘New’ button to create a new application and you should have a list of services that includes ‘SQL Server Reporting Services Service Application’.<\/p>\n
If SSRS is not in the list, then something was not installed properly or the PowerShell command did not start the service.\u00a0 I take back that affirmation, you need to go back to step 1.<\/p>\n
Your list should look like this:<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.00.51-PM-164x300.jpg\")
<\/a><\/p>\n2.4\u00a0 The ‘Create SQL Server Reporting Service Application’ pop-up window requires some inputs as follows.<\/p>\n
Name:\u00a0 I named mine ‘SSRSdemo’<\/p>\n
Application Pool name:\u00a0 I named mine ‘SSRSdemopool’<\/p>\n
First page of the pop-up should look like this:![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.23.08-PM-300x239.jpg\")
<\/a><\/p>\nWeb Application Association:\u00a0 Check the box so the SSRS is associated with the proper SharePoint site.\u00a0 If you only have one site, then you only have one choice like mine below.<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.17.12-PM-300x238.jpg\")
<\/a><\/p>\n2.5\u00a0 Click ‘OK’ to create the SSRS App.\u00a0\u00a0 Hopefully you get a success message like this.<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.29.15-PM-300x87.jpg\")
<\/a><\/p>\n2.6 Click ‘OK’ to the message and your shiny new SSRS App will be listed in your Service Applications.\u00a0 To manage other settings you can click the App name.<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.31.27-PM-300x164.jpg\")
<\/a><\/p>\n3.\u00a0 Create a place for reports in the SharePoint user site.<\/p>\n
3.1\u00a0 Log in to the site with Admin credentials.<\/p>\n
3.2\u00a0 In SharePoint 2013, apps and libraries are added using the little gear symbol in the upper right corner.\u00a0 Click the gear and click ‘Add an App’.![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.48.36-PM.jpg\")
<\/a><\/p>\n3.3 From the list of Apps, click ‘Document Library’.\u00a0 I named mine ‘Reports’<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.46.27-PM-300x170.jpg\")
<\/a><\/p>\n3.4\u00a0 Once the App is created, you will be presented with an empty library.\u00a0 We need to change the library to accept SSRS items, so click the ‘Library Settings’ button.<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.51.34-PM-150x150.jpg\")
<\/a>3.5\u00a0 In the settings, click Advanced Settings so we can start managing the content types.<\/p>\n![\"oint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.52.12-PM-300x136.jpg\")
<\/a>
\n3.6\u00a0 Now you will have the option to select Content Types.\u00a0 Just under the list of settings, is a new section ‘Content Types’.\u00a0 Under that,\u00a0 Click ‘Add from existing site content types.![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.58.25-PM-300x61.jpg\")
<\/a><\/p>\n3.7\u00a0 A new window opens with selector boxes allowing you to choose content types.<\/p>\n
Highlight in the left box and click Add to add the following types:<\/p>\n
\n- Report<\/li>\n
- Report Builder Model<\/li>\n
- Report Builder Report<\/li>\n
- Report Data Source<\/li>\n<\/ul>\n
It should now look as follows.\u00a0 ![\"3](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-5.01.25-PM-300x119.jpg\")
<\/a><\/p>\nClick OK.<\/p>\n
3.8\u00a0 Done!<\/p>\n
You have now configured SharePoint 2013 to work with SQL Server Reporting Services in Integrated mode.<\/p>\n
You should now be able to deploy reports.\u00a0 In my example library above named ‘Reports’ on a server named DEVBOX the deployment URL will be:\u00a0 http:\/\/devbox\/Reports<\/p>\n
If you want to separate shared data sources and data set files,\u00a0 you need to navigate to the empty library and use the Files menu ‘New Folder’ button create the folders before deploying the project.\u00a0 Each setting requires the full URL to the subfolder.\u00a0 If you used spaces, click the elipses (…)\u00a0 to get the proper url.<\/p>\n
Here is the view of an SSRS Project Properties box ready to deploy.<\/p>\n
![\"SharePoint](\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/08\/Screen-Shot-2013-08-22-at-4.00.39-PM.jpg\")
<\/a><\/p>\n