Unable to easily switch databases for reports

[DairyAire]

I'm a beginner - so please bear with me.  We have multiple versions of a database that have the same structure.  Our users wish to be able to switch between databases using the same report to be able to do comparisons.  I've been told that each time we want to go to a different database, we have to go into the report, switch it and then save it so the users can use the other database.  This doesn't sound right to me.  Any suggestions??  Thanks!

 

[MalcolmW]

If you are using ODBC as a datasource, then you can set up a system DSN for ODBC, and point the report at that.&nbsp;&nbsp;After that, if you want to change the data source, all you need to do is update the system DSN. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[pwesson]

You may want to construct a front-end for your reports in something like VB, then you can call a specific report and set the data location via code...<br><br>This would be a very &quot;user-friendly&quot; solution for your users. <p>Paul Wesson<br><a href=mailtoaul@wessoft.com>paul@wessoft.com</a><br><a href=

http://www.wessoft.com/>Paul

Wesson, Programmer/Analyst</a><br>

 

[DairyAire]

We're using native drivers and the main program is written in PowerBuilder 6.5.&nbsp;&nbsp;Is there a specific parameter when calling Crystal Reports that I should use to change the data location?

 

[pwesson]

Take a look at the developer.hlp file, it will have information on doing this either by API or the crystl32.ocx...<br><br> <p>Paul Wesson<br><a href=mailtoaul@wessoft.com>paul@wessoft.com</a><br><a href=

http://www.wessoft.com/>Paul

Wesson, Programmer/Analyst</a><br>