Lesson 2: Creating a Data Source for a Model-Based Report in Report Designer

Before you can begin building your query, you need to create a data source that points to the report model that you want to use for your query. For the purposes of this tutorial, you will use the Adventure Works report model sample that came with Microsoft SQL Server 2008 R2. This tutorial assumes that you have already deployed the report model sample to the report server. In this lesson, you will create the data source used to access the report model.

To create a shared data source

  1. In Solution Explorer, right-click Shared Data Sources, and then select Add New Data Source.

  2. In the Name box, type: RMQDdatasource.

  3. In the Type drop-down list, select Report Server Model.

  4. In the Connection string area, type: Server=https://localhost/reportserver; datasource=/models/adventure works.

    Note

    By default, a report model is saved to the Models folder when it is deployed to the report server using Business Intelligence Development Studio. This connection string reflects the default location. If you have deployed your report server to a different location on the report server, the connection string must reflect that. For example, if your report model is located in the Samples folder, your connection string should appear as the following: Server=https://localhost/reportserver; datasource=/Samples/Adventure Works

  5. Select Credentials.

  6. Select UseWindows Authentication (Integrated Security) and then click OK.

    The data source appears in the Shared Data Sources folder in Solution Explorer.

  7. On the File menu, click Save All.

Next Steps

Now that you have created a data source, you can build a report model-based query. In the next lesson, you will use the Report Wizard to open the Report Model Query Designer, and then create a query that displays product sales by year. In addition, you will apply a filter to the query. See Lesson 3: Creating a Report Model-Based Query.