[61.]Crystal Reports on Db other than live

Yahoo Archive
1
In crystal create a new ODBC connection. If you set up your DSN
correctly crystal will see it and just follow the prompts from there.



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Friday, May 29, 2009 12:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage][61.]Crystal Reports on Db other than live





Do you mean new "DSN" in ODBC Admin? If so, I can do that, but how do
you
change connections in a report?

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf
Of Rob Bucek
Sent: Friday, May 29, 2009 9:04 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage][61.]Crystal Reports on Db other than live

You need to create a new ODBC connection on your computer (with the
crystal installation) and then subsequently add it to your 'favorites'
in crystal (for convenience) after creating the new connection. Email
me offline if you need help creating a new DNS on your PC.

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norm Watkins
Sent: Friday, May 29, 2009 10:52 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage][61.]Crystal Reports on Db other than live

Is it possible to run a crystal report on a database other than the
live? I
keep monthly backups that can be restored to a "play" db to look at old
data, and would like to run some CR reports on the old Db.

any ideas?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links





[Non-text portions of this message have been removed]
2
Is it possible to run a crystal report on a database other than the live? I
keep monthly backups that can be restored to a "play" db to look at old
data, and would like to run some CR reports on the old Db.

any ideas?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307
3
Norm,

Yes, it is possible and should also be practice for development...

We use a test database all the time for development and run the report against test, then later against live.

HTH,
Karen S
----- Original Message -----
From: Norm Watkins
To: Vantage@Yahoogroups. Com
Sent: Friday, May 29, 2009 10:51 AM
Subject: [Vantage][61.]Crystal Reports on Db other than live





Is it possible to run a crystal report on a database other than the live? I
keep monthly backups that can be restored to a "play" db to look at old
data, and would like to run some CR reports on the old Db.

any ideas?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307





[Non-text portions of this message have been removed]
4
You need to create a new ODBC connection on your computer (with the
crystal installation) and then subsequently add it to your 'favorites'
in crystal (for convenience) after creating the new connection. Email
me offline if you need help creating a new DNS on your PC.



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Friday, May 29, 2009 10:52 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage][61.]Crystal Reports on Db other than live





Is it possible to run a crystal report on a database other than the
live? I
keep monthly backups that can be restored to a "play" db to look at old
data, and would like to run some CR reports on the old Db.

any ideas?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307





[Non-text portions of this message have been removed]
5
Do you mean new "DSN" in ODBC Admin? If so, I can do that, but how do you
change connections in a report?

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Rob Bucek
Sent: Friday, May 29, 2009 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage][61.]Crystal Reports on Db other than live


You need to create a new ODBC connection on your computer (with the
crystal installation) and then subsequently add it to your 'favorites'
in crystal (for convenience) after creating the new connection. Email
me offline if you need help creating a new DNS on your PC.



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Friday, May 29, 2009 10:52 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage][61.]Crystal Reports on Db other than live





Is it possible to run a crystal report on a database other than the
live? I
keep monthly backups that can be restored to a "play" db to look at old
data, and would like to run some CR reports on the old Db.

any ideas?

thanks,

Norm Watkins
Engineering Mgr.
SCHOTT ELECPAC, LLC
847-639-2307





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links