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

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 '<font color=purple>'
                ||initcap(aa.subtabname)
                ||'</font>'
            END)
          || '</span>') AS target,
          trim(upper(aa.subtabname)) rep_ord ,
          ab.maker_id AS "STARTED_BY"
        FROM
          rep_dept_report_map_details aa,
          ds_rep_report_master ab
        WHERE
          aa.repid IN
          (
            SELECT DISTINCT
              rsd.reportid
            FROM
              rep_role_dept_report_map rsd,
              rep_role_dept_map rd,
              rep_user_master um,
              rep_user_role_map ud,
              rep_role_master rm,
              rep_department_sub_master dsm,
              rep_dept_report_map_details reptd,
              rep_role_dept_sub_map rrdsm,
              ds_rep_report_master drp
            WHERE
              rsd.deptid               =rd.deptid
            AND trim(upper(um.user_id))=trim(upper(:p0_userid))
            AND um.user_id             =ud.user_id
            AND rd.roleid              =ud.roleid
            AND rsd.role_id            =ud.roleid
            AND rm.role_id             =ud.roleid
            AND dsm.dept_subid         =reptd.stabid
            AND rrdsm.dept_subid=dsm.dept_subid
            AND rm.role_id      =rrdsm.roleid
            AND rsd.reportid=reptd.repid
            AND drp.repid   =reptd.repid
            AND drp.rstatus LIKE 'C'
            AND trunc(SYSDATE) = trunc(drp.endtime)
          )
        AND aa.repid=ab.repid
        ORDER BY
          ab.endtime DESC
      )

  );

Output:



Comments

Popular posts from this blog

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

Querying Data From Flat Files in Oracle

Number of Tables by The Number of Rows in Oracle Database

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Highlight Data That Meet Certain Criteria in Oracle APEX Report

Return a Validation Message using JavaScript if the Oracle Application Express Item is Empty

Remove X (Close Mark) from Oracle APEX Modal Dialog

Display User Rating Icons Dynamically in Oracle APEX Report

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Find Where Specific Table or View is Used in Oracle Database