How to Use reportbuilder to create reports in SharePoint integration mode

First, this post describes how to use the report function in SharePoint integration mode. The full text shows two parts: 1) How to Use reportbuilder to create reports; 2) How to Use webpart to display reports. The details are as follows:

I. Use report builder 3.0 to create reports

The main advantage of integration between SharePoint and reporting services is that users can create, modify, and publish reports from within Sharepoint. Reporting Services provides predefined content types that can be used to manage various files, including shared report data sources (. RSDs file and report builder model (. and report builder definition (. RDL) file. After you have configured integration to allow users to create and manage these new content types from the functional area and context menu, you need to enable the new content types on these libraries.

If you use a bi center site template, you do not need to perform any operations. The content type is automatically enabled in the template and all sites created using this template. For all other sites and document libraries, perform the two-step configuration process. First, you need to enable content type management in the library. Follow these steps to add the report-related content type to the database:

1. Open the library for adding the Reporting Services content type. 2. on the "library Tools" functional area tab, click the "library" tab. 3. In the "Settings" functional area group, click "library Settings ". 4. Under "content type", click "add from existing website content type ". 5. In the select content type section, select a website content type from the following list, click the arrow and select reporting services. 6. In the "available website content type" list, click "report builder", and then click "add" to move the selected content type to the "content type to be added" list. 7. To add the "Report Model" and "report data source" content types, repeat steps 5 and 6. 8. After selecting all the content types to be added, click OK ".

After adding the new content type to the library, three new options are displayed in the "New Document" drop-down list on the "documents" tab. If you select the report builder report option, report builder 3.0 is downloaded to the client and run the program. You can change this behavior from the SharePoint management center. On the "Reporting Services Server default" page, you can disable this option and configure other URLs for the report builder.

2. Use the report viewer Web part on the SharePoint site

The report viewer Web part is a custom web part installed by an external program of reporting services. You can use this Web part to view, navigate, print, and export reports on the Report Server. To add a Web part to the page, follow these steps:

1. Open or create a Web Part Page or panel. 2. Click "Edit page" on the "Site Operations" menu ". 3. Click Add Web parts ". 4. In the Web Part category list, select "Miscellaneous" and select "SQL Server Reporting Services report viewer ". 5. Click Add ". The Web part is added to the top of the area. You can drag it to other locations in the region. 6. In the viewer, click "Click here to open the tool pane ". 7. Click Browse (...) to select a report from any database in the current website set. You can also enter the report URL. To determine the URL of any report, right-click the report and select "properties ". Do not click the downward arrow next to the report. The report URL is not specified on the "View Properties" page of the report item. If you copy and paste a URL from the Properties dialog box, replace "% 20" with a space (for example, "company % 20sales" should be "company sales "). Note: Each report viewer Web part contains a report. The URL must be a fully qualified path for the current SharePoint site, the same web application, or the Report on the on-site. The URL must be resolved to a document library or a folder in the document library that contains reports. The report URL must contain the. RDL file extension. If the report depends on a model or shared data source file, you do not have to specify these files in the URL. The report contains references to the required files. 8. When the tool pane is opened, you can set properties to modify the default appearance and layout. 9. Click Apply at the bottom of the tool pane, and then click OK to close the pane.

See http://technet.microsoft.com/zh-cn/magazine/ff686706.aspx