Notifications
Clear all
Topic starter
For the most part, reports that I have written to work in EMR versions 9.5 and earlier have been able to be shared with others on this board (and elsewhere).
But lately have heard that someone cannot load/use a report I shared.
Can someone comment on the difference(s) with CPS systems? Can they still run the Crystal Reports, just need to do ___ [for instance]. I feel bad when I try to share a report and then the user cannot access.
Thanks in advance.
I have never seen the CPS (only) side of GE.
Posted : November 1, 2013 2:16 am
At a minimum, the CPS user would need to convert the Crystal>Database>Set Datasource Location/ODBC connection to whatever Microsoft SQL Server naming convention and drivers CPS SQL uses, rather than the EMR 9.5 Oracle version.
Tables and/or Views also might also need to be replaced since they might not be a one-to-one match. You might also need to update formulas if table names differ.
It can be done, but generally switching reports back & forth between SQLServer and Oracle takes some Crystal effort and knowledge of the schemas (our data-warehouse is the same way, EMR Oracle vs. MSSQL).
Posted : November 12, 2013 3:33 am
