How to Add Grand Total Column using Interactive Report In Oracle APEX | Interactive Report

• Step - 1 : 

        Create blank page.

 

 

 

• Step - 2 :

         Create EMP report region.

 

 

SQL query:

SELECT

 '<span style="color:black;">'||to_char(EMPNO)||'</span>' as empno,

   ename,

    job,

    mgr,

    hiredate,

   '<span style="color:black;">'||SAL||'</span>' as  sal,

    deptno

    FROM emp

  UNION ALL

  SELECT

   '<span style="color:red;">' ||to_char('Total') ||'</span>' as empno,

       Null as ename,

       Null as job,

       Null as mgr,

      Null as hiredate,

    '<span style="color:red;">' ||SUM(SAL)||'</span>' as   sal,

      Null as deptno

      FROM emp;

• Step - 3 : 

        Save and run the page.

Output: