Lets create a SQL Server Reporting Services Report using Visual studio and publish to SharePoint 2013 site:
- 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.
- This opens Report Project Wizard. Click Next
- 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
- From the connection Properties dialog box, Specify the Server Name and Database in which our required data live
- Now, We get the connection string for our data source. Click on Next
- Click on "Add Table" icon from Query Designer, Choose the Tables query, Click on "Add"
- Pick the columns to use in the Report. Click on OK.
- Now we got the query to use in our reports. Click on Next.
- Move fields to relevant sections, such as on Page, Group, and on Report Details section.
- 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.
- Finally, Give a Name to the report. Click on Finish.
- 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!)
Here is the report we've deployed to SharePoint.
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Five Challenges in SharePoint Security
...And How to Solve Them. Free White Paper