...
- Open up the Customised report in Crystal reports
- Select Database, Set Datasource location
- Select the Reports Data Source location (currently SynergyOne or SynergyOneFinance)
- In My connections you should have a "Synergetic" Data Source (Please note in Single Database there should only be a need for one Database ODBC Connector)
- Click Update
- Enter the Password for SA then Click Finish
- Repeat the process for each Subreport
- Once each Datasource has been corrected, ensure "Use DSN Default Properties" is set to true (Including Subreports)
Testing
- Run the report as usual
- Possibly make some test changes to the new Single Database instance to confirm that data is been pulled from the correct source.
...