Lesson 1: Creating a Report Server Project for a Report Model-Based Query

Before you can build your report model query, you need to create a report server project in SQL Server Business Intelligence Development Studio. A report server project consists of at least one data source and any reports created using these data sources. In this lesson, you will create the report server project.

To create a report server project

  1. Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Business Intelligence Development Studio.

    The Microsoft Visual Studio 2005 window opens.

  2. On the File menu, point to New, and then click Project.

  3. In the Project types area of the New Project dialog box, verify that Business Intelligence Projects is selected.

  4. In the Templates area, select Report Server Project.

  5. In the Name box, type: RMQueryDesignerTutorial.

  6. Click OK. 

  7. On the File menu, click Save All.

    Your report server project was successfully created and saved.

In the next lesson, you need to create a shared data source that specifies a data source connection type and string. See Lesson 2: Creating a Data Source for a Model-Based Report in Report Designer.