Multiple Dataconnections to report

[babu babu]

Hi,
How can i connect the same report created from the same package to oracle and sqlserver (same table structure ) based on the user selection.
If the user selects oracle report  should connect to oracle sqlserver report should connect to sqlserver

Thanks!
Anand.

[MFGF]

Hi,

Define a single Data Source.  Add two connections to this - one pointing to Oracle, the other to SQL Server.  Add the relevant database signon to each connection.  Whenever this data source is used in a report, the author will be prompted to select which one to use.

MF.

[Arsenal]

If your user base is divided in 2 groups between who will use Oracle and who will use SQL Server, then you can ask your admin to set up 2 user groups and after doing what MFGF says, you can add the appropriate group to each of the database connections so the users will automatically be diverted to the correct database.
Common users between the two will still get prompted for the database to use, as well as any admins

[sir_jeroen]

Don't forget not to use Database specific functions, e.g. to_date(<field>;'<format>') (<= Oracle function)  otherwise your SQL Server users will get an error.