Switching between two queries in report [message #392559] |
Wed, 18 March 2009 07:19 |
mahantesh
Messages: 28 Registered: March 2008 Location: Mumbai ,India
|
Junior Member |
|
|
Hi,
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
Mahantesh
|
|
|
Re: Switching between two queries in report [message #392723 is a reply to message #392559] |
Thu, 19 March 2009 01:25 |
shajat
Messages: 25 Registered: October 2008 Location: INDIA
|
Junior Member |
|
|
Hi,
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);
Else
return (FALSE);
End If;
Try this.
|
|
|