Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running same reports on different databases 1

Status
Not open for further replies.

yochai71

Programmer
Oct 1, 2003
8
IL
Hi Forum-friends,

Every month i copy the data to a different DB. Meaning, for every month i have the same structure of DB but with different data.

I would like to know if there is a possibility to run an existing report on a specific database that i have chosen before running the report. Of course without changing the CONNECTION in the DESIGNER.

(The solution of copying the universe with different CONNECTIONS is not applicable because i work with linked universes and each copy requires a copy of 6 universes!)

Thanks in advance,

Yochai
 
It is possible to create multiple accounts that have different connection-settings for universes.
So account X will have a connection to database A, while account Y will have a connection to database B.

I use this to enable users to work on test-databases, so they can use existing documents on both production AND test-databases.

Supervisor will allow you to set connection at the account-level for a given universe.

This will only work for database-structures that are EXACTLY the same, of course.....

T. Blom
Information analyst
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top