Oracle Reports 10g : 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.

(Example is using default scott schema)

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 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.
• 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).