Logout

nobody

Report Lab

Rows Generic Column Report     DNAME ENAME JOB ACCOUNTING CLARK MANAGER   KING PRESIDENT   MILLER CLERK RESEARCH ADAMS CLERK   FORD ANALYST   JONES MANAGER   SCOTT MANAGER SALES ALLEN SALESMAN   BLAKE MANAGER   JAMES CLERK   MARTIN SALESMAN   WARD MANAGER OPERATIONS KOVACS ANALYST   SMITH CLERK   TURNER SALESMAN 1 - 15 Row Template with rowspan I     DNAME ENAME JOB ACCOUNTING CLARK MANAGER KING PRESIDENT MILLER CLERK RESEARCH ADAMS CLERK FORD ANALYST JONES MANAGER SCOTT MANAGER SALES ALLEN SALESMAN BLAKE MANAGER JAMES CLERK MARTIN SALESMAN WARD MANAGER OPERATIONS KOVACS ANALYST SMITH CLERK TURNER SALESMAN 1 - 15 Report SQL I     Rowspan SQL select d.dname , e.ename , e.job , count(*) over (partition by d.deptno order by d.deptno) rowspan , row_number() over (partition by d.deptno order by d.deptno , e.ename) rn from emp e , dept d where e.deptno = d.deptno order by d.deptno , e.ename Named Column Template I     Row Template 1 <tr> <td class="t3data" #ALIGNMENT#>#1#</td> <td class="t3data" #ALIGNMENT#>#2#</td> <td class="t3data" #ALIGNMENT#>#3#</td> </tr> Row Template 1 PL/SQL Expression #ROWSPAN# = 1 Row Template 2 <tr> <td rowspan="#ROWSPAN#" class="t3data" #ALIGNMENT# style="vertical-align: top;">#1#</td> <td class="t3data" #ALIGNMENT#>#2#</td> <td class="t3data" #ALIGNMENT#>#3#</td> </tr> Row Template 2 PL/SQL Expression #ROWSPAN# > 1 and #RN# = 1 Row Template 3 <tr> <td class="t3data" #ALIGNMENT#>#2#</td> <td class="t3data" #ALIGNMENT#>#3#</td> </tr> Row Template 3 PL/SQL Expression #ROWSPAN# > 1 and #RN# != 1 Row Template with rowspan II     DNAME ENAME JOB ACCOUNTING CLARK MANAGER KING PRESIDENT MILLER CLERK RESEARCH ADAMS CLERK FORD ANALYST JONES MANAGER SCOTT MANAGER SALES ALLEN SALESMAN BLAKE MANAGER JAMES CLERK MARTIN SALESMAN WARD MANAGER OPERATIONS KOVACS ANALYST SMITH CLERK TURNER SALESMAN 1 - 15 Report SQL II     Rowspan SQL with dept_emp as ( select d.deptno , d.dname , e.ename , e.job , count(*) over ( partition by d.deptno) grp_rows , row_number() over ( partition by d.deptno order by d.deptno , e.ename) grp_rn , :p1_rows - mod( row_number() over ( order by d.deptno , e.ename) - 1 , :p1_rows) pg_rows_left from dept d , emp e where d.deptno = e.deptno) select de.dname , de.ename , de.job , de.grp_rows , de.grp_rn , de.pg_rows_left , least(de.grp_rows, de.pg_rows_left, de.grp_rows - de.grp_rn + 1) rowspan from dept_emp de order by de.deptno , de.ename Named Column Template II     Row Template 1 <tr> <td rowspan="#ROWSPAN#" class="t3data" #ALIGNMENT# style="vertical-align: top;">#1#</td> <td class="t3data" #ALIGNMENT#>#2#</td> <td class="t3data" #ALIGNMENT#>#3#</td> </tr> Row Template 1 PL/SQL Expression #GRP_RN# = 1 or #PG_ROWS_LEFT# = :P1_ROWS Row Template 2 <tr> <td class="t3data" #ALIGNMENT#>#2#</td> <td class="t3data" #ALIGNMENT#>#3#</td> </tr>