Database Reference
In-Depth Information
The Data Connection Wizard
Once the Data Connection Wizard launches, it asks for the database server name (Figure
15-4
).
Figure 15-4.
Making a connection to your database server
Click Next, and you are given an option to select a table or view from the data warehouse to use for your
report. Unfortunately, you cannot select more than one table, so the most obvious choice is to use a view that
delivers data from multiple tables. In Chapter
13
, we created a number of reporting queries, including one view
called vQuantitiesByTitlesDate. As Figure
15-5
shows, we can select that from the list.
■
All the code needed for the views demonstrated in this chapter can be found in the file
and execute the sQl code. Doing so allows you to follow along as we go through each example.
Important