Oracle Forms

Hi all,

Re: How do I launch report from menu (and have it print to the screen) using RUN_REPORT_OBJECT?

I am using Oracle 9iAS on Windows 2000 and I have a similar problem with launching reports from the menu. The application should call the report via the RUN_REPORT_OBJECT builtin feature from Forms. The report is never displayed.

The report is in the same folder as the menu form calling it. Do the reports have to be in a specific format? How do I get the report_id?

The name of the report is seconds_calls. No user-specified parameters are passed. Also, the report object in the object navigator in Forms is Report4 (is this relevant?)

When I try to run report via the form using this code:

DECLARE
report_id REPORT_OBJECT;
rep_status VARCHAR2(200);
v_rep VARCHAR2(100);
report_job_id VARCHAR2(200);

-- job_number NUMBER;
-- server_name VARCHAR2(200) := 'repserver';

BEGIN
report_id:= FIND_REPORT_OBJECT('seconds_calls');

rep_status:=REPORT_OBJECT_STATUS(report_job_id);
v_rep := RUN_REPORT_OBJECT(report_id);

END;

I get this error message:
FRM-41219 Cannot find report:Invalid ID

And this message
FRM-40738 Argument 1 to builtin RUN_REPORT_OBJECT cannot be null

-----------------------------------
When I tried to use the same code (above), substituting the object name for the form name,

I got these messages:
FRM-41219 Cannot find report:Invalid ID
FRM-40738 Argument 1 to builtin RUN_REPORT_OBJECT cannot be null
And FRM-10259 Invalid null argument to packaged procedure or function (???)

Any ideas?

Cheers,
Pippa