Email Us : sunilkumark11@gmail.com
Free Training
 SQL
 PL/ SQL
 Forms
 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