Print

Items Visible on All Pages

Posted in Application Header.

To make an item appear in on All pages (and become part of the template of the application, rather than a page item), it must be added to page 0.

Any components that are put on page 0 will be rendered on every page.

To add a page 0 to you arppliction, you will have to create a new page with an id of 0.

Print

Conditional formatting based on Column value

Posted in Report Layout.

The display of column data can be conditional based on the value of the column.

In this example, the column text displays green if the value is "SUCCEEDED", and is red text otherwise.

select

CASE when status = 'SUCCEEDED'<br />THEN '<span style="color:green">' || status || '</span>'
ELSE '<span style="color:red">' || status || '</span>'<br /> END STATUS</p> <p class="Moobi_Code">from.....

About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2