ĐÀO TẠO DOANH NGHIỆP : SỞ KHOA HỌC CÔNG NGHỆ TỈNH ĐỒNG NAI

ENTERPRISE TRAINING: DONG NAI DEPARTMENT OF SCIENCE AND TECHNOLOGY.

HÌNH ẢNH TẬP HUẤN LỚP SHAREPOINT WORKFLOW VÀ KIẾN TRÚC SHAREPOINT

PHOTOS OF SHAREPOINT WORKFLOW AND ARCHITECTURE CLASS.

HÌNH ẢNH TẬP HUẤN LỚP SHAREPOINT WORKFLOW VÀ KIẾN TRÚC SHAREPOINT

PHOTOS OF SHAREPOINT WORKFLOW AND ARCHITECTURE CLASS.

Friday, March 2, 2012

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

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