chrysanthalbee
IS-IT--Management
our company is using a third party interface for association management. cognos is the custom report application chosen by the vendor. there are already some reports written in cognos and the interface allows the user to choose a report that will open impromptu and run the report.
we have been told (since we have multiple databases) that the interface will choose the appropriate database as long as we have two dsns set up, eg. database and databasedsn. this seems to work with the catalogs and reports that came with the application. however, my custom reports have been pulling up only data from one database.
my question: is there a way that one dsn is defaulted into the report or catalog?
basically i want one report to be set up to be flexible enough to be used with all the databases.
thanks in advance,
chrysanthalbee
we have been told (since we have multiple databases) that the interface will choose the appropriate database as long as we have two dsns set up, eg. database and databasedsn. this seems to work with the catalogs and reports that came with the application. however, my custom reports have been pulling up only data from one database.
my question: is there a way that one dsn is defaulted into the report or catalog?
basically i want one report to be set up to be flexible enough to be used with all the databases.
thanks in advance,
chrysanthalbee