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

New: 5 December 2005

Before you can build your report model query, you need to create a report server project in SQL Server Business Intelligence 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 2005, 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.

Next Steps

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.

See Also

Other Resources

Working with Report Model Query Designer
Report Model Query Designer F1 Help
Working with Models
Working with Report Designer
Introduction to Solutions, Projects, and Items
Introducing Business Intelligence Development Studio

Help and Information

Getting SQL Server 2005 Assistance