Wednesday, December 11, 2013

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

You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.

Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...