Steps to Configure SSRS in SharePoint 2013 in integrated mode
- Download and install .mssi
-
Configure SQL server and add reporting feature
-
Run Power shell Commands
-
Create A service Application in central admin
-
Create a new Document library for storing
reports and add SSRS related Content Types
-
Create Reports
-
Deploy reports
-
Show Reports in SharePoint Page in Web Part
Download and
install rsSharePoint.msi
Download and install the rsSharePoint.msi. from here http://www.microsoft.com/en-in/download/details.aspx?id=35583
So that, PowerShell can recognise your ssrs related
commands, else you will keep getting this error
“The term 'Install-SPRSService' is not
recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that
the path is correct and try again”.
Make sure you are downloading the appropriate version of
the installable.
Configure SQL
server and add reporting feature
Now, go to your SQL server installation centre
-Select new sql server standalone installation or add
feature to your existing installation
-In choose media option select your set up (or .exe) folder.
-keep going till feature selection section.
- Now, under feature selection select
Reporting service – SharePoint
Reporting service add in- SharePoint
img
Press next.
-
Now under installation of report add in select “
Reporting service SharePoint integrated mode”
img
-
And finish the installation.
Run Power shell
Commands
Run these PowerShell to get the option of creating a new
SSRS Service application and proxy in SharePoint central admin
1.Install-SPRSService
2.Install-SPRSServiceProxy
3.get-spserviceinstance -all |where {$_.TypeName -like “SQL Server
Reporting*”} | Start-SPServiceInstance
Create a SSRS service
Application in central admin
-
Go to Central admin -> application management
-> manage service application
-
Now, click on new and select SQL server
reporting application.
-
Give and name like SSRS and create a new APP
Pool.
-
Select the Web Application for which you want to
configure SSRS.
Configuration is done.
Now, to create reports follow these steps
Create a new Document
library for storing reports and add SSRS related Content Types
Activate a Project Server feature
Create a document library and add these content types
Create a document library and add these content types
Report Builder model
-Report builder report
-Report datasource
-Now go to your Document Library ->files-> click new
Choose “Report Builder Report”
Deploy reports and
show reports in Page
Now you can create and design the reports and save them in
your document library. To Show the reports in a page just add and configure “sql
server reporting service web part”.
