Can you have an ODBC data source path to more than one directory for the files you want to use in a crystal report? I am trying to create a crystal report form ACCPAC Pro Series data (VFP5.0) and the data is grouped in seperate folders according to the module: ARDATA for all accts rec data, SODATA for all sales order stuff. If I create two data sources and try using tables from them I get a Crystal message telling me I cant use SQL formulas...
Can I create an ODBC data source from both folders:
Can I create an ODBC data source from both folders: