Oracle Reports (MOSC)

MOSC Banner

How to hide records without using temp table in Oracle Reports10G.

edited Apr 10, 2012 5:46PM in Oracle Reports (MOSC) 2 comments
Hi All,

  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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center