[thelist] Crystal Reports Question
Anthony Baratta
Anthony at Baratta.com
Tue Sep 7 18:34:26 CDT 2004
Scott Dexter wrote:
>
> I'm dorking around with a Crystal Report (w/VB6, fun!) that needs to
> dynamically pick up the db settings when it is opened (run time). For
> some reason I can not figure out (CR 9), the db settings done at
> design time are being saved with the report, which is bad, since the
> db is a dev db at design time, and needs to be a different db at run
> time. I've tried changing the driver used (from RDO to ADO), changing
> the DSN on the fly, using a connection string (not specifying
> anything but the DSN) as per one of Crystal's KB articles, nothing
> seems to work. Anyone have ideas?
Scott...
Here's what I did when I was dorking around with CR Enterprise:
I setup an ODBC Connectoid with the same name on all PCs or Servers that
were going to run my report(s). Then Pointed that Connectoid to the DB I
wanted to hit.
E.g. the Development PC was pointed to the Dev DB. The local Test Server
was pointed to the Test DB and the Production Server was pointed to the
Production DB.
By using the ODBC connectoid I was able to move the report file between
machines and not freak it out.
Hope that helps.
--
Anthony Baratta
This is clearly another case of too many
mad scientists, and not enough hunchbacks.
More information about the thelist
mailing list