Page 295 - Open Soource Technologies 304.indd
P. 295
Unit 13: Working With Reports
Figure 13.8: Data Link Property.
Step 3: Retrieving Information from the Database.
In order to use the database in your report, you need to create query to retrieve the information
from the database. Here , we will use SQL command to create the query. First of all, right click
on MyConnection to add a command to the data environment. The default command is Command1,
you can rename it as MyCommand, as shown in Figure 13.9.
LOVELY PROFESSIONAL UNIVERSITY 289
