Lesson 02: How to make Reporting Services Connect SQL Server Database

In this article, we will know how to SSRS connect database SQL Server.

Step 1: Click Start | Microsoft SQL Server 2008 R2 | SQL Server Business Intelligence Development Studio

Step 2: Choose Report Server Template and named is RPConnectToDBSQLServer

Step 4: Right click Shared Data Sources | Click Add New Data Source

Step 5: Name set default  is  DataSource1, Type choose Microsoft SQL Server then click button Edit

Step 6: Choose Server Name, then choose database name and click OK

Step 7: Click OK

Step 8: Right click Report | Click Add New Report

Step 9: Click Next

Step 10: Enter query (Select * from TableName) then click Icon below and click OK

Step 11: Click Next (in Editor, you can edit query similar to use SQL Server query)

Step 12: Set default then click Next

Step 13: Choose column and click "Details>" button then click Next

Step 14: Set default then click Next

Step 15: Enter Report name is: SSRSResources | Check to Preview report and click Finish

Step 16: Result below

Step 17: Right click to SSRSResources.rdl | View code

Step 18: Find ( Ctrl + F => Enter <DataSource Name ) to code here (default)

Step 19: Replace code Above by code here

Step 20: Result below

Step 21: Open your site | choose list library Shared Documents and Uploaded File | choose file to SSRSResources.rdl

Step 22: Result, SSRSResources added to here

Step 23: Back to Home page

Step 24: Click Site Actions | Edit Page

Step 25: Cick tab Insert | Web Part

Step 26: In categories | choose SQL Server Reporting | SQL Server Reporting Services …

Step 27: Click “Click hre to open the tool panel” link

Step 28: Click button …

Step 29: Click Icon “Up”

Step 30: Click Folder Shared Documents

Step 31: Choose file SSRSResources then click OK

Step 32: Result Below

Step 33: Click button OK

Step 34: Click Save and Close Icon, Result below