Re: Oracle reports end query

On Jul 21, 3:11 pm, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> bang123 (vasuad..._at_gmail.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).

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 --