8.3. Deploying Reports with Report Builder 2.0

Another report-authoring tool that can be used to deploy reports to SharePoint is Report Builder. With Report Builder 2.0, you can allow your power users to create reports and deploy them directly to SharePoint.

Once a report is created or opened in Report Builder, deploying the report to SharePoint is no different from saving a Word document to SharePoint. To deploy a report, click the Save As button on Report Builder, as shown in Figure 8-28. In the Save dialog, type the URL of the SharePoint site you wish to save the report to and click OK.

Figure 8-28. Figure 8-28

Also, in the Report Builder Options, you can specify the default SharePoint site by clicking the Office button and clicking Options. On the Options screen, add the URL of your default site, as shown in Figure 8-29. Once you do this, Report Builder will always start from this location when you are saving a report.

Figure 8-29. Figure 8-29

Get Professional Microsoft® SharePoint® Server 2007 Reporting with SQL Server 2008 Reporting Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.