Is Report Builder available in SharePoint Integrated Mode?
Reporting Services and SharePoint Technology Integration Answer:Yes. After integrating with SharePoint, what you need to do is to add Report Builder Model through Content Types: 1. Open SharePoint website as administrator. 2. Click Report Center website. 3. Click Site Actions list. 4. Select Site Settings and then select Modify Pages Library Settings. 5. On Content Types part, click Add from existing site content types. 6. Select Report Server Content Types from site content types drop-down list. 7. Select Report Builder. 8. Click OK to finish. After that, you will be able to use Report Builder. Please Note: Currently, Report Builder 2.0 has been released as a stand-alone installation for SQL Server 2008 Reporting Service. However, Report Builder 1.0 can still be used for SharePoint as a “click-once” application. This function will be included in the future service pack of SQL Server 2008.