Crystal Reports allows you to link to multiple files as well as multiple databases.
This linking function is called Visual Linking Expert. This function can be used to link to database files, for e.g. Bank Information and Batch Control.
The common field in these two files is Bank Code, and the Visual Linking Expert will use the Smart Linking function to automatically create the links between the files.
Please be aware that if you are linking to a Sage 300cloud General Ledger account number, you must use the unformatted (UF) account code from the Cashbook database.
The field names differ between the Sage 300cloud tables and the Cashbook tables, so when you are linking between your Cashbook and Sage 300cloud tables you should highlight the link, click on the Options button in your Visual Linking Expert and check the box Allow partial text matches.