Posts

Showing posts from September, 2015

APEX Reports with dynamic help text in Oracle APEX 4.2 using CSS

Image
Objective : To show dynamic help text in APEX reports (Interactive/classical) in Oracle APEX 4.2 using CSS. Solution: Step 1:  Create Interactive report Step 2:  Use below query in IR Region source. SELECT   * FROM   (     SELECT       ROWNUM level_value ,       upper(target) target,       started_by     FROM       (         SELECT           ('<span style="cursor:help" title="'           || upper(reportname)           || '">'           || (             CASE               WHEN aa.sub_pageid !=:app_page_id               THEN '<a href="'                 ||'f?p=&APP_ID.:'                 ||aa.sub_pageid                 ||':'                 || :app_session                 ||':::'                 ||aa.sub_pageid                 ||':">'                 ||initcap(aa.subtabname)                 ||' </a>'               ELSE '<