Lesson 2: Creating a Data Source for a Model-Based Report in Report Designer
New: 5 December 2005
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 2005. 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
In Solution Explorer, right-click Shared Data Sources, and then select Add New Data Source.
The Shared Data Source dialog box opens with the General tab selected.
In the Name box, type
RMQDdatasource
In the Type drop-down list, select Report Server Model.
In the Connection string area, type.
Server=http://<servername>/reportserver; datasource=/<modelpath>/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. If you have deployed your report server to a different location on the report server, you must reflect this path in the connection string. For example, if your report model is located in the Models folder, your connection string should appear as the following: Server=http://<servername>/reportserver; datasource=/Models/Adventure Works
Select the Credentials tab.
Select UseWindows Authentication (Integrated Security) and then click OK.
The data source appears in the Shared Data Sources folder in Solution Explorer.
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.
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