Lesson 01: How to Setup SQL Server integrated Reporting Services - configure SQL and Sharepoint

In this article, we will know how to setup and configure SQL Server 2008 R2.

Run file setup SQL Server R2 | click link “Installation” | click link “New Installation or add features to an existing installation”

Set default | click Next

Check to “I accept the license terms” and click Next

Click Install

Click Next

Set default and click Next

Click button Select All then click Next

Click Next

Choose radio button “Named Instance” and enter Sharepoint then click Next

Click Next

Click button “Use the same account for all SQL Server services”

Dialog box appear, Enter account name and password then click ok and click Next

Click button Add Current User

Click radio button “Install the Sharepoint integrated mode default configuration” (Important)

Click Next

Click Next

Click Install

Wait processing

After setup finish, click Close

Continue configure SQL Reporting Services in SQL Server and Central Admin.

Click start | Expand Microsoft SQL Server 2008 R2 | Reporting Services Configuration Manager

Dialog box appear, click Connect

Click “Web Service URL” link, then you can change port number to your web application and click apply (should set default)

Result is connect successfully

Click to your URLs  link

Result below, you copy link above address bar

Open Central Admin | Click to “General Application Setting” link

In categories Reporting Services | click to “Reporting Services Integration” link

Paste address which you copied above to textbox, and choose Windows Authentication in Dropdownlist then click OK

Result Reporting Services is Actived

Go you web site | click Site Actions | Edit Page

Click tab Insert | click Web Part

In categories | choose SQL Server Repoting…|SQL Server Repoting Services Report then click Add

Result below is successful

Read More

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

Read More