To use a DSN in a Crystal report, complete the following:

1. In Crystal Reports, open the report.
2. From the Database menu, select Add Database.
3. In the Data Explorer, double-click the ODBC folder.
4. Double-click the folder with the name the DSN you created to access your Sage 300 CRE data. For additional information about how to set up a DSN, select the link below.
5. Select a table from the list.
6. In the Link Table Wizard, you can link the record into the existing structure. Linked tables and fields are available in the Database Fields section of the Field Explorer.

How do I set up an ODBC User DSN for Accounting and Management data?
How do I set up an ODBC TS Billing Field Names DSN to modify or create Billing invoice formats?
How do I create a report in Crystal Reports that is portable to any Sage CRE application or data folder?
How do I set up an ODBC Pervasive DSN for Service Management data?
How do I set up an ODBC Pervasive DSN for Purchasing and Inventory data?