OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » 2 query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 query [message #283202]

Mon, 26 November 2007 06:21

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

Report message to a moderator

Re: 2 query [message #283232 is a reply to message #283202]

Mon, 26 November 2007 07:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: 2 query [message #283783 is a reply to message #283232]

Wed, 28 November 2007 02:46

Rafeek
Messages: 159
Registered: April 2007
Location: egypt

Senior Member

thax

Report message to a moderator

Previous Topic:	How to adjust two pages reports shrink to fit one page in report printing
Next Topic:	Report output to mail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:41:04 CST 2024