Email Us :
Free Training > SQL PL / SQL Forms Reports Oracle Applications
< Previous Next >

Reports - Matrix report

Matrix is a rectangle array of numbers, arranged in rows and columns.
The below matrix is a two row three column matrix ( 2 x 3  )  read as two by three


Lets us develop a matrix report.

Open report builder tool Use the report wizard Next Create both Web and Paper Layout Next select Matrix radio button Next SQL Query   Data source definition -  select deptno, job, sum(sal) total_sal  from emp group by deptno, job;
Next provide the username, password and database details Connect  
Move deptno to Matrix row fields

Next Move job to Matrix column fields


Next Move total_sal to Matrix cell fields

Next Next Next   select predefined template - Blue Next Finish

This is how, your report looks like

Save the report as Matrix.rdf


< Previous Next >