Home » Developer & Programmer » Reports & Discoverer » Switching between two queries in report (Report 6i,database version 8i)
Switching between two queries in report [message #392559] Wed, 18 March 2009 07:19 Go to next message
Messages: 28
Registered: March 2008
Location: Mumbai ,India
Junior Member
In my report there are two queries each have one main frame and one repeating frame.Depending on the parameter(p_bucket_salb_from and p_bucket_slab_to) from the concurrent program.
When i dont give these parameters then data from first query get displayed but when i dont give these parameters then blank report get genrated.
To get this swithing i had write format trigger on main as well as repeating frame but i am not getting required result.
Can anybody tell me where i am going wrong.
-For reference i had attach rdf file
Thanks and Regards
Re: Switching between two queries in report [message #392723 is a reply to message #392559] Thu, 19 March 2009 01:25 Go to previous message
Messages: 25
Registered: October 2008
Location: INDIA
Junior Member

You have to write the following code in FORMAT TRIGGER of SECOND QUERY.

If (nvl(:amount1,0)=0 and nvl(:CF_Unapplied_receipt_1,0)=0 and nvl(:CF_Unapplied_credit_note_1,0)=0 ) then
return (TRUE);
return (FALSE);
End If;

Try this.
Previous Topic: Query get duplicate values in Oracle discoverer 4i
Next Topic: Layout problem in pdf
Goto Forum:

Current Time: Mon Jul 24 19:51:07 CDT 2017

Total time taken to generate the page: 0.11946 seconds