Crystal Report 9 (Show SQL - Showing Schema)

[Kalpan]

Hi,

We have created a report using the Pull Model with Oracle
9i as Backend. When we use the Report Wizard to create a
Report with selected Tables, It creates an SQL with a
Schema name embedded in it. In previous versions of
crystal we were able to edit the query. Please advice what
can we do if we want to change the query. Also need to
know how to Change the schema at run time in Crystal
Report 9.

Thanks,
Kalpan