Dear Developers AoA,
i am trying to run a report from FORM which has a parameter. i want to send parameter from a text item of FORM.
I am using the following procedure.
PROCEDURE rep_request IS
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(50);
--req_no char(17);
BEGIN
repid := find_report_object('rep_request');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_online_FRHome');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'rep_para='||':blk_top_display.rep_para'||'paramform=no');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
/* Display report in the browser */
WEB.SHOW_DOCUMENT(' http://abc.com.pk/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?','_blank');
ELSE
message('Error when running report');
END IF;
END;
now the problem is:
the report open without data.
the column names and the other text are displayed but the data from tables don't.
what's the problem?
hope you people will help me.
Thanks
Muhammad Nadeem
nadeem14375@gmail.com
how to run a REPORT from FORM which has a paramete
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Who is online
Users browsing this forum: No registered users and 11 guests