How to make a crystal report DSN and Data base Independent

[tumtoo10]

Well I wish to make a report , but iam not sure as to what will be the database name at user site and also what DSN name he will use. But database remains same. How can i make a report which is independent of these Changes at user site

 

[dgillz]

I do now beleive you can make a report within crystal reports that is independant of the DSN name or Database name. I beleive you can do this if you use VB or another application to launch the crystal report. However, one of the programmers on this board would have to tell you how to do it.

What you CAN do within Crystal is the following:

For ODBC/DSN databases:
Database, Set Location, Set Location Button and point to the proper DSN name which points to the data you want to report against.

For Native Database connctions:
Database, Set Location, and key in the physical location on the server where the database file is located.

Let me know if you have any questions.
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office