Running Same Published Report Against Different Data ( in Oracle )

[MikeCoch]

Here is the Setup....

I have Oracle running on an NT Server.

One Instance: INSTANCE1

Two Schemas : PROD1 and PROD2

I have several reports I have developed and published and the underlying SQL code does not have any schema references.

What I want to do...

When I go to run the report using Crystal Info I would like to Select the Schema I will run it against.

Is there a way to do this in Crystal Info? If there is more than one way to do it which one is the best?

So far, the best thing I have come up with in Crystal info involves two references to the report. Each reference logs into Oracle using a different User ID. Each User ID has a specific Schema default.

I would much rather have one report that asks the user to choose which schema ( database ) it would like to run against.


Thanks in Advance

Mike Cocchiola