Section 6.2. Create a Data Source View


6.2. Create a Data Source View

Create a data source viewa logical data model based on the data sourcefor the Adventure Works data source. Follow these steps.

  1. Right-click the Data Source Views node in the Solution Explorer pane. Select Add New Data Source View from the context menu to launch the Data Source View Wizard.

  2. If the Welcome dialog for the Data Source View Wizard appears, click the Next > button.

  3. Select the Adventure Works data source in the Select a Data Source dialog as shown in the following figure.

    Figure 6-3. Data Source View Wizard: Select a Data Source

  4. Click the Next > button to open the Select Tables and Views dialog shown in the following figure.

    Figure 6-4. Data Source View Wizard: Select Tables and Views

  5. Click the >> button to include all of the tables and views from the AdventureWorks database in the data source view.

  6. Click the Next > button to open the Completing the Wizard dialog shown in the following figure.

    Figure 6-5. Data Source View Wizard: Completing the Wizard

  7. Click the Finish button in Completing the Wizard to create the new data source view and end the wizard.

The new data source view Adventure Works.dsv appears in the Solution Explorer pane under the Data Source Views node.



SQL Server 2005 Reporting Essentials
SQL Server 2005 Reporting Essentials
ISBN: 735617880
EAN: N/A
Year: 2007
Pages: 31

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net