Kashif Masood Hashmi Blog

CREATING DRILL DOWN REPORTS

THE TECHNIQUE OF CALLING ONE REPORT FROM ANOTHER REPORT IS CALLED AS DRILL DOWN REPORTS.

STEPS TO BUILD A SIMPLE DEPARTMENT - EMPLOYEE DRILL DOWN REPORT.

1) CREATE A SIMPLE EMPLOYEE REPORT.

·                     OPEN REPORTS BUILDER AND CONNECT TO A SCHEMA.

·                     CLICK ON ADD MODULE IN NAVIGATION BAR AND SELECT WIZARD OPTION.

·                     SELECT EMP TABLE AND GIVE THE QUERY LIKE

SELECT * FROM SCOTT.EMP WHERE DEPTNO = :DEPTNO;

·                     CREATE A SIMPLE TABULAR REPORT.

·                     SAVE THE FILE AS EMP.RDF(USE SHIFT+CRTL+K BEFORE SAVING).

2) CREATE A SIMPLE DEPARTMENT REPORT.

·                     OPEN REPORTS BUILDER AND CONNECT TO A SCHEMA.

·                     CLICK ON ADD MODULE IN NAVIGATION BAR AND SELECT WIZARD OPTION.

·                     SELECT DEPT TABLE AND CREATE A SIMPLE TABULAR REPORT WITH FOLLOWING

SELECT * FROM SCOTT.DEPT;

·                     SELECT DEPARTMENT NUMBER COLUMN PRESS F4 TO OPEN PROPERTY INSPECTOR

·                     NAVIGATE TO HYPERLINK PROPERTY UNDER WEB SETTINGS AND PROVIDE THE LINK IN THE BELOW FORMAT

http://:8889/reports/rwservlet?userid=scott/tiger@db+report=emp.rdf+destype=cache+desformat=html+p_deptno=&deptno

·                     SAVE THE FILE AS DEPT.RDF (USE SHIFT+CRTL+K BEFORE SAVING).

3) START REPORT SEVER.

4) CALL THE DEPT.RDF REPORT FROM URL(IF REPORT IS NOT CALLED CHECK THE PATH IS IN REPORTS PATH IN REGISTRY).