Updating data sources of individual Crystal Reports

To update the data source settings of an individual Crystal Report:

1. Start Crystal Reports Developer.
2. Open the report to configure.
3. Select File > Set Datasource Location from the main menu.
   The Set Datasource Location window is displayed.
    
4. Check that the Use DSN Default Properties property is set to True under the Properties node of the:
   • database, either SynergyOne or SynergyOneFinance
   • under the Subreports node.
    
   
   
5. Check that under the top-level report node, there is only:
   • one database, either SynergyOne or SynergyOneFinance
   • one instance of this database appearing.
   
   
   
6. Check that under the Subreports node there is only one instance of a database displayed; it is possible to have both a SynergyOne and SynergyOneFinance data source.
   
7. Check that any User ID fields are SQL users.
   
8. Check that there is not a Trusted Connection property listed anywhere.
   
9. Save and close the window.

Attachments (12)

worddav152e7085881f9d3df7bfa1d9d29dfc9d.png
30.1 KB

worddav156d9b03236325db1caba3fcbed968e3.png
15.4 KB

worddava26c57e988eb58d0f1ccb4078076088a.png
30.1 KB

worddav5310e09aac53e9c2368fe6bf7b02148e.png
29 KB

worddavf2d94273507a6b23ef0f0a6f044e241d.png
3.81 KB

worddave75bcce2ecb49de4959ab0403b1a11c8.png
52.7 KB

69e1f21d3f687.Set_Datasource_Location.gif
56.6 KB

69e1f21d3f689.Set_Datasource_Location_(Use_DSN_Defaults_Properties_True).gif
30.7 KB

69e1f21d3f68a.Set_Datasource_Location_(report_node_SynergyOne).gif
4.44 KB

69e1f21d3f68b.Set_Datasource_Location_(subreports_instance).gif
16.1 KB

69e1f21d3f68c.Set_Datasource_Location_(User_ID_fields).gif
31.9 KB

69e1f21d3f68d.Set_Datasource_Location_(not_Trusted_Connection).gif
33 KB