Home » Developer & Programmer » Reports & Discoverer » Two queries in one report
icon7.gif  Two queries in one report [message #152098] Wed, 21 December 2005 01:51 Go to next message
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
Re: Two queries in one report [message #152263 is a reply to message #152098] Thu, 22 December 2005 00:46 Go to previous messageGo to next message
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.
Re: Two queries in one report [message #152413 is a reply to message #152263] Fri, 23 December 2005 00:52 Go to previous message
adroit.ramesh
Messages: 14
Registered: November 2005
Junior Member
Thanks a lot siri
Previous Topic: problems in selecting tables based on parameter
Next Topic: ref cursor query
Goto Forum:
  


Current Time: Tue Nov 26 10:23:40 CST 2024