Page 33 - Open Soource Technologies 304.indd
P. 33
Unit 2: Working of VB Applications
Specify the location of the BIBLIO.MDB Access database
Select which tables from the database you want. For this example we will need the authors
table and the Title table.
check that the joins are correct in the Linking Export
Now we are ready to draw the report
Drag and drop the fields you want on to the report. So that it looks like the report above.
Now if you run it by selecting Print Preview, you can see what the report looks like.
Now save the report and we have a template that now can be used in VB.
Turn off the Save Data with report option if you want the data to contain new
information each time the report is used. Going to the File menu, selecting
Options and clicking on the Reporting Tab sets the option
There are many options in the Crystal Reports and as this tutorial is more of an overview
I will not be going into it. But one important thing to do is to get specific data. This is done
by a selection formula (i.e., the Where clause of a SQL statement).
LOVELY PROFESSIONAL UNIVERSITY 27
