Change the location of a DB in a report of CR 8

How can I change the location of a database in a Report of CR 8.5 at runtime?
macobAsked:
Who is Participating?
 
rovermConnect With a Mentor Commented:
macob:
Is your problem solved ?
Can I help you any further ?

D'Mzzl!
RoverM
0
 
rovermCommented:
Two ways:

First:
You can use a DSN.
Create one in your control panel (or admin tools in w2k) and let CR connect to that.
If your path changes, just alter the DSN.

Second:
Build a connect string dynamicly and let CR connect to that string.
You can read the location of the db from the registry or let the user input it.

I prefer using the DSN.

D'Mzzl!
RoverM
0
 
macobAuthor Commented:
Could you give me an example of how to make both?
I'll upgrade to 100 points
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
macobAuthor Commented:
any help?
0
 
rovermCommented:
Sorry, didn't have much time lately...

I can give you an example for DataReport.
As far as I remember (I don't use CR anymore !) it worked approx. the same.
Is that ok with you ?

D'Mzzl!
RoverM
0
 
modderCommented:
macob,

I believe roverm gave you a solution to your problem. I see that you were looking to delete this question.

If roverm's suggestions didn't solve your problem, can you tell us why? Otherwise I think it would be appropriate to accept roverm's comments.

modder
Community Support Admin
0
 
modderCommented:
Force-Accepted

modder
community Support
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.