Generating a Multiple Table Crystal Report using VS 2005 - Choosing the Tables
(Page 3 of 4 )
For this report we will be using two of the tables from this database. Click on the tables Customers and Orders and transfer them from the Available Data Sources area to the Selected Tables area as shown. You may use the > and >> arrows to make the transfer, or double click the item in the left to make the transfer to the other side.
Now click on the Next button which takes you to the next step of the wizard, namely Link, as shown in the next picture. The Customers table has only the Primary key (shown in green) and the Orders Table is related to four other tables. The program has identified an existing relationship in the database file between the two tables. In the absence of such a pre-existing link you may need to link them. There are several options to manipulate the Links in this window.
Establish a Link between Tables
Database search efficacy depends on the indexing of columns and clicking on the Index Legend... button shows the color map for the indexing that may be associated with the Link window shown.
Accept the default linking through the common columns CustomerID and click on the Next Button. This brings up the next step of the wizard shown where you need to choose the fields that are to be included in your report. The fields in the Available Fields area have columns from both of the joined tables.
Next: Choosing Fields to Include in the Report >>
More Database Articles
More By Jayaram Krishnaswamy
/ 9 
