When I want to make reporting in sharepoint with SQL Server 2008 R2, I just realized i have 2 problem :
- There is no Sql Server 2008 R2 Report Builder
- In Sharepoint, report server is missing
After i try to search information in google, this is step what i must do :
- Download and install Microsoft SQL Server 2008 R2 Report Builder 3.0
- Download and install Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
- Go To Program - Microsoft Sql Server 2008 R2 - Configuration Tools - Reporting Services Configuration Manager
- In Left side window - click Database - You will see information Report Server Mode : Native Mode
- 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 :
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 :)




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