sequence in which queries run in the data model

[csphard]

I have a report which has 2 queries in the data model.
Do both queries run at the same time or one after the other?

Also there is a frame on the paper layout. The frame has some pl/sql to turn
the frame off when it returns false.

I think the sql has already run prior to to creating the paper layout. Is that right or does returning false stop the query from running in the data model.

Howard

 

[sem]

All queries run in turn and regardless on whether the results are to be printed or not.


Regards, Dima

http://seminihin.narod.ru

 

[csphard]

I just ran a tace in oracle reports using program tracing. I ran this but did not see that the second sql ran.
Why?

 

[csphard]

My purpose for asking this question is to speed up the report. After running a trace. I see there are 6 program units that return values base on the input prior to getting the counts and generating the page layout. My question is could I speed this up by removing the program units and replacing it in the sql with a decode?

Howard