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