I want to create matrix reports manually, without taking help of Report Wizard. Say, I want to create a matrix report (with DEPTNO along the rows, JOB along the columns and SUM of SAL in the intersecting cells) and I have the following query in data model:
select deptno, job, sum(sal)
from emp
group by deptno, job
I have created four report groups based on DEPTNO, JOB, SUM(SAL) and the cross product (DEPTNO & JOB).
Can someone help me on how to create repeating frames and fields for this matrix report in the layout editor?
select deptno, job, sum(sal)
from emp
group by deptno, job
I have created four report groups based on DEPTNO, JOB, SUM(SAL) and the cross product (DEPTNO & JOB).
Can someone help me on how to create repeating frames and fields for this matrix report in the layout editor?