How to Create and Deploy SSRS 2012 Reports to SharePoint 2013?

Reporting Services integrated with SharePoint 2013 gives you Rich enterprise reporting features. We’ve our SQL Server 2012 Reporting services integrated with SharePoint 2013 already. So now we can create reports for SharePoint 2013 using both SQL Server Report Builder 3.0 and using Visual Studio.

Lets create a SQL Server Reporting Services Report using Visual studio and publish to SharePoint 2013 site:

  1. Open Visual Studio 2010 Shell which comes with SQL Server 2012 (formerly “BIDS”), Choose New Project >> “Report Server Project Wizard” type, Give it a name. create SSRS report for SharePoint 2013
  2. This opens Report Project Wizard. Click Next
  3. We’ve to create a Data source for our report. Choose “New data source”, Give it a name and choose Type. In my case, data is in SQL Server. Click on “Edit” button to specify SQL Server database
  4. From the connection Properties dialog box, Specify the Server Name and Database in which our required data live
  5. Now, We get the connection string for our data source. Click on Next
  6. Click on “Add Table” icon from Query Designer, Choose the Tables query, Click on “Add”
  7. Pick the columns to use in the Report. Click on OK.
  8. Now we got the query to use in our reports. Click on Next.
  9. Move fields to relevant sections, such as on Page, Group, and on Report Details section.
  10. Choose the deployment location. In our case its our SharePoint site. Enter Report server as our SharePoint site URL and Deployment Folder as any existing document library URL in our SharePoint site.
  11. Finally, Give a Name to the report. Click on Finish.
  12. One last but not least step is: Go to Project Properties >> Set the Target Locations. Say we’ve a document library called “Reports” in our SharePoint site. Specify the document library’s full path here. (Set all attributes!)Deploy SSRS to SharePoint

Build and deploy the project, and we are done!

Report Output:
Here is the report we’ve deployed to SharePoint.

SQL Server Reporting Services 2012 Report Published to SharePoint 2013

We can also use “SQL Server Reporting Services Web Part” to display the report on any location.

SSRS 2012 integrated with SharePoint 2013

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

One thought on “How to Create and Deploy SSRS 2012 Reports to SharePoint 2013?

  • Can you deploy ssrs reports to a FBA based web application


Leave a Reply

Your email address will not be published. Required fields are marked *