12 Highlight a parameter from this list box.

13 Assign a value by typing into the Parameter Value text box and click the Update button.

" The value displayed in the Name list box will be updated.

# Repeat Steps 12 and 13 for each parameter in your Access parameter query.

$ Click OK when finished. You can change parameter values at any time by choosing the STORED PROCEDURE PARAMETERS command on the Database menu.

% Create your report using the fields in the parameter query. Only the records that satisfy the parameter values you specified in the Stored Procedure Input Parameters dialog box are used in your report.

NOTE: You can not use Access action queries or update queries in Seagate Crystal Reports. You can use Access select queries and cross-tab queries.

How to set up an ODBC data source

To set up an ODBC data source, you must have an ODBC driver installed for the type of data you want to use. Many DBMS applications automatically install and set up ODBC drivers. If you are not sure whether ODBC drivers have been installed for your data, refer to the documentation that came with your DBMS application.

From the Program Manager, double-click the ODBC Administrator icon in the appropriate program group. The ODBC Data Source Administrator dialog box appears.

562	Seagate Crystal Reports User’s Guide

2 Click the Add button to add a new ODBC data source.

The Add Data Source dialog box appears.

3 Choose the ODBC driver appropriate for your data type from this list.

If a driver does not appear for your data type, an ODBC driver has not been correctly installed. Refer to the documentation for your DBMS application.

"When you click OK. An ODBC Data Source Setup dialog box appears that is specific to the ODBC driver you selected.

NOTE: If an error message appears instead of the Setup dialog box, you do not have the correct ODBC drivers installed on your system for the type of data you selected.

Working With Databases

563

5 Type the name for your new ODBC data source here.

This is the name that you select when you log on to the data source from Seagate Crystal Reports.

NOTE: The dialog box that appears may look different than the one shown here, depending on the type of data you are using. This dialog box is specific to the Access 7.0 ODBC driver. For complete information on using the dialog box that appears for your data, click the Help button.

$Click OK in the ODBC Data Source Setup dialog box when you are finished setting up your data source. The new ODBC data source will appear in the Data Sources dialog box.

7 Click Close when finished.

Your new data source will now appear in this list.

564	Seagate Crystal Reports User’s Guide

How to check settings for an ODBC data source

From the appropriate program group, or folder in Windows 95, run the ODBC Administrator application. The Data Sources dialog box appears.

2 Highlight the appropriate data source from this list.

3 Click

Configure.

The ODBC Data Source Setup dialog box appears.

Working With Databases

565