Accessing different database

[ching0418]

Is it possible to create one report but accesses different databases?
I need to generate a report depending on an input. From this input, it will determine what database to access.
If yes, how will i do it?

Thanks!

 

[dgillz]

Within crystal reports, you can select database, set location and point the report to another database. However you cannot make this dynamically change itself in response to a parameter field, at least with a Crystal only solution.

You can use VB and the Crystal RDC to accomplish this, however. I am not much of a VB guy but there are several very good ones on here.
Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Roadkill150]

When there is a will there is usually a way.. It depends how creative you want to be with Crystal. You could actually create a container report, and a then create 2 subreports using different databases, and based on the input parameter suppress one report or the other, then only the report that has what you want is displayed. There are variations you can do as well using the main report with one database and the subreport as the other database.
Cheers,
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com