...
- SA users unable to see all Tables, Views and Stored procs
This is due to a 8000 object limit imposed by Crystal Reports which can be increased by modifying a registry key as described in https://apps.support.sap.com/sap/support/knowledge/public/en/1215994
Increasing this to 20000 should resolve this issue.- Untick the Views, Tables or Stored Procedures depending on what you want to see in Crystal Options, Database Tab
- Confusion of how single Database works with a single ODBC Connector.
- There might be a separate ODBC connector called Synergetic_Finance this is actually the same as Synergetic (this possibly adds more confusion to the problem)