How do you Hyperlink in Oracle Reports 9i JSP

[gaas]

I am using Oracle Reports 9i to create JSP reports. I am trying to hyperlink from one report to another, but I do not know how to send a variable to my hyerlink string.

Here is a short overview using the EMP and DEPT tables.

Report 1 displays employee info and Report 2 display department details.

Report 1:
EMPNO ENAME SAL DEPTNO
10 KING 5000 10
Report 2:
DEPTNO DNAME LOC
10 SALES BOSTON

I would like a hyperlink on the DEPTNO field that will call Report 2 and display the info regarding that specific department.

This is what I am currently using but it does not seem to work.

<td <rw:headers id=&quot;HFEMP&quot; src=&quot;HBEMP&quot;/> class=&quot;OraCellNumber&quot;><a href=&quot;

http://oracle.oracle.com:7779/repdemo/OracleReports/DeptDetail.jsp?cmdkey=orarep1&p_deptno=<RW:FIELD

id=&quot;PF_DEPTNO&quot; src=&quot;DEPTNO&quot;/>&quot;><rw:field id=&quot;F_DEPTNO&quot; src=&quot;DEPTNO&quot; nullValue=&quot; &quot;> F_DEPTNO </rw:field></a></td>

Any and all help will be appreciated.

Gaas