i think you can try control the report outputs from the region source, where you define the report's source using a SQL.
if you put a condition on the source sql for "sum of rows for accrual_amount" you should be able to filter the rows.
select po_number, po_line_number, receipt_number, accrual_amount -- accrual_amount is summarised in the orders_view
where accrual_amount >0
this gives you all po numbers with sum accrual_amount > 0,
is this what you need?
Please update your forum profile with a real handle instead of "user12115874".
I have an requirement in APEX report to filter the rows based on summary columns.
APEX version? Interactive or standard report?
report is like payables reports with columns po_number, invoice, gl_date, bu, vendor_name, vendor number, po_line_number, receipt_number, accrual_amount, po_amount.
po_amount and accrual amount are summary columns and report is breaking at po_number, po_line_number and receipt_number.
Where is summary calculation and breaking implemented: in the query or the report? In either case, explain how it is being done.
I want to filter the rows if sum of rows for accrual_amount is zero. I am new to APEX, please suggest.
See Re: how to get answers from forum for information on how to ask future questions more effectively.