Notifications
Clear all
Topic starter
We have test, train, and dev environments in addition to our production environment. Each has its own database. I'm discovering that no custom chart reports will run in this environment because they're looking for the production database. Stock chart reports run fine, as do PM reports in the Reports module.
So what magic do I need to perform to make the application point the custom reports to the current database the way they do with the stock reports?
Posted : September 8, 2015 8:05 am
CPS isn't something I am familiar with but I always had to change the database source to MLO_ which allowed the report to work in my Test and Live environments.
I wish I could give you the why or the how or the "what is that" but I just kind of stumbled upon that after I updated our Lab req and couldn't test it right (I looked at some older custom reports that worked). I'm not even sure if that is unique to us (our organization) or just CEMR.
Hopefully it will work for you otherwise sorry for any false hope seeing a response may have brung!
Mike
Posted : September 8, 2015 9:17 am
Topic starter
I already tried creating an ODBC connection called MLO_ and saving it with that source, but it doesn't appear to help. It still looks for my production database (which is what the MLO_ connection is based on). There must be some property of the ODBC connection that I'm getting wrong, but I can't for the life of me guess what it could be.
Or, there's some way to change the database source in a Crystal Report to a "mystery source" and I'm not aware of it.
Posted : September 9, 2015 4:34 am
I wish I could remember exactly what I had to do to connect and make it work right but it was a while ago... I tried to make the same edit and couldn't get it to work again, if I get some time I will try to figure it out again and let you know. Hopefully in the meantime someone else will post though.
Thanks
Mike
Posted : September 9, 2015 5:10 am
Have you tried updating your datasource for the report to point to the new database?
In crystal reports go to Database > Set Datasource Location...
In the Set Datasource Location dialog that comes up there are two panes. The top pane is the Current Data Source: and the bottom is the Replace with:
Select the current datasource in the top pane and the datasource to your test database (or create a new one) in the bottom pane and click on the Update button. That will run the report against the database specified in the new connection. If the report contains other connections, for instance for subreports, you may have to scroll the top pane to see them and update those as well.
Posted : September 9, 2015 10:09 am
Topic starter
Two problems with that idea:
1) I would need to maintain test, train, and dev versions of every custom report we have. That's well over 100 additional (redundant) reports to maintain.
2) Our train environment, while it has its own database, uses the same pool of Citrix servers as our production environment. So if I replace the reports on those servers with ones that point to the train database, they'll be rendered useless for production.
Posted : September 10, 2015 2:42 am
On the EMR side, you would just need to login with the local/FAT-client into Network Training in order to reset the ODBC. Crystal uses whatever was the last connection as its basis. That way you wouldn't need to change the report structure.
When you want to go back to the full DB, just log back into that client. Assuming CPS/ODBC has somewhere else to connect to different DBs. There are some 'howevers', though if the report shows MASTERDIAGNOSIS table or SU_TUT as the db connector.
Posted : September 14, 2015 8:40 am
