OraFAQ Forum: Reports & Discoverer » Two queries in one report

Home » Developer & Programmer » Reports & Discoverer » Two queries in one report

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

Two queries in one report [message #152098]

Wed, 21 December 2005 01:51

adroit.ramesh
Messages: 14
Registered: November 2005

Junior Member

I built a report that has two queries, Q1, Q2; they are not relate to each other. In this report i have parameter value YES/NO
What I want to do when I give the parameter values as YES execute Q1. when I give the parameter values as NO execute Q2.

Thanks in advance
Ramesh

Report message to a moderator

Re: Two queries in one report [message #152263 is a reply to message #152098]

Thu, 22 December 2005 00:46

sirishay
Messages: 40
Registered: August 2005
Location: Hyderabad

Member

In the first query give the parameter value as (:P_1='YES')and for the 2nd query give the parameter value as (:P_1='NO').And give the format triggers for the main frames of the 2 queries.
Now when u run the report, when the parameter value is YES then Q1 will execute and if the parameter value is NO then Q2 will execute.I have tried this n it worked fine.

siri.

Report message to a moderator

Re: Two queries in one report [message #152413 is a reply to message #152263]

Fri, 23 December 2005 00:52

adroit.ramesh
Messages: 14
Registered: November 2005

Junior Member

Thanks a lot siri

Report message to a moderator

Previous Topic:	problems in selecting tables based on parameter
Next Topic:	ref cursor query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 02:10:06 CDT 2024