Oracle Reports (MOSC)

MOSC Banner

Placeholder problem

edited Nov 7, 2011 2:24AM in Oracle Reports (MOSC) 16 commentsAnswered
Hi all,

I have a report that is showing Purchase Order header and line records. 

I am trying to change the legal disclaimer at the bottom of the PO based on the Purchase Order Type that I am retrieving from the database in the headers section of the report.

To do this I setup a Formula column called :CF_PO_TYPE in the headers group that populates a Placeholder column called :CP_LEGAL using the following logic ;

If poh_po_type = 'INV'
then :CP_LEGAL := 'INV'
end if;
If poh_po_type = 'ARCH'
then :CP_LEGAL := 'ARCH'
end if;
If poh_po_type = 'US'

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