The following article has been transferred to https://help.synergetic.net.au/s/article/Changing-reports-Database-source-to-new-Single-Database-Source
| Table of Contents |
|---|
Purpose
To provide step by step instruction on how to manually assign a new Database source to an existing custom report report.
- the report may appear to be referencing an incorrect Data Source, this is not relevant as all crystal reports will retain a reference to the database the report was originally developed on - when run through Synergetic the report will use the local ODBC connections
- it is only when editing the actual report (in "Crystal Reports") that the Datasource location will need to be updated
Responsibilities
- Reports Developers
- School System Administrators
...
- 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)
If not, select Create New Connection, ODBC (RDO), and select the Synergetic Data Source Name (DSN) - 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)
...