Home » Developer & Programmer » Reports & Discoverer » 2 query
2 query [message #283202] Mon, 26 November 2007 06:21 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
Hi All
i use oracle database 10g and (oracle form and report 6i).
i create report with 2 query
each query have 2 layout .
i want to run one and stop the ather .
how can i do it ?
thax
Rafeek
Re: 2 query [message #283232 is a reply to message #283202] Mon, 26 November 2007 07:17 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So why don't you write two reports, each of them containing one query?

You could create a parameter which would tell which result to display. For example, to display query_1 result enter 1, and to display query_2 result enter 2.

Furthermore, create a Format Trigger on master frames for both queries which would look like this:
-- Q1 MASTER FRAME

RETURN (:par_show_query_result = 1);
-- Q2 MASTER FRAME

RETURN (:par_show_query_result = 2);

That should do it; however, once again - it will NOT stop a query from executing.

You might try to do that by creating a lexical parameter which would be included into the WHERE clause of every query and which would - depending on parameter value - evaluate to "WHERE 1 = 1" if you want to execute it, or "WHERE 1 = 2" if you want to skip this query's result.
Re: 2 query [message #283783 is a reply to message #283232] Wed, 28 November 2007 02:46 Go to previous message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
thax
Previous Topic: How to adjust two pages reports shrink to fit one page in report printing
Next Topic: Report output to mail
Goto Forum:
  


Current Time: Fri Dec 09 11:47:44 CST 2016

Total time taken to generate the page: 0.13508 seconds