Lesson 1: Creating a New Report
Before you begin working with dynamic queries, you must first create a Report Server project in Business Intelligence Development Studio, and then add a report item to the project.
To create a new report server project
Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click Business Intelligence Development Studio.
On the File menu, point to New, and then click Project.
In the Project Types list, click Business Intelligence Projects.
In the Templates list, click Report Server Project.
In Name, type Dynamic Query Tutorial.
Click OK to create the project.
To create a report definition file
In Solution Explorer, right-click Reports, point to Add, and click New Item.
Note
If the Solution Explorer window is not visible, from the View menu click Solution Explorer.
In Add New Item, click Report.
In Name, type Employee List.rdl and then click Add. A view opens that contains Data, Layout, and Preview tabs. This is the Report Designer component of Business Intelligence Development Studio. The report opens in Data view.
Next Steps
After you create a report server project and report item, you can continue to the next step: Lesson 2: Creating the Employees Dataset.
See Also
Concepts
Tutorial: Using a Dynamic Query in a Report
Other Resources
Using Dynamic Queries
Creating a Report with Report Designer