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 Next2 report wizard
  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 database3 datasource setup in ssrs report project
  4. From the connection Properties dialog box, Specify the Server Name and Database in which our required data live4 set datasource connection properties
  5. Now, We get the connection string for our data source. Click on Next5 report wizard setup datasource
  6. Click on “Add Table” icon from Query Designer, Choose the Tables query, Click on “Add”6 query builder add table
  7. Pick the columns to use in the Report. Click on OK.7 query designer select fields
  8. Now we got the query to use in our reports. Click on Next.8 query builder query string
  9. Move fields to relevant sections, such as on Page, Group, and on Report Details section.9 design table fields
  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.10 report locations
  11. Finally, Give a Name to the report. Click on Finish.11 complete report
  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 is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

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

  • December 13, 2016 at 4:51 PM

    Can you deploy ssrs reports to a FBA based web application

    Reply

Leave a Reply