Hi,

We are migrating from Oracle 6i to Crystal Reports. Oracle reports
were built using Oracle 6i Data Wizard and Query Builder. How can we
see the end query (final query including joins for links) that is
being executed by Oracle Reports? Oracle Reports 'trace' shows only
parts of queries being executed, but not the entire query.

Thanks

On Jul 16, 3:05*am, bang123 <vasuad... (AT) gmail (DOT) com> wrote:
Run SQL Trace on the database session and pull the SQL from there.

Though a programmer should be able to figure out what the query is
just by looking at the report program and the where clause information
generated by the reports trace.

HTH -- Mark D Powell --

On Jul 16, 3:05*am, bang123 <vasuad... (AT) gmail (DOT) com> wrote:
Run SQL Trace on the database session and pull the SQL from there.

Though a programmer should be able to figure out what the query is
just by looking at the report program and the where clause information
generated by the reports trace.

HTH -- Mark D Powell --

On Jul 16, 3:05*am, bang123 <vasuad... (AT) gmail (DOT) com> wrote:
Run SQL Trace on the database session and pull the SQL from there.

Though a programmer should be able to figure out what the query is
just by looking at the report program and the where clause information
generated by the reports trace.

HTH -- Mark D Powell --

On Jul 16, 3:05*am, bang123 <vasuad... (AT) gmail (DOT) com> wrote:
Run SQL Trace on the database session and pull the SQL from there.

Though a programmer should be able to figure out what the query is
just by looking at the report program and the where clause information
generated by the reports trace.

HTH -- Mark D Powell --

bang123 (vasuadiga (AT) gmail (DOT) com) wrote:
: Hi,

: We are migrating from Oracle 6i to Crystal Reports. Oracle reports
: were built using Oracle 6i Data Wizard and Query Builder. How can we
: see the end query (final query including joins for links) that is
: being executed by Oracle Reports? Oracle Reports 'trace' shows only
: parts of queries being executed, but not the entire query.

: Thanks

It might not be running an "end query". Reports can loop over a query
getting one row at a time, and in between getting each row of that query
it might run another query based on all the conditions set up in the
report. The second query may or may not have any obvious connection to
the first query.

In report builder you should be able to see all the details in one of the
windows (I cant check the names right now).

bang123 (vasuadiga (AT) gmail (DOT) com) wrote:
: Hi,

: We are migrating from Oracle 6i to Crystal Reports. Oracle reports
: were built using Oracle 6i Data Wizard and Query Builder. How can we
: see the end query (final query including joins for links) that is
: being executed by Oracle Reports? Oracle Reports 'trace' shows only
: parts of queries being executed, but not the entire query.

: Thanks

It might not be running an "end query". Reports can loop over a query
getting one row at a time, and in between getting each row of that query
it might run another query based on all the conditions set up in the
report. The second query may or may not have any obvious connection to
the first query.

In report builder you should be able to see all the details in one of the
windows (I cant check the names right now).

bang123 (vasuadiga (AT) gmail (DOT) com) wrote:
: Hi,

: We are migrating from Oracle 6i to Crystal Reports. Oracle reports
: were built using Oracle 6i Data Wizard and Query Builder. How can we
: see the end query (final query including joins for links) that is
: being executed by Oracle Reports? Oracle Reports 'trace' shows only
: parts of queries being executed, but not the entire query.

: Thanks

It might not be running an "end query". Reports can loop over a query
getting one row at a time, and in between getting each row of that query
it might run another query based on all the conditions set up in the
report. The second query may or may not have any obvious connection to
the first query.

In report builder you should be able to see all the details in one of the
windows (I cant check the names right now).

bang123 (vasuadiga (AT) gmail (DOT) com) wrote:
: Hi,

: We are migrating from Oracle 6i to Crystal Reports. Oracle reports
: were built using Oracle 6i Data Wizard and Query Builder. How can we
: see the end query (final query including joins for links) that is
: being executed by Oracle Reports? Oracle Reports 'trace' shows only
: parts of queries being executed, but not the entire query.

: Thanks

It might not be running an "end query". Reports can loop over a query
getting one row at a time, and in between getting each row of that query
it might run another query based on all the conditions set up in the
report. The second query may or may not have any obvious connection to
the first query.

In report builder you should be able to see all the details in one of the
windows (I cant check the names right now).

On Jul 21, 3:11*pm, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
I would think the case of where Reports Builder runs the second query
using data retuned by the first query and report conditions would be
where the raw sql trace file on the database would be helpful since it
will show each query ran.

It really helps to understand the tool set in cases like the bang123
posted.

-- Mark D Powell --