Tuesday, October 18, 2011

How-To Connecting SQL Server Report in Sharepoint


I have experience when i just install SQL Server 2008 R2 stand alone and a few month later i am install Sharepoint 2010.

When I want to make reporting in sharepoint with SQL Server 2008 R2, I just realized i have 2 problem :
  1. There is no Sql Server 2008 R2 Report Builder
  2. In Sharepoint, report server is missing

After i try to search information in google, this is step what i must do :
  1. Download and install Microsoft SQL Server 2008 R2 Report Builder 3.0
  2. Download and install Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies 
  3. Go To Program - Microsoft Sql Server 2008 R2 - Configuration Tools - Reporting Services Configuration Manager
  4. In Left side window - click Database - You will see information Report Server Mode : Native Mode
  5. Klik Change Database - choose "Create a New Report Server Database" - Klik Next - In change database window choose "Sharepoint Integrated Mode" - click Next-Next until finish. You will see like this : 

    6.  Go to Central Administration Sharepoint 2010 - "Site Action" - "Site Settings"
    7.  In "Site Collection Administration" - click "Site Collection Feature"


   8. Two Feature below - click Activate

 
    9. Click General Application Setting - Reporting Service - "Reporting Service Integration"
  10. In Report Server Web Service URL, Fill text box with URL from Web Service URL in
        Reporting  Service Configuration Manager

  11. Klik OK




I hope you can enjoy mytutorial, any advice is welcome :)




1 comment:

  1. Very informative post. I sometimes do presentations on SharePoint and was wondering if I could use your Print List example in my presentations and refer my audience to your website for further info.

    ReplyDelete