OraFAQ Forum: Forms » call oracle 9i report from oracle report9i using hyperlink

Home » Developer & Programmer » Forms » call oracle 9i report from oracle report9i using hyperlink (oracle 9i , windows xp)

Wed, 30 September 2009 09:57

sam_kota
Messages: 11
Registered: September 2009
Location: Kota

Junior Member

Hello ora experts

i have one problem as bellow:

I have one report on dept table with all fields ie deptno,dname, and loc
and name of rdf report is dept_mas.rdf. This report is working fine with following url.

( http://4fbb3fdbe54c446:8888/reports/rwservlet?userid=SCOTT/TIGER@orcl&server=repserver90&report=c:\oraproj\dept_mas&desty pe=CACHE&desformat=htmlcss)

I am calling one more report(details report/ drill down report) ie emp_sum from above report using hyperlink
based on deptno of dept table matching deptno of emp table.

hyperlink of dept_mas on deptno is set as

( http://4fbb3fdbe54c446:8888/reports/rwservlet?userid=SCOTT/TIGER@orcl&server=repserver90&report=C:\ORAPROJ\emp_sum.rdf&de stype=CACHE&desformat=html&p_no=&f_deptno)

p_no is user defined parameter

bUT AT THE TIME OF CALLING DETAIL REPROT IS GIVES FOLLOWING ERROR:

REP-110: File 'emp_sum.rdfCache=CACHEhtmlcss=html' not found.
REP-0110: Unable to open file 'emp_sum.rdfCache=CACHEhtmlcss=html'.

any mistake in the procedure pls suggest

pls give me one live example of the problem

Thanks
sameer