Hello All,
I would like to centralize the ODBC connection information for my reports in Crystal. Currently, the ODBC connection must be defined for each report in the CMC of BO. Eventually, we'll have lots of reports and in the even there is a requirement to change the database or the password. I don't want to have to change it in every report.
I've seen an implementation in MS Access which utilizes VBA to pull the connection string from a server. I'm fairly new to Crystal and was wondering if there is similar method or if there is something already built in to BO or Crystal that will centralize it?
I believe the version we are on is BO XIR2 SP2.
Any help will be greatly appreciated. Thanks!
Edited by: Daniel-Jay Pascual on Dec 2, 2009 3:36 PM