User`s guide
• "Owner LIKE" is also based on the SQL LIKE clause. Owner LIKE allows you to select the Owner
(or Creator or Alias) of the table, not the table name itself. For example Owner LIKE C% displays
only those tables that have an owner beginning with the letter C.
5.
Click OK to exit the Options dialog box.
6.
Create a new report and choose ODBC as the data source for your Access database.
7.
Locate and select the data source that contains the Access query you want to use.
Note:
If your database requires a user name and password, or any other log on information, click Next to
go to the Connection Information dialog box.
Tip:
Choosing an ODBC data source and entering connection information automatically logs you onto
the server.
8.
Highlight your query in the Views folder, click the > arrow, and then click OK.
The Design tab appears along with the Field Explorer dialog box. Your Access query, and all fields
associated with that query, appear under "Database Fields."
Note:
You cannot use Access Action queries or Update queries in Crystal Reports. However, you can use
Access Select queries and Cross-tab queries.
23.10.1.3 Opening Access Parameter queries
Access Parameter queries can be opened only when you open an Access database via ODBC. Make
sure you have an ODBC data source set up for your Access database before attempting this procedure.
See Setting up an ODBC data source.
Note:
When you design a Parameter query in Access, you must provide a prompt for the query and specify
a data type for the parameter. First, with your query open in Design View in Microsoft Access, enter a
prompt in the Criteria cell for the field that will act as a parameter. Then, choose Parameters from the
Query menu in Access, and specify a data type for the parameter you just created. Make sure the
prompt appears exactly as it does in the Criteria cell. For complete instructions, refer to your Access
documentation. If you do not set up your Parameter query correctly, Crystal Reports will not be able to
use it.
23.10.1.3.1 To open an Access Parameter query
1.
In Crystal Reports, choose Options from the File menu.
The Options dialog box appears.
2.
Click the Database tab.
2012-03-14555
Understanding Databases