How to hide records without using temp table in Oracle Reports10G.
I would like to hide records without using temp table in Oracle Reports.
Scenario :
In customized Uninvoiced Receipts Report, I need to hide records which has positive and negative values within same PO.
Example :
PO No. Line Receipt Item Accrual Amount Transaction Type
521 1 431 Item_A 120 Receive
521 1 432 Item_A -120 Return to Vendor
I need to hide above showed both records since accrual amount is 0 for PO# 521. How to do it without using temp table.
If anyone have idea, please share.
Thanks & Regards,
Vijey