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

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


This requirement applies only to Report Builder 1.0. Report Builder 3.0 can use other data sources as well as report models.

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).


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

To generate a report model

  1. Open the library or a folder within a library.

  2. Click Documents.

  3. On the NewDocument menu, click Report Builder Model.

    The Generate Model page appears.

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

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

    The Select an Item dialog box opens.

  6. 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. Open the library or a folder within a library.

  2. Click Documents.

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

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

    The Regenerate Model page appears.

  5. Click OK.

    The model is regenerated.