how we call report through report

5 pts.
Tags:
Oracle 10g
Oracle Reports
Oracle Reports 10g
how we call report through report in 10g

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do you want to call a report from a froms application ?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Calling a report from a Forms application in Developer 10g, can be done in the following way: -Create a REPORT object in the form. -If the application is going to be tested locally, a report server needs to be started, which can be done with the following command (from a command prompt session):
    rwserver server=repsrv
    Where 'repsrv' is the name of the server -In the form, set the appropriate properties to the report object, run the report, and show it in the browser. Here is a basicexample:
    declare
    	repid REPORT_OBJECT;
    	v_rep VARCHAR2(100);
    	rep_status VARCHAR2(20);
    BEGIN
    	repid := FIND_REPORT_OBJECT('REPORT1');
    	SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'repsrv');
    	SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, CACHE);
    	SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML');
    	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('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1) || '?destype=cache&desformat=pdf/html&server=' || 'repsrv', '_blank');
    	ELSE 
    		message('Error when displaying report in browser'); 
    	END IF; 
    END;
    69,920 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following