How to: Generate Report Models (SharePoint Integrated Mode)

New: 12 December 2006

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 (SharePoint Integrated Mode). For more information on enabling report model generation, see How to: Add Report Server Content Types to a Library (SharePoint Integrated Mode).

Note

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

See Also

Tasks

How to: Create a Model Using Report Manager
How to: Create a Model Using Management Studio

Concepts

Working with Models
Working with Model Designer
Generating Models Using Report Management Tools
Creating and Using Cube-Based Report Models
Creating and Using Oracle-Based Report Models
Model Designer How-to Topics

Help and Information

Getting SQL Server 2005 Assistance