User`s guide
Note:
If your database requires a user name and password, or any other log on information, a log on dialog
box appears.
3.
Highlight the query in the Views folder and any tables you want to include in your report and click
the > arrow.
4.
Click OK when you are finished with the Database Expert dialog box.
The Field Explorer dialog box appears.
Note:
The Links tab appears in the Database Expert if you have selected several queries and tables.
All of the queries and tables you highlighted from your Access database appear in the Field Explorer
dialog box.
5.
Locate your query in the Database Fields list, and double-click its name.
The query expands to display all the fields it contains.
6.
Highlight any fields you want to use in your report and add them to the Design tab.
Note:
You cannot use Access Action queries or Update queries in Crystal Reports. However, you can use
Access Select queries, Cross-tab queries, and Parameter queries. For more information about Parameter
queries, see Opening Access Parameter queries.
23.10.1.2 Opening Access queries through ODBC
ODBC gives you more control over which parts of a database you can use. For this reason, using an
Access query through ODBC may require a few extra steps.
23.10.1.2.1 To open an Access query through ODBC
1.
On the File menu, click Options.
2.
Click the Database tab.
3.
Ensure that the Views check box is selected.
Selecting "Views" automatically displays any available queries in your Access database.
4.
In addition, you can specify Table name LIKE and Owner LIKE options, if you wish.
• "Table name LIKE" is based on the SQL LIKE clause. This option allows you to specify the kinds
of table names you want to appear in the Choose SQL Table dialog box. You can use the
underscore character (_) or the percent sign character (%) as wildcards with this function. The
underscore character specifies any single character, while the percent sign signifies any character
string. For example, DAV_ matches DAVE only, while DAV% matches DAVE and DAVID. Table
name LIKE C% displays only those tables that have a table name beginning with the letter C.
2012-03-14554
Understanding Databases