Home > IT Answers > Oracle > Problems calling report using WEB.SHOW_DOCUMENT
Crix
5 pts.
 Problems calling report using WEB.SHOW_DOCUMENT
Oracle Application Server, Oracle developers, Oracle Forms, Oracle Forms 10g, Oracle Reports
I am using Oracle Report and Forms 10G and trying to call a report from Forms using the following code:
DECLARE
rep_url VARCHAR2(2000);
BEGIN
rep_url:='/reports/rwservlet?'
||'&report=C:Oracle DbDEPARTMENT_EMPLOYEES.jsp'
||'&desformat=htmlcss&destype=cache'
||'&userid=name/password@orcl'
||'&PARAFORM=yes';
WEB.SHOW_DOCUMENT (rep_url, '_blank');
END;
When the button is click, it does not open a the report's parameter form, but a blank report page. I've also tried using the run_report_object (a solution found on this forum) but that does the same.
Am I doing something wrong or is there another way to call a report's parameter from a form?


Software/Hardware used:
Oracle 10G
ASKED: October 14, 2011  2:02 AM
UPDATED: October 14, 2011  2:48 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _