Reporting Services:
In this step, you will add a report to the Tutorial project. This step creates a new report definition file.
To create a new 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, in the View menu, click Solution Explorer.
In Add New Item, click Report.
In Name, type Sales Orders.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.
The following diagram illustrates the Add New Item dialog box, used for adding reports and other items to a project.
You have successfully added a report to the Tutorial report project.
Next, you will specify a data source to use for the report. See Lesson 3: Setting Up Connection Information.
After you add a report to the Tutorial project, you need to define one data source that provides data to your report. In Reporting Services, data that you use in reports is contained in a dataset. A dataset includes a pointer to a data source and the query to be used by a report.
In this tutorial, you will use the AdventureWorks sample database as your data source. This tutorial assumes that this database is located in the default instance of SQL Server Database Engine installed on your local computer.
To set up a connection
In the Data tab, expand the contents of the Dataset drop-down list at the top of the page, and select New Dataset. The Data Source dialog box appears.
In Name, type AdventureWorks.
In Type, select Microsoft SQL Server.
In Connection string, type the following:
Data source=(local); initial catalog=AdventureWorks
Note:
This connection string assumes that Business Intelligence Development Studio, the report server, and the AdventureWorks database are all installed on the local computer and that you have permission to logon to the AdventureWorks database. For more information about connection strings, see Connecting to a Data Source and Data Source (General Tab, Report Designer).
Click OK. AdventureWorks is added to the DataSets pane.
The following diagram illustrates the Data Source dialog box, a standard dialog box used for specifying a connection to a data source.
You have successfully defined a connection to the AdventureWorks sample database.
Next, you will create the report.
See Lesson 4: Defining a Query for the Report.
