How to: Generate Report Models (Reporting Services in SharePoint Integrated Mode)

Before you can begin to create reports in Report Builder, at least one model must be available within the SharePoint farm.

You can generate models from an Analysis Services cube, a SQL Server database, or an Oracle database by using a SharePoint product or technology. Report models are generated from shared data sources that are published to a report server in SharePoint integrated mode and can be accessed via a SharePoint library. Before you can generate a report model, a shared data source file must be available in the SharePoint site or library. For more information, see How to: Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode). For more information on enabling report model generation, see How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

Note

Whenever the database schema is modified, the model must be regenerated in order to see the changes.

To generate a report model

  1. If the library is not already open, click its name on the Quick Launch. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. On the New menu, click Report Builder Model.

    The Generate Model page appears.

  3. In the Name text box, type a name for your report model.

  4. To select a data source, click the Data Source Link ellipsis (…) button.

    The Select an Item dialog box opens.

  5. Select the data source that you want to use for your model, and then click OK.

    The model is generated and added to the site or folder that you have open.

To regenerate a report model

  1. If the library is not already open, click its name on the Quick Launch. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. Point to the model that you want to regenerate.

  3. Click the down arrow, and click Regenerate Model.

    The Regenerate Model page appears.

  4. Click OK.

    The model is regenerated.